Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generate Report
I have one sheet called master list which is basically a customer list of:
custid, name, address, state, ... On a different sheet I want to make a report that does something like: State: <enter state (Macro, or auto) Select * from master_list where $State_Col = state This way I can have a nice formatted report for each state, and I can simply enter the state and either run a macro, or have it auto run based upon a change in state to make the rest of the report. I know this is probably best suited for a database, but for right now we really like the auto-filter capability and dont want to move everything to a DB. Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I use excel to automatically generate routine report? | Excel Worksheet Functions | |||
How to generate a report from multiple lists in Excel 2003? | Excel Discussion (Misc queries) | |||
generate report thru pracle to excell | Excel Discussion (Misc queries) | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |