Abnormal "IF" request

  • Thread starter Thread starter Andrew C
  • Start date Start date
A

Andrew C

Hey all,

Can anyone advise on how to use the if statement, or
another string of commands, on the following scenario:

A row contains relative data (10 cells worth). The final
cell will contain a "1" or "N/A". I would like to have a
macro locate all rows without the "1", cut it, and paste
it on the following sheet at the bottom of the sheet. It
will continually add lines to this new sheet (like a
completed order sheet for instance).

I'm not quite sure if this is explained correctly, so any
feedback would be great, and I can explain further if
necessary.

Thanks,
Andrew
 
do a if statement next to the column you are looking at, if(a1=1,1,"") then create a macro that copies the new if statement that only has the 1's and paste special with values to the new sheet
 
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

Run two macros for two different sheets 11
Create if partial match then copy and paste data from one cell to another 1
Auto Copy Data from one worksheet to another 1
Search , then copy and paste from multiple worksheets. VBA help 1
Combine three InputBoxes into one? 7
Macro to Combine Data from Multiple Sheets with Cell References 4
Key Card Software (Auric) 7
Find a value in a sheet and replace it with another value if it matches 8

Back
Top