Windows XP macro

B

BB22

Joined
Jul 13, 2009
Messages
2
Reaction score
0
hi,

I am trying to create macro which will allow me to search for text in column and will copy all rows wich includes the searched text to another worksheet. This macro should start by pressing button with text.

e.g.

I have column A:AA in Sheet1
By clicking on Button named "COF" in Sheet1I want to start macro.
I want to search for text "COF" in column "A" starting with row 23 in Sheet1.
All rows including "COF" I want to be copied to "Sheet2" starting with row 13.
But I want to copy only columns A:W (notA:AA) to "Sheet2"

Not sure whether you need anymore details

PLease can you help?

Thanks

BB22
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows XP macro to search in column with formulas 0
Can I send an email too? 3
Excel Macro to copy a row to another sheet based on date 0
Excel 2013 Merge Data 2
Duplicating cell values from one sheet to another 3
Macro Question 3
Sorting, replacing data 1
loop to copy paste 5

Top