View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pietro Pietro is offline
external usenet poster
 
Posts: 62
Default Copy excel sheet to another sheet

Hi all,
I want to create a VB code to copy the data from another Excel sheet
called "MSCSAT" specifically from a tab called "MSCSAT" Columns
A,B,C,D,E,F,G,H,I,J,K,L,M knowing that the location of this sheet is
"F:\Access\C-SAT\MSCSAT.xls", into the main excel sheet,that contains the
button that will carry the action,the main excel sheet is called "Template"
located in "F:\Access\C-SAT\Csat Template.xls"
Then i want to save and close both sheets automatically..
I sit possible?