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