Benjamin_Hogan
New Member
- Joined
- Mar 10, 2010
- Messages
- 16
Dear Experts,
I would like to be able to find a name I’ll enter in Cell G4 [Column G] in a database that starts a few rows below in Worksheet [NOTE JOURNAL 3] – when the cursor goes to the first match, I should be able to Click on the button with the macro in question and continue searching down to find the next match and so forth and so on.
In a different module I would like the cursor to move from the selection of the found and looked for name, 2 columns back to the left [to column F] and then select for that row the range from columns [E to O] to Copy it and then Paste/ Special/ Value/ Transpose into Worksheet [Notes Tool] Range G9:G18 and then to copy in the same row of [NOTE JOURNAL 3] at column R and Paste it / Special/ Value/ into Worksheet [Notes Tool] in Cell G12.
Thank you very much for your kindness and help . . .
Marco.-
I would like to be able to find a name I’ll enter in Cell G4 [Column G] in a database that starts a few rows below in Worksheet [NOTE JOURNAL 3] – when the cursor goes to the first match, I should be able to Click on the button with the macro in question and continue searching down to find the next match and so forth and so on.
In a different module I would like the cursor to move from the selection of the found and looked for name, 2 columns back to the left [to column F] and then select for that row the range from columns [E to O] to Copy it and then Paste/ Special/ Value/ Transpose into Worksheet [Notes Tool] Range G9:G18 and then to copy in the same row of [NOTE JOURNAL 3] at column R and Paste it / Special/ Value/ into Worksheet [Notes Tool] in Cell G12.
Thank you very much for your kindness and help . . .
Marco.-
