Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting multiple rows and copying formulas
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting multiple rows and copying formulas
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 Replace @mailinator.com with @tiscali.co.uk wrote in message ups.com... 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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting multiple rows and copying formulas
Thank you very much - that did what I needed!!!
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting multiple rows and copying formulas
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 Replace @mailinator.com with @tiscali.co.uk wrote in message ups.com... Thank you very much - that did what I needed!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help please inserting multiple rows based on cell value then copying to data sheet | Excel Worksheet Functions | |||
Inserting formulas etc after n rows | Excel Discussion (Misc queries) | |||
Automatically copying fomulae when Inserting rows | Excel Discussion (Misc queries) | |||
Inserting Rows w/formulas question | Excel Worksheet Functions | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |