LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting a row between two existing rows Jennie New Users to Excel 6 January 8th 05 01:48 PM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 2nd 04 11:04 PM
How do I use conditional formatting for multiple rows? Jim Johnson Excel Worksheet Functions 1 October 30th 04 03:36 AM
Count rows based on multiple criteria Murph Excel Worksheet Functions 1 October 28th 04 07:13 AM


All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"