|
Using COPY with an IF formula
I have a spreadsheet that looks like this ID# HF1 HF2 HF3 HF4 MD 222 y y n y Smith 333 y n n n Jones 444 y y y y Jackson 555 y y n y Jackson and so on I need to copy the row(s) for each MD and place them into a row in another workbook. I was wondering if there is some way that I could combine the IF statement and the COPY statement. Something like =IF(MDcolumn,"smith",copy row). Maybe using an IF statement is not the way to solve this problem. I am open to other ways to do this, no ideas turned away! Thanks in advance! Mike -- burnsbyrne ------------------------------------------------------------------------ burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153 View this thread: http://www.excelforum.com/showthread...hreadid=543733 |
Using COPY with an IF formula
I had forgotten about using filter. It looks like using autofilter will make the job go faster. I'll be able to isolate the rows containing a certain name and just copy the row to the other worksheet. Thanks for your suggestion! Ardus Petus Wrote: Have a look at Menu DataFilterAutomatic filter & Advanced filter HTH -- AP "burnsbyrne" a écrit dans le message de news: ... I have a spreadsheet that looks like this ID# HF1 HF2 HF3 HF4 MD 222 y y n y Smith 333 y n n n Jones 444 y y y y Jackson 555 y y n y Jackson and so on I need to copy the row(s) for each MD and place them into a row in another workbook. I was wondering if there is some way that I could combine the IF statement and the COPY statement. Something like =IF(MDcolumn,"smith",copy row). Maybe using an IF statement is not the way to solve this problem. I am open to other ways to do this, no ideas turned away! Thanks in advance! Mike -- burnsbyrne ------------------------------------------------------------------------ burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153 View this thread: http://www.excelforum.com/showthread...hreadid=543733 -- burnsbyrne ------------------------------------------------------------------------ burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153 View this thread: http://www.excelforum.com/showthread...hreadid=543733 |
| All times are GMT +1. The time now is 01:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com