I am working on 3 different projects at the same time. It's no wonder I can't think.
Anyway. I would like to pull information from one worksheet to another. I would like perhaps a template that will pick up the info from what ever sheet is in front of the template, and insert the info in the desired cells, in the template. I think a template is what I want. in short After I do a sort I want the info to rearrange itself on another sheet so it's in the format the boss wants.
Is there a way to write a formula so it picks up the preceding page info no matter what it's name is? Suggestions?