When a value is selected for B2, auto-populate C2 with date that selection was made

		Microsoft Office Forums > Microsoft Excel > Excel Programming
When a value is selected for B2, auto-populate C2 with date that selection was made

06-03-2024, 07:09 PM

Guessed

Windows 10 When a value is selected for B2, auto-populate C2 with date that selection was made

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,158

See this link Automatically Enter Date When Data Entered in Excel (2 Ways)

Note that you need to set your options to Enable Iterative Calculation before it works

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to have selected values from one column populate date selection was made in 3 other columns	SnakeDoctor	Excel	1	05-01-2024 12:45 AM
Auto populate text from a drop-down form field selection in Word	atr792	Word VBA	2	07-11-2023 05:44 PM
Auto-populate text boxes with Excel data based on drop down box selection	charkelham	Word VBA	0	08-04-2021 04:38 AM
Auto populate weekday based on given cell/date	kelwea	Excel	6	05-20-2019 03:26 AM
Auto populate cell with today's date	Phil H	Excel Programming	7	10-18-2017 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 AM.