Array data to a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UKMAN - 19 Sep 2007 14:26 GMT

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 to this Message

bj - 19 Sep 2007 14:36 GMT

I am afraid I don't understand what you want to do.
please give an example?

> 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:(
[quoted text clipped - 22 lines]
> Cheers
> Colin

Reply to this Message

UKMAN - 19 Sep 2007 15:42 GMT

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

> I am afraid I don't understand what you want to do.
> please give an example?
[quoted text clipped - 25 lines]
> > Cheers
> > Colin

Reply to this Message

bj - 19 Sep 2007 21:18 GMT

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.

> Hi
>
[quoted text clipped - 50 lines]
> > > Cheers
> > > Colin

Reply to this Message

UKMAN - 20 Sep 2007 08:22 GMT

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

> 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
[quoted text clipped - 54 lines]
> > > > Cheers
> > > > Colin

Reply to this Message