last row of data

Hello - newbie here. Using VBA, I need to cut the last 36 rows of data and paste them to a new sheet. The actual number of rows will vary each time we use the sheet. Any help would be greatly appreciated!

Hello, I am fairly new to VBA. I have a long list filled with values where some are blanks. I want to select a range between the last value found in A-column, for example A300 and the last value found in B-column, for example B320. So far my code is: Dim IRow As Long Dim ICol As Long Dim rng...

Hello, I have a worksheet that collect data from various worksheets and insert them at a worksheet. I need when I press print , a text that is in another sheet to be placed at the last printed page. i.e. if the print is 3 pages then then text wil be placed at the bottom of the 3rd page. If 2...

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

Hi friends, I am using Microsoft Office 365 and found a macros code to use for my project. However, I am facing some issues whereby my appended "Result" data contains random cell notes (Example: Updated xxx). Is there any way to only append the main table data? Please note that I am not able to...

I have no idea where to start - i have searched the board and thought i may have found a pseudo solution but to no avail. This info may or may not be pertinent but I have 15 sheets - "Sheet1" I have set the Last Row as: Sub filtertests() Dim LastRow As Long 'Find the last row...

I created a macro by recording it, where I want to set an autofilter on a table that starts at row 11 and then select multiple entries. This is the relevant part of that code and it includes cell T4806 because that is CURRENTLY the last row of data...

Hi. I'm working through step-by-step creating a named range macro that will, eventually I hope, result in a range named the same as the worksheet name. My range starts at A2 and "should end" in column J at last row 416. The result I'm getting is =Nov_02_2016!$A$2:$J$2416. Clearing/deleting the...

Hi All, I am importing some data from a .txt file but the import data's first and last lines are un-important headers and totals which get in the way of how I am using the data. Other than having to manually delete them on each refresh what is the easiest way of automatically deleting them on...

Hey guys, First things first here is my code: Option Explicit Public Sub CopyDataLoad() Dim WSCount As Long, StartCellRow As Long, i As Long Dim sht As Worksheet Dim region As String WSCount = Worksheets.Count Application.ScreenUpdating = False For i = 3 To WSCount region...

Hi I am trying to ascertain worker caseloads for workers within the service for which I work by using the below; Sub CommandButton1_Click() Dim a, b, c, d, e, f, g, h As Integer Dim CC, LB, KC, TH As String Dim LstRw, Rw As Long Sheets("Recovery Caseload").Select LstRw = Cells(Rows.Count...