J
Joanne
I have a worksheet on my master workbook.
I need to make a copy of one of it's worksheets to a child workbook.
This I know how to do alright.
My problem is that when I paste the ws from the parent wb to the child
wb, I am pasting the info up against a 'last column' on the child - and
if there has been row added or a row deleted from the parent wb, when I
paste to the child wb the last column becomes out of synch with the rows
because it doesn't reflect the change from the parent.
In other words, I paste 45 rows and 10 columns from parent to child, but
child has this 'constant' last column that has 46 rows in it. Now when I
paste my parent 45 rows, somewhere on child there is an extra row in the
last column because of a change on the parent wb.
Row A on both wbs is 'item' and they are unique to each row but
identical on each worksheet. I was thinking that perhaps I should loop
thru col A on both wbs to see if they '=' each other. If they do, great,
paste and go to the next one. But if they don't, I could insert a row
and paste - but that will only work if it is an additional row to the
ws. If it is a deleted row that caused the discrepancy in rows between
the wbs, I have no clue what to do or how to detect that's what the
change is.
Can anyone give me a nudge to get me started on solving this problem?
I sure do appreciate it.
TIA
Joanne
I need to make a copy of one of it's worksheets to a child workbook.
This I know how to do alright.
My problem is that when I paste the ws from the parent wb to the child
wb, I am pasting the info up against a 'last column' on the child - and
if there has been row added or a row deleted from the parent wb, when I
paste to the child wb the last column becomes out of synch with the rows
because it doesn't reflect the change from the parent.
In other words, I paste 45 rows and 10 columns from parent to child, but
child has this 'constant' last column that has 46 rows in it. Now when I
paste my parent 45 rows, somewhere on child there is an extra row in the
last column because of a change on the parent wb.
Row A on both wbs is 'item' and they are unique to each row but
identical on each worksheet. I was thinking that perhaps I should loop
thru col A on both wbs to see if they '=' each other. If they do, great,
paste and go to the next one. But if they don't, I could insert a row
and paste - but that will only work if it is an additional row to the
ws. If it is a deleted row that caused the discrepancy in rows between
the wbs, I have no clue what to do or how to detect that's what the
change is.
Can anyone give me a nudge to get me started on solving this problem?
I sure do appreciate it.
TIA
Joanne