last row

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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!

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...

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...

Hi all, I am very new in working with VBA, so please have patience with me. I am working at a project which I need to copy specific cells from one sheet (the master sheet) into another sheet (upload sheet). The cells I need to copy from the "master sheet" need to be copied to the "upload...