Refer dependent drop down in another workbook

[Naveen N]

HI Team,

In Sheet1, I have Months and Week off Information.

In Sheet2 I have created a dependent drop down list, based on the month selected, the weel off would be displayed.

I need to Week off column to be displayed in another workbook.

Please suggest how do I do this. Please find enclosed workbook

I needed to do this since I need to use month and week off as a master sheet and refer this in many other workbook.

Regards,

Naveen N

 

[NARAYANK991]

Hi ,

You have asked this question earlier , and it has been answered.

You have two options :

1. If you use the external workbook range for the dropdown in your workbook , for it to work , both workbooks will have to be open.

2. If you use formulae to bring over the external workbook range into your workbook , and then use this internal range for your dropdown , then the external workbook does not need to be open for the dropdown to work.

Are you wanting to do something else ?

Secondly , is there any logic to how these week ranges are arrived at ? If so , if formulae can be developed to arrive at the range if the month is available , then the week ranges need not be stored in any master sheet , but can be derived in every workbook where they are required.

Narayan

 

[Naveen N]

HI Narayan,

Currently I am using below formula to get week start
=TODAY()-WEEKDAY(TODAY())+1
and add +6 to get week end.

Also in the month end if the week end comes in the middle of the week, I am manually editing the week end for the month end (line 31/6/2016 is on Tuesday).

I need work on using month and year to generate week start and end date in master sheet.

Regards,
Naveen N

 

[Naveen N]

using month and year, how can we generate week start and week end date. Please suggest