Jagwarman
asked on
find and copy
I am looking for some vba code that will find the word Stock the copy all cells below that contain data and then to the right
i.e. It cell A5 contains Stock and all cells down to A16 have data and cells right to F15 have data copy A5:A16
Thanks
i.e. It cell A5 contains Stock and all cells down to A16 have data and cells right to F15 have data copy A5:A16
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rgonzo1971
Nothing is ever simple is it :-)
I have used this on another file and it is not doing what I thought it was going to do.
The file I am now working on has the same word in A1 G1 and H1 so it goes to G1 and copies from there.
Probably my fault, I need it to start from the first occurance [in this case A1] so if A1 did not have the the word I am looking for and the first occurance was G1 that would be ok.
Can you make the amendment for me pleae.
Many thanks
Regards
Nothing is ever simple is it :-)
I have used this on another file and it is not doing what I thought it was going to do.
The file I am now working on has the same word in A1 G1 and H1 so it goes to G1 and copies from there.
Probably my fault, I need it to start from the first occurance [in this case A1] so if A1 did not have the the word I am looking for and the first occurance was G1 that would be ok.
Can you make the amendment for me pleae.
Many thanks
Regards
ASKER