1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Autofilling Drop Down in Cell to match cells above WHEN cell below is filled?

Okay, I am trying to build out a time log sheet with drop downs to select from to indicate task performed in that time block.

If someone selects a specific choice from a drop down for the 8AM slot (time is indicated via rows going down as in Outlook calendar), but doesn't begin a new task until 10AM, once they fill 10AM's cell I would like the cells in that column above to auto-fill themselves with the info/task from the 8AM cell data.

I need this to be flexible though, so for example, some people may not fill out another task until noon or 11 or 8:30, etc.

Where should I start on this? Need help with what function or how to build - apologies if this is stupid I am an artist not an Excel pro. -_-

submitted by /u/Vynrah
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#real-time data collaboration
#generative AI for data analysis
#financial modeling with spreadsheets
#real-time collaboration
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Autofilling
#Drop Down
#Cell