Automatically fill cells if a cell is filled
Solved
Mdrt47
Posted messages
15
Status
Membre
-
via55 Posted messages 14730 Registration date Status Membre Last intervention -
via55 Posted messages 14730 Registration date Status Membre Last intervention -
Hello,
For an order tracking, I would like that in my Excel file, if I fill in a cell, the cells before it in the row also fill in. Let me explain:
For tracking orders, I need to follow certain specific and/or urgent orders.
For that, I created an Excel table; there are multiple columns, a first part with the order information and a second part of columns with the manufacturing stages.
In one day, several manufacturing stages can be filled in, to avoid having to note the date multiple times, I would like that if we are at stage 4, the cells before it fill in automatically (with the same date, for example, it doesn’t matter much).
Do you have any solutions?
Thank you
Have a nice day
Configuration: Macintosh / Safari 10.1
For an order tracking, I would like that in my Excel file, if I fill in a cell, the cells before it in the row also fill in. Let me explain:
For tracking orders, I need to follow certain specific and/or urgent orders.
For that, I created an Excel table; there are multiple columns, a first part with the order information and a second part of columns with the manufacturing stages.
In one day, several manufacturing stages can be filled in, to avoid having to note the date multiple times, I would like that if we are at stage 4, the cells before it fill in automatically (with the same date, for example, it doesn’t matter much).
Do you have any solutions?
Thank you
Have a nice day
Configuration: Macintosh / Safari 10.1
Hoping it will be clearer with the table.
If I understand correctly, one possibility:
In D5 formula =IF(MAX(E5:$I5)>0,MAX(E5:$I5),"") to be dragged to the right
Then drag the columns down
Be careful, when you enter a date in a cell it obviously deletes the formula, in case of an error you need to rewrite the formula
Best regards
Via