Insert row based on Value in above cell

Posted to microsoft.public.excel.programming

SANDIND[_2_] SANDIND[_2_] is offline

external usenet poster

Posts: 16

Insert row based on Value in above cell

Hi All,

How can I insert one/more row below one row based on cell value of that row.
Eg, if A1=Yes (drop down with Yes/ No) then I want one row to be added below,
if possible with certain text/message in below added row.

And later if No is selected that row is made hidden/deleted.

Thanks, SS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
insert an image based on a cell value	brig239	New Users to Excel	1	June 3rd 09 07:10 PM
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets	Doctorjones_md	Excel Discussion (Misc queries)	7	June 8th 07 09:32 PM
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets	Doctorjones_md	Excel Worksheet Functions	7	June 8th 07 09:32 PM
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets	Doctorjones_md	Excel Programming	7	June 8th 07 09:32 PM
how do I insert a cell based on its match with an adjacent cell?	Gabbon	Excel Worksheet Functions	12	January 24th 06 12:28 PM

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

Menu

About Us