Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicating data
I have 2 excel worksheets, both are in different formats. Both will
contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicating data
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Lynn" wrote in message ... I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicating data
Without knowing much about what you are doing, its difficult to tell, but if
this is a one off exercise you might be best using formulae to do this task, if its a difference in columns or a change in layout VLOOKUP and HLOOKUP will prove useful "Lynn" wrote: I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating/Mirror Data into another worksheet within same workboo | Excel Worksheet Functions | |||
Duplicating a worksheet minus the data | Excel Discussion (Misc queries) | |||
excel text data duplicating | Excel Discussion (Misc queries) | |||
Auto Duplicating Worksheets and Insterting Data from Different Worksheet | Excel Programming | |||
Duplicating data from sheet 1 to 2,3,4 etc | Excel Programming |