Help with synchronizing cells across worksheets

Hi Everybody,

First time posting here so I hope I have followed the rules correctly.

Attaches is a workbook titled "Work Allocation.xlsx" that contains 3 worksheets titled "Allocator" "2013-14 Planner" and "List".

The "2013-14 Planner" contains is a list of hypothetical employees and every day in the financial year. A list item "A, B, C, etc..." can be selected from a drop down list specified in the "List" worksheet against any employee on any day.

The "Allocator" worksheet is a smaller version of the planner that contains only Monday-Friday with the same drop down list. The only addition being the "Select Week" drop down on the top of the worksheet.

What I would like this workbook to be able to do is synchronize drop down items across both the "Allocator" and "2013-14 Planner" worksheets.

For example. I would like it if in the "Allocator" worksheet, changing the "Select Week" to Week 3 and assigning a list items against team members could transfer the same list value to the same team member in the corresponding day on Week 3 in the "2013-14 Planner" worksheet, and vice versa.

My knowledge of macros and VB is quite limited but I am keen to learn .

Any help would be greatly appreciated.

Hi Martin,

Thanks for your help.

So far this works great, although only from the "2013-14 Planner" worksheet to the "Allocator" and not the other way around.

Changing the drop down selection from the "Allocator" does nothing to the "2013-14 Planner", it also removes the formula that is in the cell .

Is there any way I can get it working both ways, i.e changes made to either the allocator or planner synchronize across both worksheets.

Thanks again

Every QTR. CHANGE COLOR OF WEEK

Thanks for the quick response Martin,

No I'm afraid not. I need to be able to allocate work or leave from the allocator to the planner and vice versa. Unfortunately my VBA is very limited .

It may seem pointless at the moment but there are other metrics on the allocator which facilitate the allocation process, which won't fit on the planner.