Copy Data Create a New Sheet Name Should be Based On Cell D7 value and paste here

[HaroonSid]

hello
i have data on sheet one range A:I

i have want to copy data and create a new sheet with new name (Name should be What value is in Cell D7) and paste the data on new sheets.
if i copy paste again and D7 value is changed then make new sheet with the name of D7 value and paste on new sheet...

e.g i have data in range A10:I50 and D7.value = 15-Apr-2014 then
copy the data of range A10:I50 and create a new sheet with the name 15-Apr-2014 and paste here

if i changed the value of D7.value = 16-Apr-2014 then
create the sheet with name of 16-Apr-2014 and paste here

thanx

[:) Sixthsense :)]

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

[HaroonSid]

nothing happening

[:) Sixthsense :)]

It's working fine for me and not sure whats going wrong at your end

[HaHoBe]

Hi, :) Sixthsense :),

it might be the missing information that there is a formula in D7 which won´t be triggered by the event or another event of the same name behind the sheet.

Ciao,
Holger

[:) Sixthsense :)]

Hi Holger,

Nice Catch and Yes it may be the one of the reason

In that case the OP should replace the Worksheet_Change to Worksheet_Calculate

[HaroonSid]

ups!
Sorry Sixthsense
there is just beginners mistake
now evrythig is fine and working perfect
thanx alot very much


+1 Repu

[HaroonSid]

and thanx to u too HaHoBe

if d7 have formula then use this should replace the Worksheet_Change to Worksheet_Calculate
in future it will help, if 1 use the formula in d7 then i will change in Worksheet_Calculate
thanx alot to learn a new one