end of data

  1. JZonneveld

    END, SHIFT+ENTER in VBA

    Hi, I am new to VBA and these forums but since every question I put in Google directed me here I figured I'd just make my own account. I can't find a way to use the END, SHIFT+ENTER function from VBA. This is important because the file contains empty cells and the amount of colums varies per...
  2. S

    VBA End Row

    All, I know there are several help topics for VBA end row -- but, I'm still relatively new to VBA, and I'm not sure if I can insert one of them into the macro that I've recorded to automate one of my daily reports. I generate a report each day that summarizes all of the data M-T-D. Instead...
  3. M

    Insert copied row at end of specific table, then copy entire table

    I'll try to explain my scenario... I'm trying to make a guest list for parties, and I want to have these guest lists on a single worksheet. I want to have 2 macros that do 2 things: 1) Prompts to ask how many guests (and then copies the 4th row of the list (row 5) and pastes x times before the...
  4. D

    Need help using one sheet to determine which row to copy data from

    I have a single workbook with 2 worksheets: Azn_TrainA {Has row data A-J which I need to copy and paste at the bottom of Azn_TrainA} Extract {Column E has numeric data which states which row I need to copy from Azn_TrainA} I would like this to be a loop until all data from Extract has been...
  5. P

    Find the end of a data set and reference adjacent cells.

    Hi Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have an issue with a large data set but will try to explain it the best I can. <o:p></o:p> <o:p></o:p> In my template, in column A, I have a measurement which continues all the way down to 1002...
  6. N

    Select entire data range with blanks shortcut

    Hello, How do you select a set of data that is thousands of rows but has blank cells interspersed with cells with data? For example, lets say I have data in A2:A3000 but I only have data in ever 10 cells (e.g. data in A2, A12, A22, etc.). How would I quickly select all of this data? I know...
  7. A

    Macro to insert at end of data

    Hello - I am trying to format a file using a Macro - the file is exported from another source and the amount of records is variable. I want to copy and paste the first record onto the end of the file - I tried using copy, then cntl-end. However, the Macro records this as a static row so the...
  8. P

    Automatic data entry at the end of a list of data

    I have a spreadsheet with 19 worksheets (Excel 2007) and each worksheet has a date in column A, text in Column B, and numbers in columns C, D, and E. (It's my budget) At the start of each new month I need to go to the bottom of the data on each tab (Each tab has a different "Bottom of Data"...

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