Hi,
I have an excel report sheet that gets it's value from the last row in a source sheet.
E.g today the value ='[Yield.xls]Class 1'!$I$1025
But in two weeks time the value could be =='[Yield.xls]Class 1'!$I$1099
I need to detrmine the last populated cell in column I on the linked sheet.
This seems so do-able,and efforts to resolve are wrecking my head.
Only one stipulation - I must not use VBA - otherwise I would have this resolved already as it is a no-brainer.
Thanks for any help/suggestions you may have to offer.
Paul
I have an excel report sheet that gets it's value from the last row in a source sheet.
E.g today the value ='[Yield.xls]Class 1'!$I$1025
But in two weeks time the value could be =='[Yield.xls]Class 1'!$I$1099
I need to detrmine the last populated cell in column I on the linked sheet.
This seems so do-able,and efforts to resolve are wrecking my head.
Only one stipulation - I must not use VBA - otherwise I would have this resolved already as it is a no-brainer.
Thanks for any help/suggestions you may have to offer.
Paul