I need to reference cells in a spreadsheet held in my company's eDocs document management system. There is a function (presumably provided by the DMS vendor) but it does not increment the row number as I drag it down in the cells in my spreadsheet. E.g. If I have this in cell A1:
=+PwDMoniker.PwDMoniker.1|'PCDOCS://ENINO/4815370/1'!'!Absoft Response!R1C1'
I want to drag it down the column so that my cell A2 should contain the formular:
=+PwDMoniker.PwDMoniker.1|'PCDOCS://ENINO/4815370/1'!'!Absoft Response!R2C1'
At the moment it just copies down as text so the cell reference remains the same.
Any ideas?
=+PwDMoniker.PwDMoniker.1|'PCDOCS://ENINO/4815370/1'!'!Absoft Response!R1C1'
I want to drag it down the column so that my cell A2 should contain the formular:
=+PwDMoniker.PwDMoniker.1|'PCDOCS://ENINO/4815370/1'!'!Absoft Response!R2C1'
At the moment it just copies down as text so the cell reference remains the same.
Any ideas?