Hi guys i have this piece of code below which i have used in a the attached spreadsheet, now this links to an external spreadsheet so i can view that information in the compendium. I have this working perfectly fine for the three documents in the demo (even though i have not copied the code for the rest of the row).
Sample of code:
='V:\Archive\Master File Backup\Master - Templates (xls doc)\External Site Form\Test\[EXT0000002.xls]Data Sort'!$C$5
What i want to do is be able to copy this formula down like you can do with 3 numbered cells of 1,2,3 to apply a recuring formula in every row below this so this part of the formula:
is changed to
on the next row and then
on the row below that, so i dont need to manually create the code on each line.
Thanks
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks