View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default Copy to Worksheet question

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