First of All Hi to All out there in MRExcel world.
I am fairly new to excel and I have been tasked with a pig of a query, I need to automate a report in one spread sheet to draw data from certain cells on tabs in another spread sheet held on a server.basically the report has to show the tonnages from a weekly (1 -52) from three cells Quay, Road & Rail.
What I would like to do is create a dropdown menu for weeks 1 - 52 in one cell in the report so that if I pick a week it will link the corresponding tab/cells in a separate workbook, to the cells in the report.
I had looked at '=indirect' statement but I have struggled to get this to work.
Any help in this will be greatly appreciated.
Regards & Thanks
Darren
I am fairly new to excel and I have been tasked with a pig of a query, I need to automate a report in one spread sheet to draw data from certain cells on tabs in another spread sheet held on a server.basically the report has to show the tonnages from a weekly (1 -52) from three cells Quay, Road & Rail.
What I would like to do is create a dropdown menu for weeks 1 - 52 in one cell in the report so that if I pick a week it will link the corresponding tab/cells in a separate workbook, to the cells in the report.
I had looked at '=indirect' statement but I have struggled to get this to work.
Any help in this will be greatly appreciated.
Regards & Thanks
Darren