Forum Discussion
Solved
Auto-fill the same date multiple times
At work we keep worksheets that contain the information for scheduled hours run on a machine and I was looking for a way to automatically populate the date row without the need to copy and paste the ...
It depends. If, for example and as variant, your list of machines is always in the same order, you may use the name of the machine first in list as the trigger to move on another day. For this
in B3 it could be
=B2+(A3=101)
and drag it down till end of the range. Assuming you don't skip weekends and public holidays.
It depends. If, for example and as variant, your list of machines is always in the same order, you may use the name of the machine first in list as the trigger to move on another day. For this
in B3 it could be
=B2+(A3=101)
and drag it down till end of the range. Assuming you don't skip weekends and public holidays.
Hi Sergei,
Thanks for the reply but will this work if the machine list is stored as text and not a number?