Hello All, this is my first post and I am wondering how quick I will get a useful solution for my VBA newbie problem.
I want to copy data from a single column which has the following location "F9:F26283", the data is to be retrieved from approximately 100 excelfiles with the same tab/sheet name...
I'm fairly new to this and with some internet help I've managed to almost get it right, however would need my VBA to paste values only. I've tried with Paste:=xlPasteValues without any luck. Anyone able to help me tweak this one a bit so it copies only values?
Sub copytoHScode()...
I am new to VBA and coding in general. I am trying to copy/transpose/paste a two-column PivotTable and I need it to paste vertically and break on blank rows. I need to copy each group in the PivotTable and transpose paste values vertically on a new worksheet. I cannot figure out how to...
<tbody>
A
B
C
D
E
F
G
H
I
J
K
L
M
N
ID
category
week no
height
weight
week no
height
weight
week no
height
weight
week no
height
weight
2
blue
Week 2
98
22.1
Week 3
98.2
22.4
Week 4
98.6
22.6
Week 5
99
23
3
green
Week 2
98
22.4
Week 3
98.3...
Hello folks;
My very first post here...Using Excel 2016 with VBA.
I have created some code that will copy specific data based upon certain criteria. I'm not very good at VBA so it may not be the most efficient but I'm 98% there...the criteria works great!
I cannot for the life of me paste the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.