copy cells with data

  1. T

    # of events vs Day of week. Compare 2 columns, then copy # events cell

    Hi. I have 2 columns: B & D. B has # events. D has day of the week expressed as a value (2-7 from Mon-Sat respectively). I'd like to copy the values in B over to J20 thru O20 (J-O represent M-Sat as you probably expect) IF they have the same column D value (day #). Conceptually, it's just copy...
  2. X

    Excel Macro to copy data in cell to multiple cells in the same row

    Hi I am a beginner in VBA scripting but I am working on a sheet where I want to copy data in one cell to multiple cells in the same row as long as it is not empty but separate the two data by a comma and do this through out the table Before Macro...
    • xlstarter
    • Thread
    • copy cells with data duplicate data find last column find last row macro
    • Replies: 3
    • Forum: Excel Questions
  3. C

    Copy cell range if cell has data paste offset

    Hello, I have a spreadsheet with data that sometimes every 20th row is misaligned. The sheet will be of varying row lengths depending on the data so I have nothing set. What I need is a macro in VBA that will find the first cell in A1 of Sheet1 with data and if there is data in that cell (lets...

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