Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array data to a report
I have tried many things and I know a filter on the columns would do it but
then I would need to copy and paste to fill reports:( I have a course register with a heading title for each column. Each row is a unqiue record and I can limit the rows to match the amount of colmuns I have 3 reports that need to be filled from the row data with the selection critera of (Rpt1) by Dept, (rpt2) by Course and (rpt3) by name Below is an example of the register: Name Dept Course Cost Status ID colin admin word £1.00 booked trn001 Jane IT excel £2.00 reserved trn002 Colin admin excel £2.00 reserved trn003 etc etc The closest i got is with a vlookup but then cannot figure out how to check each row. many thanks and really desperate for this. Cheers Colin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Report from data | Excel Discussion (Misc queries) | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
Selecting Data for report | Excel Worksheet Functions |