I have the following formula in a cell:
=E4-'L:\Sales\Market Pricing Revision-PDFs\[Market Pricing 2-1-15.xlsx]MASTER PAGE'!$E$74
In the Cell next to it I want to extract the reference: 'L:\Sales\Market Pricing Revision-PDFs\[Market Pricing 2-1-15.xlsx]MASTER PAGE'!$E$74
And change the column from E to I and use it to populate the cell. So the new cell (cell next to it) will be:
='L:\Sales\Market Pricing Revision-PDFs\[Market Pricing 2-1-15.xlsx]MASTER PAGE'!$I$74
I want to be able to quickly replicate this function for a number of cells.
Thanks in advance!
Bookmarks