Help with Duplication formula please!

**cstahlhut** · 08-30-2012, 11:39 PM

Hi,

I have this macro that does what I want it too.

Please Login or Register  to view this content.

Except I would like it to go through all worksheets, at the moment I change the Sheet2 part of the macro in this part to the name of the other worksheet: - "Set rng2 = Worksheets("Sheet2").Range("C:C")"

Can anyone please tell me how I can change this to cycle through all Worksheets in the Book without me manually having to name each sheet and have it perform the same function? I have attached a sample worksheet with the macro, as you can see it only does Sheet A, I want it to do both Sheet A AND Sheet B if possible?

Thanks!

Sample Data.xlsm

**JBeaucaire** · 08-31-2012, 12:18 AM

The first time through the rng1 is on sheet1 and the rng2 is on sheet2.

What would the sheets be the second time through? The next?

--------By the way, you know you can do this with no macro at all? You can apply Conditional Formatting to the cells in column C on the SheetA and SheetB to color themselves if they hold a value that matches a cell in column A of Sheet1?

Here's your sheet back with that installed. Just change the Sheet1 column A values and watch the color highlights change on the other sheets.

**cstahlhut** · 08-31-2012, 12:29 AM

Thanks for your help, I am actually going to change the macro to delete the matching row instead of colour it, so basically it will go through and automatically remove all rows that match what's in Sheet1 instead of just coloring them. Plus in the actual data file I want to do this there are 22 sheets and then multiple spreadsheets so I wouldn't want to manually do this every time, haha.

Sheet 3, 4, 5, 6 etc would all look the same and have the same format, basically I want rng2 to not just do one sheet I want it to do all sheets except sheet1 which is my masterfile for what to delete :D

Originally Posted by JBeaucaire

The first time through the rng1 is on sheet1 and the rng2 is on sheet2.

What would the sheets be the second time through? The next?

--------By the way, you know you can do this with no macro at all? You can apply Conditional Formatting to the cells in column C on the SheetA and SheetB to color themselves if they hold a value that matches a cell in column A of Sheet1?

Here's your sheet back with that installed. Just change the Sheet1 column A values and watch the color highlights change on the other sheets.

**cstahlhut** · 08-31-2012, 10:44 AM

This was solved in another thread http://www.excelforum.com/excel-prog...lications.html

**Cutter** · 08-31-2012, 09:07 PM

Hello cstahlhut, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.