Programming Help - evaluate, select and Past into new workbook

  • Thread starter Thread starter Chewy667
  • Start date Start date
C

Chewy667

I would like to create a macro that evaluates certain value in Column A
If they are equal to a certain number or text then select and past int
a new workbook.


For Example :
UNIT Organization
02 110102000003
02 110102000004
02 110102000004
02 110102000004
03 110103000001
04 110104000300
04 110104000301
04 110104000302
04 110104000303
04 110104000304
05 110105000305
05 110105000305
05 110105000305
05 110105000305

I want the macro to select all the rows that have Unit = 02 and the
paste into a new workbook.

Please Hel
 
Use the Autofilter on the Unit column. Then select the data and copy. Only
the visible rows will be copied

Turn on the macro recorder while you do it manually and you will have your
code.
 
You must log in or register to reply here.

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

Find then highlight in yellow 6
Formula Help: Monthly Statistics 2
Autofil on variable rows, delete extract and show remaining rows 3
Merge various cells value in one row into one cell 3
Lottery combinations 2
Insert and propagate Rows - based on a format rule 4
Add to a "number as text" 10
Copy row to new sheet if cell data is repeated more than 3 times 2

Back
Top