Finding a specific text in excel cell

[dana2002]

Hi All;
I want to use loop to find a specific text ( Drawing Name) in an excel range, make that cell active, copy the data from the cell in the column accross from the cell containning the ( Drawing Name) to another excel work book, at the same time I want to move to the cells below it, once at a time & copy the data from the cell in the column accross from them to another work book. then I want to move to the next cell containing ( Drawing Name) & do the same as I did above.
I want to loop through the range until I can not find any more cells that contain
a text called (Drawing Name).
Sample text below:
Your help to coomplish this task is greatly appreciated.
Thank you in advance in your help.
Regards



Version 1
Nest header
Program
Customer name
Date programmed
Material
Programmed by
Machine
Comments
Remarks
Job costing
Total cutting time
Drawing Name x52090-A
Revision
Qty Req N/A
Qty Nstd 1500
Qty Rem N/A
Cut/Scribe Dist 12.27 / 0.00
Cut Time 0:00:16
# of Pierces 2
Intersections
Cost per part $0.35
Weight Net1/Net2/Gross 0.53 / 0.77 / 0.67
% of Material 1.01%
% of Time 2.63%
Revision
Drawing13
Customer Name
Drawing Name 52k097
Revision
Qty Req 250
Qty Nstd 250
Qty Rem 0
Cut/Scribe Dist 12.01 / 0.00
Cut Time 0:00:13
# of Pierces 1
Intersections 2
cost per part $0.30
Weight Net1/Net2/Gross 0.46 / 0.67 / 0.51
% of Material 0.15%
% of Time 0.37%
Revision
Drawing12
Customer Name
Drawing Name 52160
Revision

[bartonc]

Unfortunately, Dana, I've had to move your post to the Miscellaneous Questions Forum. An Excel Forum may be something that the Admins should look into in the near future, but for now, this is the best that we can do.

My Excel skills are so rusty that I can not be of assistance writing a loop.
I hope that someone comes along that will be able to help you out.

Thanks for joining.