Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

When drop down list item is changed, clear contents in next row

Copper Contributor

Hello, 

I have an excel table that when a drop down item is changed I would like it to clear the notified column next to it.  I am looking to complete this without any VBA codes.  I need the document to auto-save, I have not found a way to auto-save it using macros.

 

exceluser20232410_0-1679431100082.png


Example above, if I change Pending parts to say sub-contractor, I would like it to clear the yes

 

Please help?

4 Replies

@exceluser20232410 

As far as I know, it is not possible to clear a cell when the value of another cell is changed without VBA code.

when a drop down item is changed
the column status have a drop down item for each row? how you build so many drop downs?

I would like it to clear the notified column next to it

why need such function?filter?
Is there a way to add text to the next row instead of clearing it without using VBA?

@exceluser20232410 

You could enter a formula in the next cell.