Users are adding rows to worksheets

[pwk]

I have asked several questions during the development of this project,
thanks to all that responded. The users are starting out with a
'clean' workbooks one or two data collection clerks have added several
rows to several of the worksheets below collected data...
How can I programmably “compare” old and new worksheets and remove the
rows they added before copying and pasting. I would like to make sure
rows 4-11, 17-23, and 29-34 remain where they were originally
located. Each cell B4, B17, and B29 have unique names in the original
that I could use to compare worksheets. I’m stuck, any help would be
appreciated. I hope to become adept enough to answer future questions
like this for others

 

[Roland]

If your data has headers or a specific cell that shows the beginning you
could use cells.find to find that cell in the new worksheet and then
manipulate it however afterwards.

 

[pwk]

If your data has headers or a specific cell that shows the beginning you
could use cells.find to find that cell in the new worksheet and then
manipulate it however afterwards.  
--
Roland





- Show quoted text -

I would like to loop through all worksheets in a combined workbook of
up to 60 sheets checking them and making repairs necessary, so they
all match up.