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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?