Dynamically add Worksheet / rename / update the formula to include the new worksheet

[Rajnishbhatt]

Hi All,

I need help in following

First:

Column "E" contains the worksheet name in "Project Master" sheet

When a new resrouce is added in the "resource master" in the "Project Master" Sheet I want to duplicate "UDA_Master_Sheet" sheet automatically and place it before the Sheet named as "End" and rename it as worksheet name from the Column "E" in the "Project Master"

Second:

In the "EventList" sheet I have Added column "L" to "M" for each resource and in Column "L" I am calculating all the efforts (through the formula) for the selected week in the same sheet in "K1"

I want to automatically create Columns in "EventList" sheet like "L" (currently it is created manually) for each resource from the "resource master" from the "Project Master" sheet and calculate the value for their respective sheets as per the current formula in "L".


Thanks in Advance, Need macros to do all this as worksheet performance is very slow.

Rajnish

TeamEfforts.zip