View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bartek Bartek is offline
external usenet poster
 
Posts: 1
Default for each worksheet ...

Hi all,
briefly saying,
I need to construct a sets of date coming from two workbooks.
Each workbook has identical collection of sheets(same names) with
different data.
I would like to run a procedure that for each worksheet in Workbook1
copies a range of data into Workbook "SUM" and the same range out of
respective worksheet from Workbook2 again into Workbook "SUM"
Then after I have data from them both I can do sth. (create graph) and
then go to next worksheet in Workbook1

Oh wow hope it is OK to understand
thanks in advance,
Bartek