View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Ps. Debra Dalgleish shows how to fill the empty cells at:

http://www.contextures.com/xlDataEntry02.html



ShineboxNJ wrote:

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


--

Dave Peterson