Extracting Multi-sheet values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many sheets with the same design, but on different "subjects". For example product1, product2, product3, etc...and I need to collect price-cell and 3 o 4 additional data from those products,into a summary-sheet. Is any easy way to create the summary-sheet and being able to repeat the formulas to collect the needed information?.
 
Jorge, the Spreadsheet Assistant add-ins, available at
http://www.add-ins.com, has a feature that does just what you want. You
would preselect the sheets, then you would b prompted for the range to
extract and the destination.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Jorge B Domic said:
I have many sheets with the same design, but on different "subjects". For
Click to expand...
example product1, product2, product3, etc...and I need to collect price-cell
and 3 o 4 additional data from those products,into a summary-sheet. Is any
easy way to create the summary-sheet and being able to repeat the formulas
to collect the needed information?.
 
Back
Top