Referncing Information Across Multiple Sheets

[QLH]

Hello Everyone, I am in a pickle because I created a report for a specific purpose and (of course!) my boss changed the parameters after it was already received. So here is the problem: I have two separate sets of data across two different sheets in an excel workbook. The first sheet is Raw Data (i.e. not filtered from the original format) the second sheet is a copy of the raw data sheet filtered to include only some of the line items from the first. This second sheet was supposed to be the end of it all, but now I need to figure out a way to get information from the first sheet to pull to the second sheet based on a reference number that would link multiple line items. I am not even sure where to start, so any help would be appreciated.

 

[QLH]

Can anyone help me out? I am not looking for a formula, per se, just need someone to point me in the right direction.

 

[Sandcastor]

Yup, same as on 2010. I myself added that command to the quick shortcuts list at the top of the application, too.

 

[QLH]

I'm sorry, I don't understand what you're trying to say.

 

[Sandcastor]

Weird. My last post was on a different thread, and ended up here for some reason.