Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mutiple Spread Sheets
I Have a mutiple Spreadsheets with several functions caring over to each one.
I want to set a fucntion that only shows greater then 0 amounts on the last spread sheet. I tried a filter but need to edit it so that any time a dollar amount is added to spreadsheet 1 it shows up on spreadsheet 4. It needs to be able to only pull dollar amounts great then 0 from the previous 3 worksheets. Is there a function I can use Besides the the filter? I need to save it so other users in my company can come in and in put data without having to "manually use the filter" I need a function to set this up. PLEASE HELP! -- ABA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Summing common cell over mutiple sheets within a file? | Excel Worksheet Functions | |||
Combining two spread sheets | Excel Discussion (Misc queries) | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
Charts from Spread sheets | Excel Discussion (Misc queries) | |||
Merging two spread sheets | Excel Worksheet Functions |