VBA Code for acrosssheet

[hkbhansali]

Hi,
I want VBA code that will copy from my master sheet (headers) "B1:E1" to my new sheet in Cell "A1:D1".

Thanks

[AlphaFrog]

Please Login or Register  to view this content.

[sintek]

@ Alphafrog

Hey, where are your code tags lol....Just kidding he he

[hkbhansali]

Hi AlphaFrog,
I attached my sample sheet with code,it's perfect for me but problem is it's create new sheet and transfer data form "Master Sheet" "A:D" to new sheet "A:D"
hovever I want transfer data from "Master Sheet", "B:E" in to new sheet "A:C". (Skip Date row).

[AlphaFrog]

Please Login or Register  to view this content.

[hkbhansali]

Hi AlphaFrog,

Thanks, this is exactly what I was looking for.

This showcases you are a role model and leader in our Forum.

[hkbhansali]

Hi AlphaFrog,

I need some more help for above VBA Code, if possible..

I need that my macro detects that there is already a sheet with the same name,

msg box pop up "Sheet all ready exists,want to overwrite ?

vba yes/no, if yes, overwrite, if no nothing doing (cancel VBA).

Thanks