Find value and update date in different column

[Eugene123]

Hello everybody.
I'm struggling with setting up my table and automatically update it through by macro. My excel 2007 file has 2 sheets. Sheet1 - I'm entering the current date in A9, and entering product No (1-3 digit) in A16.
My Sheet2 has table with 8 columns. Column A with Product Numbers. Column F with dates that I need to update.
I want to run search from Sheet1 for exact match of the value in column A on Sheet2 (need to find value entered in A16 sheet1), then go horizontally to Column F, and update the cell with the date for this product (referencing on A9 sheet1).
I have been trying to record macro using find feature, but so far with no luck. Looks like when I copy cell A16 and paste it to Find feature, it gets stuck, and if reenter different number in A16, it still runs as previous entry. I'm not very proficient with VBA coding, and just know the basic.
Any help would really help.
Thank you

[mehmetcik]

Hi

Maybe you are over complicating this.

Why do you need to enter the date manually?

Why do you need a find or match or lookup when you can use your part number as the offset to find your cell.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Eugene123]

I've got the date figured out already, and under normal circumstances it would be a current date as a default, but sometime I need to change it.

[Eugene123]

John, it works. Thank you very much. I like it.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.