last row with data

  1. E

    Formula to enter the number of the last row with data

    Hello, Would anybody know, if this is even possible, a formula to enter the number of the last row with data in the file attached, so I don't need to updated the formulas every time we add rows ? Any help is welcomed. Thank you ABCDEFG1 name artist staffDistinct People5missing data from rolls...
  2. B

    VBScript to create pivot for entire data on a tab

    Hi All, I am trying to write a script to create a pivot table for the entire data set on a tab. When I record it and run the macro on a table with a larger number of rows, the macro set the range to only include the number of rows that existed in the dataset when the pivot was recorded. Can...
  3. I

    VBA to print up to last row of specific column

    Hello, I'm new at using VBA and would like to get some help. Let's say I have: Columns A:E Rows 1-5 are used as headers. I have this set so these headers print out on every page Below these rows, I have maybe 100 rows for data entry Column A is being used to name the row Columns B:D have...
  4. F

    VBA Copy last filled row from B to AV

    Hello, I´m looking for a way to copy the last filled row in an excel sheet using VBA. The problem is: I only want to copy from B to AV. So it have to find the last filled row, skip the first cell (filled with "Overall:") and copy the rest. Does anyone of you know a way to do that? PS...
  5. H

    Newbie Question: Need to autofill a range of cells based on values from another worksheet

    I'm trying to autofill a range in Sheet1 with an formula that calls data from Guests (another worksheet in the same workbook). But I need it to end at the last row of data from the Guests worksheet. The macro runs currently, but I don't want to have to change the range every time. And this macro...
  6. I

    Copy the data in the amount of columns specified by a cell

    Hi, I am looking to see if there is any way I can copy the data in the amount of columns specified by cell "A1". For example, Sheet 1 A1: 3 (Column Count that data should copy from) B3 to end of data C3 to end of data D3 to end of data The idea is to copy the amount of columns...

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