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

How to automatically delete cell inputs if a file is duplicated?

Hi,

so (Unfortunately) we use a regulation sheet written in excel for our products.

One sheet for one product.

Unfortunately, the product manager, copys a file from a different product and only changes some cells and misses a lot of others. So we have to cycle back and forth until its good.

I hate, that they dont use the empty template and recycle other workbooks without thinking.

My idea would be

  1. force them to fill out the specific cells

  2. clear all cells if they decide

My idea for 2. would be:

Copy the filename into a cell (automatically).

When opening the workbook -> check if there is a value in this specific filename cell -> if yes, check if its the name of the filename -> if it isnt equal to the filename than delete all cells.

But I think I cant use vba because a lot of colleagues use the online version.

submitted by /u/Legitimate_Cap2269
[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
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#excel
#regulation sheet
#duplicate file
#cell inputs
#product manager
#automatically delete
#empty template
#clear all cells
#specific cells
#filename cell
#workbooks
#check filename
#vba
#online version
#cell value