View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach[_2_] Jef Gorbach[_2_] is offline
external usenet poster
 
Posts: 65
Default VBA Code for Pasting Sheets

On Apr 27, 10:49*am, Curt wrote:
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


there are numerous ways to doing it depending on your needs
are you coping the entire sheet or just certain rows/columns?
do the data sheets already exist? have contents? replace or append?