We at work have many excel(.xls) files one for each day of booking, and each sheet has many bookings.

My task is to create a new excel spreadsheet which takes the email fields from all the bookings of ALL the days.
Now i have made a sheet with all the email feilds from ONE day but each path is hard coded
ie the formula bar looks like this
='\\Frontdesk\my documents\Booking 2009\[mar 22.xls]Jan 1'!$C$6

is there any way of making the formula have a variable path such as this:

='\\Frontdesk\my documents\Booking 2009\[THIS SHEETS CELL A2]Jan 1'!$C$6
where cell A2 contains the booking date ie mar22.xls

This would allow me to quickly look up the emails from many dates without having to change the formula of over 100 cells.

PS i have no knowlege of excel macro's so if that is what is required then please tel me exactly how to insert it into my document

Thanks in advance
Chris
ARU computer science student

This post has been edited by Chris_Morley: 30 Sep, 2009 - 02:21 AM