G
Graham
I need to use a named field to select a worksheet tab in another workbook. ie
i have a workbook called Master and need to collect data from a workbook
called Reports, but i need to collect it from different worksheets within
Reports depending on the month selected in Master. The tabs in Reports are
M01,M02,etc. In Master I have a Named Field called 'Month" with M01,M02 etc
entered in it. This field needs to select the corresponding tab in Reports.
i have a workbook called Master and need to collect data from a workbook
called Reports, but i need to collect it from different worksheets within
Reports depending on the month selected in Master. The tabs in Reports are
M01,M02,etc. In Master I have a Named Field called 'Month" with M01,M02 etc
entered in it. This field needs to select the corresponding tab in Reports.