maderlach
01-29-2014, 02:46 AM
Hi all,
I am new to this forum but I find it very useful. Thank everybody for contribution!
I have a problem I cannot tackle - I have to break links in cell but after that I need to have all amounts presented in cell.
An example:
In cell A1 I have: = '\\LINK\ [FILE NAMES.xlsb] SheetName'!$C$7 + '\\LINK\ [FILE NAMES.xlsb] SheetName'!$C$8 + '\\LINK\ [FILE NAMES.xlsb] SheetName'!$C$9.
I need a macro that would show me (instead of links): = 5+10+27.
So basically it is a break link function but conducted on the separate links. Is that possible?
Kind regards,
Tom
I am new to this forum but I find it very useful. Thank everybody for contribution!
I have a problem I cannot tackle - I have to break links in cell but after that I need to have all amounts presented in cell.
An example:
In cell A1 I have: = '\\LINK\ [FILE NAMES.xlsb] SheetName'!$C$7 + '\\LINK\ [FILE NAMES.xlsb] SheetName'!$C$8 + '\\LINK\ [FILE NAMES.xlsb] SheetName'!$C$9.
I need a macro that would show me (instead of links): = 5+10+27.
So basically it is a break link function but conducted on the separate links. Is that possible?
Kind regards,
Tom