Autofilling Cells

  Hobblenobble 20:41 11 Nov 09

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.


  Hobblenobble 21:23 11 Nov 09

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.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…