To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell

**tonisjoseph** · 10-15-2015, 12:45 AM

Hi All,

Need Help. I am trying to create a spread sheet template. Sample is attached here.

What I need is for each change in the cell C2 (drop down list) the below listed cells (Yellow shaded) needs to get blank. (means, if some data is there in these cells this has to be cleared for each change in the cell C2)
Cells to be Cleared:
1. C3
2. C4
3. C5
4. C7
5. C9
6. E9
7. C12
8. D12
9. E12
10.F12

Thanks in Advance
Tonis[ATTACH]424925

**NeedForExcel** · 10-15-2015, 12:55 AM

Hi,

Right click on the Worksheet Name > View Code

Please Login or Register  to view this content.

Please avoid Merged Cells.. All they do is cause problems..

**tonisjoseph** · 10-15-2015, 01:08 AM

Hi Deep Dave,

Thank you very much for your wonder full support.

Tonis

**NeedForExcel** · 10-15-2015, 01:52 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell

LinkBack

Thread Tools

Rate This Thread

Display

To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell

Re: To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell

Re: To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell

Re: To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell

Thread Information

Users Browsing this Thread

Similar Threads

Change a cell and keep all subsequent cells constant

[SOLVED] Easiest way to return a blank cell that can be used in subsequent calculations

[SOLVED] VBA Clear Cells for one range if cell in other range is blank

Clear cells upon adjacent cell change

[SOLVED] The VBA code to auto-clear dependent drop down selection when parent cell change.

Change cell from dropdown list and clear other cells in row

Formula that will change subsequent cells in a column to match fir

Bookmarks

Bookmarks

Posting Permissions