Automatically Enter Formula in a Cell After Entering Data in Another Cell


Joined
Aug 22, 2012
Messages
1
Reaction score
0
I have a worksheet in which a date is entered in Column B, after which the following formula is automatically entered into Column A (same row) to display the day of the week corresponding to the date in Column B:
=UPPER(TEXT(B1,"ddd"))
When a date has not yet been entered into Column B, the cell next to it in Column A is blank, and when the cursor is in a blank Column A cell, no formula is visible in the formula bar.

Previously, I set up the worksheet to automatically enter these formulas in Column A, but I don't recall how I did it, nor can I find anything in the code that would accomplish this.

Here are a couple of additional pieces of relevant information:

When a date is entered into (or deleted from) Column B, the following message displays briefly in the status bar at the bottom of the page:
Calculating: (2 processor(s)); 0%
Deleting a date from Column B does not delete the formula from Column A.

Any ideas or suggestions?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top