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
force them to fill out the specific cells
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.
[link] [comments]
Want to read more?
Check out the full article on the original site