Copy to Worksheet question

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
 
D

Dallman Ross

Joanne said:
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.
 
J

Joanne

I read thru Ron de Bruin's work, and I agree, there is a load of
information there. Actually while working on this project, I have read
so much code in these forums and in the links provided in many of the
answers in these forums that I begin to think in code, like reading
Shakespeare a lot and you begin to talk like him!! Seriously, it sure
does help you to learn.

I didn't find anything in his code samples that would address the
problem of how to reflect possible added/deleted rows on the parent ws
when copying to the child ws with a 'constant' last row.

Do you or anyone else have any other ideas? Maybe I am approaching the
project from the wrong direction entirely and should try to come up with
a whole different angle to getting the parent ws into the child ws while
keeping the last 'total formula' column in synch. I'm sure I have no
bright ideas, but I'm 100% open to suggestions or other possible
pointers for finding the answer.
Thanks for your interest in my little problem.
Joanne
 
D

Dallman Ross

Joanne said:
I didn't find anything in his code samples that would address
the problem of how to reflect possible added/deleted rows on the
parent ws when copying to the child ws with a 'constant' last
row.

Maybe just have a private function that re-counts your data rows
each time before the copy of the ws.

-dman-

=================================================
Joanne said:
I read thru Ron de Bruin's work, and I agree, there is a load
of information there. Actually while working on this project, I
have read so much code in these forums and in the links provided
in many of the answers in these forums that I begin to think in
code, like reading Shakespeare a lot and you begin to talk like
him!! Seriously, it sure does help you to learn.

I didn't find anything in his code samples that would address
the problem of how to reflect possible added/deleted rows on the
parent ws when copying to the child ws with a 'constant' last
row.

Do you or anyone else have any other ideas? Maybe I am
approaching the project from the wrong direction entirely and
should try to come up with a whole different angle to getting
the parent ws into the child ws while keeping the last 'total
formula' column in synch. I'm sure I have no bright ideas, but
I'm 100% open to suggestions or other possible pointers for
finding the answer. Thanks for your interest in my little
problem. Joanne

[Dallman Ross wrote:]
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top