VBA sheet loop only updating active open sheet

Hello all,

I am in a bit of a dilemma, I have created a VBA loop to cycle through all sheets in my open workbook and look for two values which appear in certain columns on the same row. However, it only finds the value I need it to if the sheet is active (I need it to cycle through all sheets).

Ideally once a match is found, I require it to copy a cell value on another worksheet and paste it on the same row as the found values but in another column.

As a breakdown, I need the code to:

1. Search all sheets to find a match for the value on the ‘QC Release’ sheet (Cell J61) AND a match for the value on the ‘QC Release’ sheet (Cell K61) on the same row. The match for J61 will always appear in column F of the searched sheet and the match for K61 will always appear in column B of the searched sheet.

2. Once the row with matches on it has been identified on a sheet, I need the code to copy cell N61 on sheet ‘QC Release’ and paste it into column J of the identified row.

The match we are searching for will only appear once on one sheet across all searched sheets.

I would appreciate any help any of you can give me, my head in going in circles. To give you some idea this is my code below… Many thanks!!

Please Login or Register  to view this content.

Hi Mumps1,

Thank you for your quick reply, unfortunately this hasn't worked - I tried using ws.Cells previously to no avail! It stops finding any matches if I do it that way