Hard to explain, but is there any way to make a formula that deletes the cell to its' right if the cell is gray?
Attached worksheet.
Thanks!
Hard to explain, but is there any way to make a formula that deletes the cell to its' right if the cell is gray?
Attached worksheet.
Thanks!
Formulas do not make physical changes to other cells, formulas display calculated results in the cell in which they are entered.
To make physical changes to your original data in the cells where the data currently reside requires VBA programming. Here's a small little macro you can run that will do what you've described:
Please Login or Register to view this content.
How/Where to install the macro:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook
The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks