Completely stuck with a project I'm working on - apologies if there is a simple answer, I'm learning VBA as I go along...
I have a cell (K62) on workbook 1 within which which users specify a number between 1-31 (ie days of the month). I need the macro to find the corresponding number within row 6 of workbook 2 (from D6-AH6). I then want to select the matching cell from workbook 2 to locate the correct column.
I would share what I've got so far, but to be frank, I don't have a clue where to start after 2 hours of research via Google and several failed attempts!
Any assistance would be greatfully received, and this is my first post having just registered so please be gentle!
I have a cell (K62) on workbook 1 within which which users specify a number between 1-31 (ie days of the month). I need the macro to find the corresponding number within row 6 of workbook 2 (from D6-AH6). I then want to select the matching cell from workbook 2 to locate the correct column.
I would share what I've got so far, but to be frank, I don't have a clue where to start after 2 hours of research via Google and several failed attempts!
Any assistance would be greatfully received, and this is my first post having just registered so please be gentle!