Excel VBA - 1 Workbook, updating a specified cell in another workbook

[Jiggles]

Hi all,

I am an amateur VBA coder and have encountered a coding issue.

Upon Button Press,
-Workbook1 gathers values from its own worksheets and stores in variables.
-Workbook1 then Opens Workbook2.
-Code in Workbook1 then continues and finds the specific Row# in Workbook2with the specified Data
-Code in Workbook1 continues and finds the Specific Column# based off specific data in Workbook2 Broken Component.
-It will then add data, save Workbook2, then close Workbook2.

For some reason, when it searches the column, it searches Workbook1, not the intended Workbook2. However very similar code allows it to work to find the Row#.

If i haven't confused everyone with what i am trying to achieve, any suggestions would be very helpful. Code is below

Please Login or Register  to view this content.

[antoka05]

See attached file, this is the code I used:

Please Login or Register  to view this content.

Regards,
Antonio

[Jiggles]

See attached file, this is the code I used:
Regards,
Antonio

Thank you greatly Antonio,

Tested and is now working okay.
Loved the Usheet/Osheet idea.

Regards,

Carlin


Note: Placing Issue as Solved.