U
UKMAN
Hi
In 1 sheet have 20 tables of holding the same except for col 1 in each that
hold a unique id for that table. Each table can hold up to 50 rows, so some
cpuld be blank.
I need to produce a specially formatted report that will allow me to select
the unique ID from a drop down and so only that data will be listed
format of table data
ID | Name | R | B | S | X | L1
pc001 colin 200 2 1 1 5
I will insert the same format into the report.
As an add on I have 12 of these sheets each holding 20 tables so it would be
wonderful if I could have 1 report that has a drop down to select the sheet
(each sheet is name after a calander month i.e. jan) and then a drop down to
select the ID. But then I want to win the lottery as well.
many thanks
UKMAN
In 1 sheet have 20 tables of holding the same except for col 1 in each that
hold a unique id for that table. Each table can hold up to 50 rows, so some
cpuld be blank.
I need to produce a specially formatted report that will allow me to select
the unique ID from a drop down and so only that data will be listed
format of table data
ID | Name | R | B | S | X | L1
pc001 colin 200 2 1 1 5
I will insert the same format into the report.
As an add on I have 12 of these sheets each holding 20 tables so it would be
wonderful if I could have 1 report that has a drop down to select the sheet
(each sheet is name after a calander month i.e. jan) and then a drop down to
select the ID. But then I want to win the lottery as well.
many thanks
UKMAN