Inserting multiple rows and copying formulas

  • Thread starter Thread starter ajohns4
  • Start date Start date
A

ajohns4

I am working on a form for my end users. The form has about 15 lines,
the end user puts in numerical information (specific catalog number
for example) in the first column and the other columns perform VLOOKUP
to obtain specific information about that product.

I want to give them the ability to add multiple rows at a time. I
found a formula that would give them a pop-up box to choose how many
lines to insert. However, I need each new row to contain the VLOOKUP
formulas that are currently in the 15 available rows. I have not been
able to find a formula that does both.

Any help would be appreciated!!
 
Thanks for the thanks but they are really due to Dave McRitchie, it is his
code.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top