Pulling values from one sheet to another sheet that is entirely dynamic

**vegasboy423** · 06-25-2013, 02:46 PM

Hello,

I have some inventory software at work that exports monthly inventory reports into excel format. The sheet it exports to is not a very nice looking readable format. I would like to make a second excel spreadsheet that is completely dynamic, except for the column headers, that pulls info from the first sheet. I have attached the spreadsheet I am working with. In the attached document Sheet A is the info exported from the inventory software and sheet B is the sheet I would like to be dynamic. I have written in plain English what I would like each formula to do. I only have basic knowledge of excel formulas like =SUM.

Any help would be much appreciated.

Thanks!

-Art

**Craig K.** · 06-25-2013, 03:59 PM

You're basically asking us to help you reverse the reporting process. It would be easier to see if your inventory software has the option to do a raw data extract instead of the canned report you have. Sometimes they're called CSV files.

**BB1972** · 06-25-2013, 03:59 PM

Hi Art - welcome to the forum. You're right about the sheet not being very "readable"

Can you clarify if Sheet A Cell B8 ("Manufacturer") is a heading? If it is a heading, is it likely to be static / on all the reports that end up on Sheet A? If so, it's redundant, and is not required as part of your "IF" statement. Same question goes for Sheet A Cell D8 ("Model"), etc.