Automatically fill cells if a cell is filled
Solved
Mdrt47
Posted messages
15
Status
Member
-
via55 Posted messages 14393 Registration date Status Member Last intervention -
via55 Posted messages 14393 Registration date Status Member 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
2 answers
-
Hello
Not very clear
Can you post an example of your file on cjoint.com, create a link, copy it and return to paste it here
Manually write in red in the appropriate cells the dates you would like to see appear
Regards
Via
--
"Imagination is more important than knowledge." A. Einstein -
Hello to both of you
Not very clear, but a try anyway (with macro)
http://www.cjoint.com/c/GHznyjYXpZB
Best regards
