Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create validation list of worksheet names | Excel Discussion (Misc queries) | |||
create list from another worksheet | Excel Discussion (Misc queries) | |||
How do I create a worksheet using a drop down list? | Excel Worksheet Functions | |||
How to create a macro that compares a list to another list | New Users to Excel | |||
macro to create a worksheet for every name on a list? | Excel Programming |