Help with formula to automatically pull information from one tab into another

[mttmrrsn]

I receive a detailed sales report each week and I'm asked to create tabs in the workbook for specific calculations based on the data (total sales, delivery times, quantity sold, etc...). The sales reports as a whole aren't always structured the same but the columns I use for my calculations always the same. I'm thinking that if I create a template and copy the report into my template with the same tab name each time then I can create some sort of formula in each tab that will pull column data based on the headers. Is this possible and if so can someone point me into the right direction to research how I could create the formulas?

Thanks

 

[Chrisdontm]

I believe you are on the right track.
Formulas could be created for what you are describing.
You would want to get it laid out how you see the template.
Put some dummy information into it, with various examples of course.
Go ahead and put the numbers in the cells where you want them, and tell where they need to come from.
Then come back and post an example sheet using Dropbox.com or something like that.
And someone ought to pick up and help you with some formulas.
I would guess that they will be using the INDEX and MATCH formulas...plus others here and there...

 

[mttmrrsn]

Sorry for the delay, my sample report can be found at the following url https://drive.google.com/folderview?id=0B2VhOVPaZKzBNU9pUXM1UnVUNEE&usp=sharing

The first tab, Report, will be what I am given on a weekly basis and the remaining tabs are what I calculate.

Thanks!

 

[Chrisdontm]

Attached is a template I put together.
The other pages/tabs are not connected to it with formulas, it is just the template you are talking about wanting.
So you will want to copy the new report onto the first tab, over what is there, then the second tab, called " Template Report", will extract the info over regardless of which column is listed first...
That way you should be able to copy over Data consistently onto the other tabs.
I have a few extra columns in the mix, with the blue header row, in case you want to have it extract any other information you can put it there...


https://www.dropbox.com/s/ka6lt9dsej2r9pq/Generic Report-MttMrrsn.xlsx?dl=0