Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Users are adding rows to worksheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Users are adding rows to worksheets
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 "pwk" wrote: 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. Im stuck, any help would be appreciated. I hope to become adept enough to answer future questions like this for others |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Users are adding rows to worksheets
On Feb 16, 1:42*pm, Roland wrote:
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 "pwk" wrote: 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- Hide quoted text - - 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to prevent users from adding new worksheets | Excel Worksheet Functions | |||
Prevent users from adding rows in Excel 2000 | Excel Discussion (Misc queries) | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
adding rows to several worksheets | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |