Inserting multiple rows and copying formulas

[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!!

 

[Sandy Mann]

See if Dave McRitchie's Macro does what you want:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

--
HTH

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

 

[ajohns4]

Thank you very much - that did what I needed!!!

 

[Sandy Mann]

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