Benjamin_Hogan
New Member
- Joined
- Mar 10, 2010
- Messages
- 16
Dear Experts,
I wonder if any of you could please help me with the following dilemma.
I’d like to be able to search for a name stored in Cell G3 of the Worksheet called NOTE JOURNAL 3, down on column G, so that if the one is found is not the one I want, when Click on the button, the macro will take it from there to the way down. When the correct match is found, I would like to move 1 column to the left [Column F] and from there, at that row, to select from column F to column O. Then to copy/paste special/value/ transpose into range G9 to G 18 of the Worksheet called Notes Tool. To finish be able to do almost the same thing for column R of the Worksheet called NOTE JOURNAL 3 [at the same row where the name was last found] and then copy/paste special/value/into Cell G12 of the Worksheet called Notes Tool.
I appreciate a lot your help and wish you all the best. Thank you very much . . .
Marco.-
I wonder if any of you could please help me with the following dilemma.
I’d like to be able to search for a name stored in Cell G3 of the Worksheet called NOTE JOURNAL 3, down on column G, so that if the one is found is not the one I want, when Click on the button, the macro will take it from there to the way down. When the correct match is found, I would like to move 1 column to the left [Column F] and from there, at that row, to select from column F to column O. Then to copy/paste special/value/ transpose into range G9 to G 18 of the Worksheet called Notes Tool. To finish be able to do almost the same thing for column R of the Worksheet called NOTE JOURNAL 3 [at the same row where the name was last found] and then copy/paste special/value/into Cell G12 of the Worksheet called Notes Tool.
I appreciate a lot your help and wish you all the best. Thank you very much . . .
Marco.-
