Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003: Copy rows from one workbook into another without losinginterleaved data
Hi All,
I have workbook#1 which contains rows of information which I need to copy into workbook#2. This is simple the 1st time but the data in workbook#1 does change and therefore periodically I need to update workbook#2 with the new data. The problem is that in workbook#2 in between the rows new rows shall be inserted containing other information. When I update #1=#2 I do not want to lose the new rows. So: WB#1 WB#2 Needed Outcome 1 AAAA AAAA 1 to 1 2 BBBB 1111 3 CCCC BBBB 2 to 3 4 DDDD 2222 5 CCCC 3 to 5 6 3333 7 DDDD 4 to 7 I hope I have explained this clearly enough. I have tried to set a filter in WB#2 so that only the ABCD rows are shown and then manually copied across however excel is too clever and instead copies the data over the 1234 rows. If someone can help then it is appreciated. Thanks Steve |
#2
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003: Copy rows from one workbook into another without losing interleaved data
I think the VLOOKUP FUNCTION should work for what you are wanting to do...
http://www.techonthenet.com/excel/formulas/vlookup.php Mark Ivey "Steve Bentley" wrote in message ... Hi All, I have workbook#1 which contains rows of information which I need to copy into workbook#2. This is simple the 1st time but the data in workbook#1 does change and therefore periodically I need to update workbook#2 with the new data. The problem is that in workbook#2 in between the rows new rows shall be inserted containing other information. When I update #1=#2 I do not want to lose the new rows. So: WB#1 WB#2 Needed Outcome 1 AAAA AAAA 1 to 1 2 BBBB 1111 3 CCCC BBBB 2 to 3 4 DDDD 2222 5 CCCC 3 to 5 6 3333 7 DDDD 4 to 7 I hope I have explained this clearly enough. I have tried to set a filter in WB#2 so that only the ABCD rows are shown and then manually copied across however excel is too clever and instead copies the data over the 1234 rows. If someone can help then it is appreciated. Thanks Steve |
#3
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003: Copy rows from one workbook into another withoutlosing interleaved data
Mr. Steve Bentley,
Please refer to, Copy Paste Special Paste Link. 1. Copy from WB1 location. 2. Select WB2 location ; make use of Paste Special dialog box. 3. Paste Link onto WB2 location. Regards. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003: Copy rows from one workbook into another withoutlosing interleaved data
Steve Bentley wrote:
Hi All, I have workbook#1 which contains rows of information which I need to copy into workbook#2. This is simple the 1st time but the data in workbook#1 does change and therefore periodically I need to update workbook#2 with the new data. The problem is that in workbook#2 in between the rows new rows shall be inserted containing other information. When I update #1=#2 I do not want to lose the new rows. So: WB#1 WB#2 Needed Outcome 1 AAAA AAAA 1 to 1 2 BBBB 1111 3 CCCC BBBB 2 to 3 4 DDDD 2222 5 CCCC 3 to 5 6 3333 7 DDDD 4 to 7 I hope I have explained this clearly enough. I have tried to set a filter in WB#2 so that only the ABCD rows are shown and then manually copied across however excel is too clever and instead copies the data over the 1234 rows. If someone can help then it is appreciated. Thanks Steve Thanks for both replies. In the end I got a macro to work which will update the 1st workbook to update if a change occurs in the 2nd workbook. I linked the cells in the 1st workbook to the 2nd. ....Which leads to another question which I'll post separately. Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy excel workbook to new workbook without data | Excel Worksheet Functions | |||
copy rows to another workbook | Excel Discussion (Misc queries) | |||
Can I copy data from only the visible rows in Excel? | Excel Discussion (Misc queries) | |||
For Excel 2003: Is there a way to copy and paste a row of data to. | Excel Discussion (Misc queries) | |||
Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) |