copy & paste columns vba

  1. D

    VBA Macro - Copy data from single column (from multiple excelfiles) and paste without blank cells in data acquisition workbook

    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...
  2. M

    VBA copy/ paste distinct values only, leave blanks and sort ascending

    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()...
  3. T

    Copy Transpose Paste Vertically Breaking on Blanks

    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...
  4. N

    Copy every n of cells every n of columns and paste in a new row, for every row

    <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...
  5. S

    Cannot paste to a specific column using VBA

    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've detected that you are using an adblocker.

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.
Go back
Back
Top