Please help! I am new to VBA and have been trying for hours to do
something that I am sure is very simple. Here is a simple explination
of what I am trying to do;
I have a database of items with mulitple collumns. In one column is
either sold or unsold. In another column I have the item name. Each
week I need to turn in a simple report showing what items are sold.
What I would like to do is have VBA (or formula) find all the items in
the data base that are sold, copy the item number that coresponds to
each of these and then paste them into a specific location in another
sheet. I have tried VLookups and find case but since I learn most of
my code from the macro recorder I'm stuck. Thank you in advance for
any help with this problem.


--
MDC
------------------------------------------------------------------------
MDC's Profile: http://www.excelforum.com/member.php...o&userid=34391
View this thread: http://www.excelforum.com/showthread...hreadid=543538