P
Paula
I have a workbook for each month and I want to take certain info from each
into a summary workbook. For example I have workbooks called:
Jan Totals, Feb Totals, Mar Totals etc. These link into 2009 Figures
workbook. Each row in the 2009 Figures workbook is labelled with a month and
has about 30 links cells from the corresponding month.
January worked fine as I manually linked the corresponding cells. In the
past I simply copied the January links into the February row and did a search
and replace on 'Jan' replacing it with 'Feb'. This is no longer working and
I am prompted for each of the 30 linked cells and even then it doesn't work.
My worksheets are all on shared drives so I'm not sure if that is the issue
or not? Can anyone please advise?
Thanks!
into a summary workbook. For example I have workbooks called:
Jan Totals, Feb Totals, Mar Totals etc. These link into 2009 Figures
workbook. Each row in the 2009 Figures workbook is labelled with a month and
has about 30 links cells from the corresponding month.
January worked fine as I manually linked the corresponding cells. In the
past I simply copied the January links into the February row and did a search
and replace on 'Jan' replacing it with 'Feb'. This is no longer working and
I am prompted for each of the 30 linked cells and even then it doesn't work.
My worksheets are all on shared drives so I'm not sure if that is the issue
or not? Can anyone please advise?
Thanks!