I have created 12 excel worksheets named January, February...- December, each sheet containing a monthly report with data on working hours, overtime, injuries etc.
Now i want to create a 13th sheet (a front page) where i can choose a month in a pivot table and then have the data from the chosen month (=worksheet) presented in a table below.
How do i do this???
I tried using the IF-function, but this demands too many arguments (12) - at least the way i tried...
Can this be done in Excel or do I have to use Access?
Anyone?? Your help will be much appreciated.
Tnx
"If electricity comes from electrons, does morality come from morons?"
Bookmarks