[OT] Excel - Bulk adding of rows after each existing row

Yahoo Archive
1
Thanks. This certainly looks like it would have handled it too. I just downloaded it and will try it out. I'm always running into little Excel frustrations. Looks like the guy that wrote the add-ins had a few of the same issues already. Best part the the "free" part.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Tom Briceland
Sent: Thursday, December 29, 2005 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [OT] Excel - Bulk adding of rows after each existing row



Todd,

Check out ASAP utilities' free add-in (www.ASAP-utilities.com). It has just what you are looking for.

Tom Briceland

Inventory Control Coordinator

Ohio Gratings, Inc.


--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
>
> I have a rather large spreadsheet of operation and work center standards from Vantage compared to our external quoting system. In order to get them to match up I need some working space so I would like to add one blank row after every existing row. Anyone here aware of a "trick" for doing this? I have tried recording a macro but it only runs once and does not "move down" to the next position to add a row. A macro might work if there was a way to loop it maybe 500 times. Something like:
> DO{<insert row>, down, down, <select row>} 500 Times
>
> But really I was just hoping there was some keyboard shortcut to select the entire sheet and have it shuffle in a blank row after each existing row. This would save me a LOT of time (and repetitive stress on my fingers!).
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
2
I have a rather large spreadsheet of operation and work center standards from Vantage compared to our external quoting system. In order to get them to match up I need some working space so I would like to add one blank row after every existing row. Anyone here aware of a "trick" for doing this? I have tried recording a macro but it only runs once and does not "move down" to the next position to add a row. A macro might work if there was a way to loop it maybe 500 times. Something like:
DO{<insert row>, down, down, <select row>} 500 Times

But really I was just hoping there was some keyboard shortcut to select the entire sheet and have it shuffle in a blank row after each existing row. This would save me a LOT of time (and repetitive stress on my fingers!).

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
You could try this:
insert a blank column A
number the first few rows -- odd numbers only (1,3,5...)and fill to the
end of your list
at the end of your "list", number the blank rows -- even numbers only,
and fill for as many rows as you need to match the quantity of your odd
numbered rows
sort on column A
delete column A

Gail M. Grillo
Quality Manager
Allegheny Bradford Corporation
(814) 362-2593 ext. 228



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, December 28, 2005 4:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Excel - Bulk adding of rows after each existing
row


I have a rather large spreadsheet of operation and work center standards
from Vantage compared to our external quoting system. In order to get
them to match up I need some working space so I would like to add one
blank row after every existing row. Anyone here aware of a "trick" for
doing this? I have tried recording a macro but it only runs once and
does not "move down" to the next position to add a row. A macro might
work if there was a way to loop it maybe 500 times. Something like:
DO{<insert row>, down, down, <select row>} 500 Times

But really I was just hoping there was some keyboard shortcut to select
the entire sheet and have it shuffle in a blank row after each existing
row. This would save me a LOT of time (and repetitive stress on my
fingers!).

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
4
Thanks, that worked very well.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Gail Grillo
Sent: Wednesday, December 28, 2005 4:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [OT] Excel - Bulk adding of rows after each existing row


You could try this:
insert a blank column A
number the first few rows -- odd numbers only (1,3,5...)and fill to the
end of your list
at the end of your "list", number the blank rows -- even numbers only,
and fill for as many rows as you need to match the quantity of your odd
numbered rows
sort on column A
delete column A

Gail M. Grillo
Quality Manager
Allegheny Bradford Corporation
(814) 362-2593 ext. 228



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, December 28, 2005 4:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Excel - Bulk adding of rows after each existing
row


I have a rather large spreadsheet of operation and work center standards
from Vantage compared to our external quoting system. In order to get
them to match up I need some working space so I would like to add one
blank row after every existing row. Anyone here aware of a "trick" for
doing this? I have tried recording a macro but it only runs once and
does not "move down" to the next position to add a row. A macro might
work if there was a way to loop it maybe 500 times. Something like:
DO{<insert row>, down, down, <select row>} 500 Times

But really I was just hoping there was some keyboard shortcut to select
the entire sheet and have it shuffle in a blank row after each existing
row. This would save me a LOT of time (and repetitive stress on my
fingers!).

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
5
Todd,

Check out ASAP utilities' free add-in (www.ASAP-utilities.com). It has just what you are looking for.

Tom Briceland

Inventory Control Coordinator

Ohio Gratings, Inc.


--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
>
> I have a rather large spreadsheet of operation and work center standards from Vantage compared to our external quoting system. In order to get them to match up I need some working space so I would like to add one blank row after every existing row. Anyone here aware of a "trick" for doing this? I have tried recording a macro but it only runs once and does not "move down" to the next position to add a row. A macro might work if there was a way to loop it maybe 500 times. Something like:
> DO{<insert row>, down, down, <select row>} 500 Times
>
> But really I was just hoping there was some keyboard shortcut to select the entire sheet and have it shuffle in a blank row after each existing row. This would save me a LOT of time (and repetitive stress on my fingers!).
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]