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
|