| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto build report
Just checking if anyone has ideas for this. Thanks
"Nadine" wrote: Hi, Not sure if this is possible or not. Tried pivot table doesn't meet needs (because how sheet is designed) Hope can do this by formula or if can use a formula in combination with a macro. guessing may need to create multiple hidden formula's Each row contains specific data for a file, and want it to look up data in specific columns/cells if matches answer, then copy data from another cell/column and paste it into another worksheet on a new row. Want it to look up info in i.e. if rows/Column Z has a 1 in it, then copy the data that is in column C /matching row (column z has a score number, and column c has the file number) want a list of file numbers that match a specific score - Repeat same for mulitple other columns BB/AD, CC/BE, DC/CF if possible paste the data in a specific worksheet- one record per row Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine sheets to build a report | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| Auto update daily report problem | Excel Discussion (Misc queries) | |||
| How do I auto-save multipage report printing to Acrobat Distiller | Excel Discussion (Misc queries) | |||
| How to Build an Excel-Report ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
