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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array data to a report
I am afraid I don't understand what you want to do.
please give an example? "UKMAN" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array data to a report
Hi
I can send you an example of the register and the reports I want the data to fill. Basicaly I record courses that people attend in a register sheet (see the example I put below to show the register). I have created a sheet that you can input either a "DEPT" or a "COURSE" or a "NAME" so to ask 1 of 3 following: (1) What are the names, course etc that people who work in the "ADMIN" dept (2) What are the names, costs etc that have attended a "SPECIFIC COURSE" (3) What courses, the cost of the course etc has a given "NAME i.e. COLIN" been on. Each report is just a heading that shows either the "DEPT", "COURSE" or "NAME" and the found records would go on an indivdual row in the body of the report. Just this explain it better? many thanks for your time. Cheers Colin "bj" wrote: I am afraid I don't understand what you want to do. please give an example? "UKMAN" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array data to a report
the simplest way to do it is probably select the data set, and to use the
Data-Filter-autofilter on the partiular collumn you are interested in. copy and paste into your report. "UKMAN" wrote: Hi I can send you an example of the register and the reports I want the data to fill. Basicaly I record courses that people attend in a register sheet (see the example I put below to show the register). I have created a sheet that you can input either a "DEPT" or a "COURSE" or a "NAME" so to ask 1 of 3 following: (1) What are the names, course etc that people who work in the "ADMIN" dept (2) What are the names, costs etc that have attended a "SPECIFIC COURSE" (3) What courses, the cost of the course etc has a given "NAME i.e. COLIN" been on. Each report is just a heading that shows either the "DEPT", "COURSE" or "NAME" and the found records would go on an indivdual row in the body of the report. Just this explain it better? many thanks for your time. Cheers Colin "bj" wrote: I am afraid I don't understand what you want to do. please give an example? "UKMAN" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array data to a report
Hi bj,
I am doing this at the moment but I want to automate it. I have it so vlookup will bring the data across but I cannot get it to go through each line and return only valid rows.. :( There must be a way..:) Colin "bj" wrote: the simplest way to do it is probably select the data set, and to use the Data-Filter-autofilter on the partiular collumn you are interested in. copy and paste into your report. "UKMAN" wrote: Hi I can send you an example of the register and the reports I want the data to fill. Basicaly I record courses that people attend in a register sheet (see the example I put below to show the register). I have created a sheet that you can input either a "DEPT" or a "COURSE" or a "NAME" so to ask 1 of 3 following: (1) What are the names, course etc that people who work in the "ADMIN" dept (2) What are the names, costs etc that have attended a "SPECIFIC COURSE" (3) What courses, the cost of the course etc has a given "NAME i.e. COLIN" been on. Each report is just a heading that shows either the "DEPT", "COURSE" or "NAME" and the found records would go on an indivdual row in the body of the report. Just this explain it better? many thanks for your time. Cheers Colin "bj" wrote: I am afraid I don't understand what you want to do. please give an example? "UKMAN" wrote: 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 |
Reply |
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 |