VBA check range for matching rows

[Cooki]

Hi All

I have some data that has been input into a system and i have the export from that system as well.

I need to check if the data has been input correctly or not

Workbook1 has that data that has been input into the system

Workbook2 has the export.

There are multiple tabs on each, but each tab is called the same.

On workbook1 data starts from A2 and goes to K400

Workbook2 data starts from B2 and goes to L400

So basically i need to make sure that each set of row data has been into into workbook2 correctly and if not highlight red or something to show where the error is.

TIA

Rich

 

[Cooki]

Oh right got ya, no there is nothing unqiue in any of the coulmns. As the data will be changing each month..

Ive managed to do it with a formula, but thought VBA would make it automated.

Dam

Thanks anyways

 

[JLGWhiz]

Set sh1 = master.M3633E17
Set sh2 = output.M3633E17

These will not yield valid sheet references and that is why you got the 424 error.

Try.

Set sh1 = Workbooks("Master.xlsm").Sheets("M3633E17")
Set sh2 = Workbooks("output.xlsx").Sheets("M3633E17")

You might need to change the file extensions on the workbooks.

 

[Cooki]

Set sh1 = master.M3633E17
Set sh2 = output.M3633E17

These will not yield valid sheet references and that is why you got the 424 error.

Try.

Set sh1 = Workbooks("Master.xlsm").Sheets("M3633E17")
Set sh2 = Workbooks("output.xlsx").Sheets("M3633E17")

You might need to change the file extensions on the workbooks.

Getting runtime error 9

Subscript out of range

 

[JLGWhiz]

Did you read post #12? You have to use the correct syntax to set the variables for your worksheets.
The syntax for the workbook is: Workbooks("workbook name.extension")
The syntax for the sheet is: Sheets("sheet name")