View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default VBA Code for Pasting Sheets

I would like a spreadhseet that pastes the contents of one sheet into another
sheet. I like like to do this for 7 different sheets

For example:

I would like paste the contents form sheet titled "sheet1" into a sheet
titled "data1". Continue to process for pasting "sheet2" into "data2" and
"sheet3" into "data3" all way until "sheet7" and "data7".

thanks,

Curt


Subject: Automated Copy Paste

Subject: Copy/Paste Import/Export Data VBA Code