last row

  1. L

    Copy Paste Last Row VBA

    Hi I have this macro where it selects a range tehn copy and paste it on another sheet, but I would like to do it on the last row, is that possible? Sub CopiaDetalle() Ultimafila = Worksheets("U-Detail").Range("C" & Rows.Count).End(xlUp).Row UltimafilaD = Worksheets("Detail").Range("C" &...
  2. J

    Paste selected range of cells in other worksheets first free cell

    Hello, I know there are few similar threads and I've tried a few advised codes, but it still doesn't work at all. I've also tried to change them a bit to match my purpose but I failed (call me dummy, but I've spend the whole weekend working on this thing and my brain fails me). What I need is a...
  3. L

    Copy Paste Last Row VBA

    Hi, i have this macro, but i would like it to paste after the last row, what should I change? ' Fecha Rw = Range("AA" & Rows.Count).End(xlUp).Row With Sheets("Draft") For Each Cl In .Range("J7", .Range("J" & Rows.Count).End(xlUp)) If Cl.Value = "Active" Then...
  4. T

    Addition of "2nd footer" for each page?

    Hey all, Not sure how to really ask this question, but here goes: I have a spreadsheet I'm working on that I need to add some sort of additional footer for each page to be placed above the existing built-in footer and span across the entire width of the page. I suppose it could be a text-box...
  5. R

    Use VBA to make reference to last row of data

    I have a sheet "System Data" with a few thousand rows of data across dozens of columns. I have another sheet ""Stats" with 40 Sumproduct (SP) formulas, each parsing multiple points of data. The SP formula can take 20 minutes to render, which is painful to sit through. I suspect SP looks...
  6. S

    Auto-Fill Down - LAST ROW problems

    There are literally hundreds of posts on this forum that have to do with last row, I've run a few of the solutions and for some reason or another I just get error after error. Many of the macros/steps in my workbook are set to a specific point (highlighted below) because I have no idea how to...
  7. D

    Mergeing excel files into new workbook

    Okay, I am currently running the following code to merge several workbooks into one. I want to modify this code to insert all new data at the last row of a file that already contains all of the old combined files. What do? Sub MergeAllWorkbooks() Dim SummarySheet As Worksheet Dim...
  8. G

    Referencing last row in pivot table

    Hi, I have a pivot table that I can expand or collapse and an adjacent simple formula to calculate the difference between each row total and the grand total. i.e. =SUM(C6-$C$14) =SUM(C7-$C$14) What I want to do is to expand the pivot table and for the formula to still reference the last...
  9. bs0d

    Resize Table to Last Non-Blank Row

    I'm using a query to dynamically populate a defined table in Excel. I'm trying to re-size the table to the last non-blank row, without success. I'm getting stuck on detecting the non-blank row. Here's what I've tried (two different approaches), both find the last row the table is set to, which...
  10. S

    "Simple" Select Last Row & Last Column & Name Range

    I've found dozens of almost answers, but am too ignorant to take the pieces to do what I want. I need to find the last row and the last column and name the range. Many, many postings show getting the last row, or the last column, but not how to use both in the expression. And cautions against...
  11. A

    Sort columns B,C,D based on column B then loop to next 3 columns and repeat till last column

    Hi Guy's I am looking for a little bit of help if possible. I have a worksheet that contain numerous columns of data that has been imported from other worksheets. The columns start at column B and repeat every 3 columns. The number of columns can vary per worksheet. The number of rows can...
  12. B

    Use the value of a specific cell in the last row

    Hi everyone, I have a pretty basic spreadsheet with 8 columns. Data get added everyday (10 rows per day average) I've done my research on internet but it seems to be rather difficult to find the info I would need. And I am pretty much a newbie. I am trying to create a Macro linked to a button...
  13. richh

    Last Row is Always Row 1048576

    Hi all, I'm running into an issue that I can't seem to solve. My sheets are going to the absolute last row and are drastically impacting the file size of my workbook. Excel seems to think that my sheet goes to the very last row, even after clearing contents and deleting rows. This is turning a...
  14. F

    Last Row from different column

    I would like to copy the content from cells above blank cells to subtotal rows. (In this example, columns A, C and D). The last row should be determined by Column B, which contains the filter for the subtotals. There is something wrong with my syntax, and I can't figure it out. My code is...
  15. Y

    Last row capture issue

    Hello Geeks, I need a help on the issue i am facing in excel, the excel sheet which i am using has a problem like if i give a control + down arrow from the beginning of the table which has data, it should stop at the last line of the table. However it is not stopping and crossed the table and...
  16. K

    Suggestions to paste new data on last row....

    Hi all, The macro I run extracts data from multiple workbooks and I have set different ranges from where to copy & paste this data into one data sheet. Issue I am having is that when I run the macro it replaces the data from previous extract in my data dump sheet. Is there a way I can keep the...
  17. N

    Problems with R1C1 Formula Notation and Last Row

    Hi Everyone! As my username suggests, I am very new at VBA with Excel; however, I am really trying to create macros that can be utilized whenever. The one I am working on is one for my data. Its purpose is to sum Row 5 cell all the way down to the last cell row of data in the specified column...
  18. E

    Excel VBA last row with data in a column copy to another cell

    Hi! I have B column with hundreds or thousands rows (always different quantity). I need to copy last row (cell) with data (in the B column) and paste it, for example, to S15 cell. Please help!
  19. N

    Inserting countifs to the last row

    I would like to enter a countifs formula into the last row of Col A and have it be able to apply to any columns if it were copy&pasted. Criteria: Count everything in between the dates in Cells A1 and A2. Criteria Range: Everything from Cell A3 to the last Row or one above the countifs...
  20. Jeffrey Mahoney

    Gift for the Community (Select Any Part of a Range)

    The Function below allows you to return a smaller section of a range provided. Returnable ranges are: - a cell - a range - a row - a column - multiple rows or columns - last row or column - multiple rows at the bottom - multiple columns on the right All I ask is that you LIKE this or post you...

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