Hello,
As you all know, anything's possible with excel.
basically we've created a form of scheduling program with excel. this consists of multiple different sheets representing each working day across a 4 week routine.
e.g
week1/week2/week3/week4
Monday Tuesday Wednesday Thursday Friday for each week
We have a back log to assign addresses (where these jobs are completed) to their relevant sheets. these are logged into the relevant sheets via a button.
what we would like to do is make it so the same address information (a range covering 3 cells in a row) can be posted to the relevant sheet/s only once, however if it is decided to change the day and/or week instance (therefore sheets) then it will log into the new sheet/s (still keeping the old one too as we clear all the posted information at the end of the month).
we also need to cater for completely new entries.

Any help will be appreciated