Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy work sheet to another work book, pros and cons
Hello - i need advice/code for the best way to copy a worksheet from one
(sometimes closed) workbook (Source.xls) to another open workbook (Main.xls). Main then uses the newly pasted info on sheet 4 to run a vlookup on the data from sheet 3. My problem that by pasting links the data is not reliable. It doesnt always update when the Source is altered (eg when a row is deleted) meanting that the vlookup on sheet 3 in the Main.xls does not always 'find' a cell to return. Very frustrating. I'm now thinking that the only way to have reliable data on sheet 4 of the Main.xls is to have the Main.xls open the Source.xls on startup and copy accross the data, each time Main.xls is opened. Can anyone help me understand; 1. If pasting links can be made to work better? 2. the code for copying over the work sheet on Main.xls start up 3. Whether there is a better way of doing this? 4. Anthing else to consider? Thank you, W |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy work sheet to another work book, pros and cons
http://spreadsheetpage.com/index.php...a_closed_file/
or u can use save as option On Oct 21, 2:18*pm, Withnails wrote: Hello - i need advice/code for the best way to copy a worksheet from one (sometimes closed) workbook (Source.xls) to another open workbook (Main.xls). Main then uses the newly pasted info on sheet 4 to run a vlookup on the data from sheet 3. * My problem that by pasting links the data is not reliable. *It doesnt always update when the Source is altered (eg when a row is deleted) meanting that the vlookup on sheet 3 in the Main.xls does not always 'find' a cell to return. *Very frustrating. I'm now thinking that the only way to have reliable data on sheet 4 of the Main.xls is to have the Main.xls open the Source.xls on startup and copy accross the data, each time Main.xls is opened. * Can anyone help me understand; 1. If pasting links can be made to work better? 2. the code for copying over the work sheet on Main.xls start up 3. Whether there is a better way of doing this? 4. Anthing else to consider? Thank you, W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pros/Cons of having users Trust the VBA Project | Excel Programming | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
Find and copy across multi-sheet work book | Excel Programming | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Excel as a development Platform? pros and cons? | Excel Programming |