| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| In EXCEL copy sheet layout to another sheet | Excel Discussion (Misc queries) | |||
| How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
