View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Irmin Steve Irmin is offline
external usenet poster
 
Posts: 1
Default copying data from multiple worksheets

I have data in the same area (E8..E57)on multiple (22) worksheets. I need to
copy these 22 columns into one worksheet displaying each column separately.
Now I can copy the first column into the destination worksheet, but can I
copy that column so that worksheet reference changes only. ( I would make
the cells absolute references)