Excel automatic updating of cells

Any other way to get my graph looking the way I want it Image available once I have enough reputation!

excel automatic updating of cells-48

You could fill the dependend cell (D2) by a User Defined Function (VBA Macro Function) that takes the value of the C2-Cell as input parameter, returning the current date as ouput.

I am hoping to retire from my full time job through writing so I can buy a cabin in the South Carolina mountains and become a career author.

Whenever C2 changes value (actual value, not formula) I want to have the present date and time updated in D2.

To do this, you must have the Developer menu in your ribbon. Select The cell link is the location where Excel will place the index number of the item you select.

If you don’t, activate this option in the menu via Now we need a list of month names somewhere else in our worksheet. For instance, if you select May, (the 5th item in the list,) the value in A1 will be 5 and if you select September the value in A1 will be 9. It’s a trick to hide the linked cell output under the actual Combo Box.

656

Leave a Reply