I have multiple data sheets that are formatted the same. Each one corresponds to a month of data.
I need to take this data and, on a separate sheet, do a comparison of one field across time.
For example, cell B4 on each data sheet contains "Price of Widgets". Each data sheet covers a single month so I have one for January, one for February, etc.
I need to create a separate worksheet that pulls the data from each B4 cell from each sheet and displays all "Price of Widgets" from January onward. Is there an easy way to do this?
2007-03-07
04:01:02
·
3 answers
·
asked by
Anonymous
in
Software