I am trying to use the Auto Complete function to put the same cell from different sheets (In months) into a different Workbook.
I have a Workbook with 12 sheets for the individual months, each sheet displays the individual days of the Month and I have a figure I would like to transfer from the same cell on each sheet, I would like to pull the same cell from each sheet into a new Workbook. i.e. at th emoment in th enew Workbook I have the following formula:
='OMEXCEL\daily 2013\[July.xls]1st'!$I$21
Where the Workbook is called July.xls and the sheet is the 1st, the cell is I21, so for the next cell in the new Workbook the formula is:
='OMEXCEL\Daily 2013\[July.xls]2nd'!$I$21
and so on,
I would like this done for multiple sheets for every Month. When I drag the cursor down to auto complete it does not update to the next sheet with same cell reference.
Hope this makes sense!
Eckfox
I have a Workbook with 12 sheets for the individual months, each sheet displays the individual days of the Month and I have a figure I would like to transfer from the same cell on each sheet, I would like to pull the same cell from each sheet into a new Workbook. i.e. at th emoment in th enew Workbook I have the following formula:
='OMEXCEL\daily 2013\[July.xls]1st'!$I$21
Where the Workbook is called July.xls and the sheet is the 1st, the cell is I21, so for the next cell in the new Workbook the formula is:
='OMEXCEL\Daily 2013\[July.xls]2nd'!$I$21
and so on,
I would like this done for multiple sheets for every Month. When I drag the cursor down to auto complete it does not update to the next sheet with same cell reference.
Hope this makes sense!
Eckfox