range

Hi there, I have a worksheet, that has data, but want to start the capture on line 9. I tried to use the below to find the last row for S9, but seems when running this, it only copies/pastes F9. I would like it to continue until the last row of S9:end. Note that S9 starts with values, then has...

Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...

Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...

Hello, I'm trying to figure out how I can select a range based on a date within the current week. Example of selection… The order I'm trying to step through is the following: 1. Declare Friday as a variable to store the date using a formula: =TODAY()-WEEKDAY(TODAY(),16)+7 As of today...

Hi I am trying to save the data into the MainInventory but unable to do as I keep getting this error When my sheet is empty and insert the second row as my first row is headers row the data is inserts fine everything works fine but as i enter the third row this pops ups and my vba closes and...

I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...

Is there a way to only copy certain columns from an auto filter? With the below example the active sheet has 8 columns of data G, L, P, R, S, T, W, AB (other columns have been hidden) When I copy the data, I don’t want to copy column W & AB so that only 6 columns of data will be moved to...

Hello! I've searched high and low across multiple forums for this specific answer, but I can't seem to find it based on cell value. I can find the VBA code for ALL worksheet names to be listed in the ListBox, but not specific ones based on cell value to be used as selections for printing...

Hi, trying another range, and for some reason it's not pulling all the details. Set WBrng = Range("A1", Range("J" & Rows.Count).End(xlUp)) WBrng.Copy it's only displaying A1-J1. I'd like the last row to be dynamic in the event it goes longer than 9 rows: sample data: Header Header...

hi! I have a sheet which contains content in cells A1:H3, row 4 & 5 is blank, and row 6 starts a new table A6:H9. I was trying to declare a range for A1:H last. In the event the top table 1 row, or 2, or 3, I wanted to have the range select the last row. doesnt appear to be working properly...

Can anyone please assist me on this request and here's the link for it: https://stackoverflow.com/q/76588334/13644020

Hi, I'm wanting to count the number of 'Yes' values in columns B and C, but only count the 'Yes' values after the last entry in column D for the associated location. In the attached example, for Kettering the count should result in 1, as there is only 1 'Yes' in columns B and C if we count...

I am using the following for a macro: Dim y As Long For y = 1 To Cells(Rows.Count, “AK”).End(xlUp).Row If Range(“AK:AM” & y).Value = “DRUG REQUIRES PRIOR AUTHORIZATION” And Range(“A” & y).Value = “” Then Range(“A” & y).Value = “PA REQD” End If Next y However, I keep getting an error...

Hi Mr Excel, How to get result in Column Q & S? Given number of range to check for Column Q in M , Column S in O The Range to check in Column G. Example : Cell O6 show 2 number of range , then check how many value < -0.6 in Column G and the result is 1 in Column S. Same goes to Column M for...

Hello. I need a formula that looks for the value in a cell and compares it to a range of cells to throwback if there is a match anywhere in the range of cells. I would also like the formula to exclude considering blank cells so I do not end up with false No Matches. Example of the data is below...

Hi all, I am trying to find the way to obtain the minimum value from a range, with some conditions. So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...

Is there a way in excel to have a select range of columns in a row following a reference cell? Situation: I have a set range that is part of a data pull and populates information off a reference ID# that I pull in from a data set. The downside is that I have some manual cells that I use for...

Hello, I’m not sure this is the best way to go about it.. But I need code to get a specified range in a macro. The range is variable .. so I’m trying to use keyboard shortcuts like “ctrl + home” and “ctrl + end” to get the correct range. The problem is when I start let’s say at the bottom...

Situation: I have this VBA code that logs any change that is made in the excel sheet and that great; but i need it modified. The plan is to use this in one column as a master change log. But i need a sepret one that will log the window user ID / DATE / Time and lock it to the ROW they edited. So...

I found this by Snakehips and it was VERY helpful ! I tried to modify it but found that it only works with numeric entries and not alpha numeric entries. Rich (BB code): Sub Fill() [A4] = [A1].Value ato = [B1].Value [B4] = [A2].Value bto = [B2].Value [C4] = [A3].Value...