View Single Post
  #1   Report Post  
ShineboxNJ
 
Posts: n/a
Default Inserting Multiple Rows with Formulas

I have a worksheet with over 7000 rows. These rows contain the product
information and SKUS of every product we carry. The problem is I have to add
2 rows below each row already there so they could contain secondary skus for
returned goods. Is there a way I can insert 2 rows under each line with my
lookup formula, without having to go thru each one??

ie.
PRODUCT 1000 (already there)
PRODUCT 1000 B (inserted with forumla)
PRODUCT 1000 C ("" "")

any help would be greatly appreciated!1
thanks,
Mark