View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
t.o.
 
Posts: n/a
Default copying the same cells from many sheets

hello
how I can copy the same cells from many sheets.
and paste all cells as a table to the new sheet
for exemplar cell A1 from sheets 1,3,5,7, etc... till 500
cell B3 from sheets 2,4,6,8, etc... till 500
and copy to the newsheet to cells B3:B50
Any help appreciated
thx tom