Hi All,
I'm relatively new to Macro's and VBA and am having difficulty getting a macro set up.
What I want it to do is to take 9 value's from cells in sheet HL2 (D155-F157)and copy them into 9 cells in another sheet named PD (E3-G5). I will need the macro to run on 5 other sheets as well as do some other bits and pieces.
I have looked through posts already and tried lots of things but nothing has worked. How do you reference a worksheet which has spaces in its name?
Hopefully if someone can help me get this section working I can get the other functions I need set up.
Thanks
Bookmarks