Help! finding data and pasting it to another sheet!
 

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

Help! finding data and pasting it to another sheet!
 

Have a look in help for
datafilterautofilter
or just try it

--
Don Guillett
SalesAid Software

"MDC" wrote in message
...

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

Help! finding data and pasting it to another sheet!
 

is there VBA code to filter a list and paste it onto another sheet?
thank you


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

Help! finding data and pasting it to another sheet!
 

The macro recorder is your friend. Try it and post your code if you need
more help.

--
Don Guillett
SalesAid Software

"MDC" wrote in message
...

is there VBA code to filter a list and paste it onto another sheet?
thank you


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