In , Joanne
spake thusly:
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.
Maybe Ron de Bruin's well-done sample set for pasting and merging
worksheets and workbooks will be the ticket for you.
http://www.rondebruin.nl/tips.htm
See the Copy/Paste/Merge examples.
--
dman