Use a macro to create a new list using another worksheet
 

I have a worksheet (I was going to attach an example but it wont take
excel files) where I want to generate a list of individuals and all of
the associated data, only if they have an amount in dollars at or over
1,000 using a macro or a formula. Thanks for the help!

Here are the columns in the first sheet:

NAME FUND DEPT CENTER CODE AMOUNT $ AMOUNT HOURS DIVISION LOCATION


--
ineedhelp2
------------------------------------------------------------------------
ineedhelp2's Profile: http://www.excelforum.com/member.php...o&userid=26298
View this thread: http://www.excelforum.com/showthread...hreadid=396905

Use a macro to create a new list using another worksheet
 

You can do this without code using an Advanced Filter:

http://www.contextures.com/xladvfilter01.html

If you want code, just turn on the macro recorder while you perform the
filtering manually. Then modify the couple of lines recorded to reproduce
what you did.

--
Regards,
Tom Ogilvy


"ineedhelp2" wrote
in message ...

I have a worksheet (I was going to attach an example but it wont take
excel files) where I want to generate a list of individuals and all of
the associated data, only if they have an amount in dollars at or over
1,000 using a macro or a formula. Thanks for the help!

Here are the columns in the first sheet:

NAME FUND DEPT CENTER CODE AMOUNT $ AMOUNT HOURS DIVISION LOCATION


--
ineedhelp2
------------------------------------------------------------------------
ineedhelp2's Profile:
http://www.excelforum.com/member.php...o&userid=26298
View this thread: http://www.excelforum.com/showthread...hreadid=396905