Hi,
As a long term reader of this site - I'm always amazed with the solutions offered here and so I lay a challenge down to you all..
I have a template spreadsheet with text boxes referenced to cell contents (=$D$4 for instance), a macro then takes my template (approx 100 lines) and copies it out across different files and expands it to 3000+ lines in some cases. My problem is that the text boxes rely on absolute cell referencing to display anything but as the template is copied I need the reference to adjust as any formula would.
Anyone any ideas?
Unfortunately I cannot use a cell to display the information as the formatting will not allow the length of information to be displayed..
Any help would really be appreciated.
Thanks,
Johndinho
Bookmarks