first blank row

  1. K

    Copy and Paste Data from CSV file to first blank row in worksheet of second workbook

    I have a workbook (BoardTime.xlsx) tracking board member time. Each board member will send me a CSV file with their information for a period of time (CSVExport.csv). I need to copy the data from columns A through E from CSVExport.csv starting in cell A2 to a worksheet in BoardTime.xlsx named...
  2. C

    Populate cells from list box drag/drop, can't find first empty row on worksheet

    Hello, I am running Excel 2010 and Windows 7. I have been working on this project for several weeks and this problem has eluded me from nearly the beginning. See Photo I have a form with a main list box and several other list boxes. I drag and drop records from the main list box to the...
  3. P

    Copy till first non-blank row and paste on first blank row

    I'm working on this macro that copies data on sheet1 from A2:AI2 till the last non-blank row in the same range i.e. A:AI and paste it on sheet2 in the first blank row. However, my code keeps picking up A1:AI1 from sheet1 as well and pastes it on sheet2 just before the data that I actually want...
  4. M

    Find first blank row

    I've search for threads containing blank row but I get too many threads containing the words Blanks or row. I want to put it in a macro to find the first blank row (or last row with data and add one row) to continue with the macro. As I recall it's something with an xUp command but that's all...

Watch MrExcel Video

This Week's Hot Topics

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
Top