J
jpvaltorta
HI Ron have been playing around whit your mastersheet macros but am
failing to try and adapt you awsome work to do what I want to do was
wondering maybe if you could help. I have built a order shett for use
inside my company and have 5 deparments to which I have given excel
based order forms then I have a master on my computers where I have 5
tabs which copy the link from each page.Then I have a six tab which is
my master in this master I want to copy all the ordered product from
the five tabs so Your second Macro Is great as I can copy from a
specific row but dont no how to copy a specific range if there is
information in the cells also want to copy it in a defined are so it
still looks like an order form. I will edevour to play around with
your great work if you are able to point me in the right direction
would be great
kind regards
James
failing to try and adapt you awsome work to do what I want to do was
wondering maybe if you could help. I have built a order shett for use
inside my company and have 5 deparments to which I have given excel
based order forms then I have a master on my computers where I have 5
tabs which copy the link from each page.Then I have a six tab which is
my master in this master I want to copy all the ordered product from
the five tabs so Your second Macro Is great as I can copy from a
specific row but dont no how to copy a specific range if there is
information in the cells also want to copy it in a defined are so it
still looks like an order form. I will edevour to play around with
your great work if you are able to point me in the right direction
would be great
kind regards
James