DanielMachin
New Member
- Joined
- Sep 9, 2014
- Messages
- 8
Hi Guys,
Could someone please help me. I am trying to copy B4, B6, E7, H4, L4, M37 from worksheet1 and paste it into worksheet2 in A, B , C ,D,E,F thus creating a new table.
I need the paste to be values(as there are formulas and drop down boxes etc in sheet1) and look for the next empty line in worksheet2.
Thank You.... I am new to VBA and have a slight headache from trying to work it out myself...lol
Could someone please help me. I am trying to copy B4, B6, E7, H4, L4, M37 from worksheet1 and paste it into worksheet2 in A, B , C ,D,E,F thus creating a new table.
I need the paste to be values(as there are formulas and drop down boxes etc in sheet1) and look for the next empty line in worksheet2.
Thank You.... I am new to VBA and have a slight headache from trying to work it out myself...lol