macro to transfer data from one workbook to another workbook

macropod · #1 01-31-2011, 01:59 AM

Hi virsojour,

Is there a reason both sets of data can't be kept in the same workbook (eg on different worksheets)? And what is the purpose of the data replication?

virsojour · #2 01-31-2011, 05:55 AM

Macropod,

I plan to link excel files between pcs in a network. If not possible through pcs in a network. At least it would be easier for users to select the only file they need to update, and not have to open the consolidated file and browse through sheets...

Thanks macropod

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unable to open Excel 97-2003 workbook	J Partridge	Excel	1	11-07-2010 03:26 AM
"Workbook not saved" message	Lesq	Excel	0	07-23-2010 01:59 AM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM
Share Workbook cannot merge	Ichigo	Excel	3	01-19-2010 03:05 AM