Specify which worksheets to compare

**Wagstaff** · 08-27-2010, 07:28 AM

Hi Everyone,

I have a problem and am hoping someone can help.

I have a code that compares data between 2 sheets and populates sheet"compare" with the old and new values, I would like the macro instead of having pre-defined sheet names to be able to have an input box that the user types in which sheet they want to compare.

I have tried to myself but I just get errors

Can anyone assist me please

My code is

Please Login or Register  to view this content.

The code then enters a formula and then I do some formatting.

Hopefully you can see where I have tried to modify the code to include an input box

Thanks
Wagstaff

**Domski** · 08-27-2010, 08:00 AM

This might interest you that Cheeky Charlie posted:

http://www.excelforum.com/2357813-post36.html

I've put together an example workbook to show how it would work.

Hope it helps,

Dom

**Cheeky Charlie** · 08-27-2010, 10:34 AM

Gosh that's beautiful...

**Domski** · 08-27-2010, 10:53 AM

See, it wasn't a waste of your time after all

Dom

**Wagstaff** · 08-27-2010, 02:09 PM

Thanks Dom for taking the time out to reply

I have tried all day to try to use your suggestion but I just could not get it to work, this is more than likely due to my inexperience, however I did find a solution so I have posted below

Please Login or Register  to view this content.

The changes I made were

Please Login or Register  to view this content.

Then just changed the named worksheets to ws1 and ws2

Thanks again
Wagstaff

**Cheeky Charlie** · 08-27-2010, 03:37 PM

If you want to see it working, upload an example and we can show you, presume you tried the example Dom uploaded?

**Wagstaff** · 08-28-2010, 02:22 AM

Hi CC,

Attached is a sample file I was working with

When you select the first sheet "Lane 49" for the first choice, ok

Then select the second sheet "Lane 50" for the second choice, ok

When I then try to use the "Compare Data" button I get getting a runtime error 9, subscript out of range which highlights on this part of the code

Please Login or Register  to view this content.

It it because this is no longer the active sheet? As I have selected " Lane 50" with my second selection.

If you can let me now if I have used your code correctly that would be good and also what I have done wrong.

Thanks
Wagstaff