software

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,quot;smithquot;,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: www.excelforum.com/member.php...oamp;userid=22153
View this thread: www.excelforum.com/showthread...hreadid=543733Have a look at Menu Datagt;Filtergt;Automatic filter amp; Advanced filter

HTH
--
AP

quot;burnsbyrnequot; gt; a
écrit dans le message de news:
...
gt;
gt; I have a spreadsheet that looks like this
gt;
gt; ID# HF1 HF2 HF3 HF4 MD
gt; 222 y y n y Smith
gt; 333 y n n n Jones
gt; 444 y y y y Jackson
gt; 555 y y n y Jackson
gt; and so on
gt;
gt; I need to copy the row(s) for each MD and place them into a row in
gt; another workbook. I was wondering if there is some way that I could
gt; combine the IF statement and the COPY statement. Something like
gt; =IF(MDcolumn,quot;smithquot;,copy row). Maybe using an IF statement is not the
gt; way to solve this problem. I am open to other ways to do this, no ideas
gt; turned away!
gt; Thanks in advance!
gt; Mike
gt;
gt;
gt; --
gt; burnsbyrne
gt;
gt;
gt; ------------------------------------------------------------------------
gt; burnsbyrne's Profile:
gt; www.excelforum.com/member.php...oamp;userid=22153
gt; View this thread: www.excelforum.com/showthread...hreadid=543733
gt;

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:
gt; Have a look at Menu Datagt;Filtergt;Automatic filter amp; Advanced filter
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;burnsbyrnequot; gt;
gt; a
gt; écrit dans le message de news:
gt; ...
gt; gt;
gt; gt; I have a spreadsheet that looks like this
gt; gt;
gt; gt; ID# HF1 HF2 HF3 HF4 MD
gt; gt; 222 y y n y Smith
gt; gt; 333 y n n n Jones
gt; gt; 444 y y y y Jackson
gt; gt; 555 y y n y Jackson
gt; gt; and so on
gt; gt;
gt; gt; I need to copy the row(s) for each MD and place them into a row in
gt; gt; another workbook. I was wondering if there is some way that I could
gt; gt; combine the IF statement and the COPY statement. Something like
gt; gt; =IF(MDcolumn,quot;smithquot;,copy row). Maybe using an IF statement is not
gt; the
gt; gt; way to solve this problem. I am open to other ways to do this, no
gt; ideas
gt; gt; turned away!
gt; gt; Thanks in advance!
gt; gt; Mike
gt; gt;
gt; gt;
gt; gt; --
gt; gt; burnsbyrne
gt; gt;
gt; gt;
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; burnsbyrne's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=22153
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=543733
gt; gt;--
burnsbyrne------------------------------------------------------------------------
burnsbyrne's Profile: www.excelforum.com/member.php...oamp;userid=22153
View this thread: www.excelforum.com/showthread...hreadid=543733