Autofilling Cells

  Hobblenobble 20:41 11 Nov 2009
Locked

I have a register with columns named task, date, description and complete. The task column has 1000 hyperlinks that go to a template form. When the user clicks on the hyperlink a blank template is opened and the details above are filled in. What I want to be able to do is fill the columns in the register with the info from the newly opened template. Many thanks.

Stumpy.

  Hobblenobble 21:23 11 Nov 2009

Explaining my previous post a little better. A register has a column that has 1000 hyperlinks that increment a filename by one. To copy cell info from A2 from filename 'test 2' would give the formula =[test2.xls]Sheet1!$A$2. How can I copy and paste =[test2.xls]Sheet1!$A$2 so that in the next cell in the register it will copy =[test3.xls]Sheet1!$A$2, =[test4.xls]Sheet1!$A$2 and so on.

Thank you.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?