A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Inserting Multiple Rows with Formulas



 
 
Thread Tools Display Modes
  #1  
Old November 17th 04, 04:58 PM
ShineboxNJ
external usenet poster
 
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
Ads
  #2  
Old November 18th 04, 03:29 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

Save your worksheet first.

Say your SKUs are in column A.

Insert a new column A.
type 1 in A2 (headers in row 1???)
type 2 in A3

Select a2:A3 and drag down through your range.

Now insert a new sheet.
Put 1 in A1 and 2 in A2 and drag down the correct number of rows.

Copy those rows to the bottom of the "real" sheet.
do it again (for the second blank row)

Now select your range columns A:???
Data|Sort
primary key will be column A (ascending)
secondary key will be column B (descending)

Delete that helper column (column A) and extra worksheet.

If it didn't work correctly, close without saving.


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
  #3  
Old November 18th 04, 03:30 AM
Dave Peterson
external usenet poster
 
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 02:48 PM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 07:00 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 3rd 04 12:04 AM
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 07:50 AM.


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