Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Adding rows once data is entered

I have a spreadsheet that I am needing to add two rows to when a certain cell
has data entered.

Example
A B C D
1 xx xx xx Data entered here
2 Blank row
3 This is where I want to add two rows on the data has been entered in D1.
4 Blank row
5 Once again I want two rows once data is entered into D3 and so on ending
at a specified row since this form has several heading that this will apply
to.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Adding rows once data is entered

Hi,

See the answer to your other post, and try not to cross post.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"desperate in MS" wrote:

I have a spreadsheet that I am needing to add two rows to when a certain cell
has data entered.

Example
A B C D
1 xx xx xx Data entered here
2 Blank row
3 This is where I want to add two rows on the data has been entered in D1.
4 Blank row
5 Once again I want two rows once data is entered into D3 and so on ending
at a specified row since this form has several heading that this will apply
to.

Reply
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
Add rows when data is entered desperate in MS Excel Discussion (Misc queries) 0 February 9th 09 05:51 PM
Print only rows with data entered in an excel template hellaby Excel Discussion (Misc queries) 1 August 9th 08 04:16 PM
adding text that appears after the entered data Cindy B Setting up and Configuration of Excel 2 May 5th 08 05:37 PM
Can I rearrange data entered in rows into colums in Excel? Robin Excel Discussion (Misc queries) 1 January 30th 06 07:48 PM
output date modified if data is entered for multiple rows [email protected] Excel Discussion (Misc queries) 4 October 13th 05 08:09 PM


All times are GMT +1. The time now is 10:10 PM.

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

About Us

"It's about Microsoft Excel"