Date to column once a day

[hp801]

I am new to VBA and would like to know what the code would look like if I want the date to appear one time in a column per day. I would like to use it to track daily entries so I would need yesterday's date to stay when I add data the next day. I would also like the date (column A) to show the date only once regardless of how many updates are placed in column B,C,D... and I would like the date update to trigger by new data being entered/moved into column B? This question has probably been asked before, I tried to search for it prior to asking for help and I am pretty sure there are VBA masters that help people in this forum that can help with easy requests like this.

Thank you in advance for your help.

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[hp801]

Thank you for your reply, please let me know if this makes sense.

[Richard Buttrey]

Hi,

If you just want to hide the repeated dates then use this conditional format in A2 and apply it to all cells in column A. Set the format of the font colour to white,(or whatever the background colour of the cells)

Please Login or Register  to view this content.

Better still use a Pivot table - see attached

[hp801]

Sorry I didn't explain very well. I am looking for the date to auto populate when data is added in column B and like the example I only want to see the date once per daily entry (like the pivot).

[Richard Buttrey]

You'll need a sheet change macro for this.

Please Login or Register  to view this content.

It assumes all previous dates are earlier than today's date.

[hp801]

If I load this macro into a new module will column B automatically populate with today's date? Again sorry I am new at VBA.

[Richard Buttrey]

The macro is a Sheet level macro, not one that belongs in a Module. i.e one that reacts to a sheet change event, in this case a change in column B.

Bsed on the example you gave it's Column A (not B) that will populate with today's date IF and only If it doesn't already exist in an earlier columns A cell. This will happen once you add a new value in column B

In VBA double click the Sheet in question in the Project Explorer Window, select Worksheet from the left hand drop down above the code area and select Sheet Change from te right hand drop down.

[hp801]

This is exactly what I wanted. Thank you for your patience and explanation.

[Richard Buttrey]

This is exactly what I wanted. Thank you for your patience and explanation.

Gals to have helped and thanks for the rep.