Hi,
I want VBA code that will copy from my master sheet (headers) "B1:E1" to my new sheet in Cell "A1:D1".
Thanks
Hi,
I want VBA code that will copy from my master sheet (headers) "B1:E1" to my new sheet in Cell "A1:D1".
Thanks
My English is very poor, so please be patient >_<"
Thanks & Regards.
hkbhansali
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-06-2017 at 12:47 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@ Alphafrog
Hey, where are your code tags lol....Just kidding he he
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
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).
Please Login or Register to view this content.
Hi AlphaFrog,
Thanks, this is exactly what I was looking for.
This showcases you are a role model and leader in our Forum.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks