thexfactor44
New Member
- Joined
- Feb 21, 2002
- Messages
- 26
I am using FIND in a macro to find any occurance of "name" in Column C of Sheet1. If FIND locates the given "name", I want to copy that row and paste it in the first available row of the neighboring sheet, in this case Sheet2. In this application, the first available row is Row 5 on Sheet2.
This is the main function of the macro. the rest could be called repetition, as I would like to be able to FIND all occurances of "name" on sheet1 and copy the entire row into Sheet2, but the next line to be pasted would obviously have to be Row 6 of Sheet2 as to not overwrite.
I have tried, and I do not know how to select the row N, where N is the number in Column C that "name" was found, and I am also having issues getting XL to paste starting with Row 5 on Sheet 2 and incrimenting. Also, FIND only seems to find it once, how do I get it to repeat throughout?
Thanks to all on this one, I know it is long, trying to be descriptive.
This is the main function of the macro. the rest could be called repetition, as I would like to be able to FIND all occurances of "name" on sheet1 and copy the entire row into Sheet2, but the next line to be pasted would obviously have to be Row 6 of Sheet2 as to not overwrite.
I have tried, and I do not know how to select the row N, where N is the number in Column C that "name" was found, and I am also having issues getting XL to paste starting with Row 5 on Sheet 2 and incrimenting. Also, FIND only seems to find it once, how do I get it to repeat throughout?
Thanks to all on this one, I know it is long, trying to be descriptive.