range

Hi all, I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check...

hello, I have had a look through quite a few posts but can't quite find what I'm after. I need to use some VBA to select everything between "START-OF-DATA" and "END-OF-DATA" These will constantly be moving when more rows are added in-between, but I don't want to have to keep changing the cell...

Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...

Hello, I have a table, table name "Reports" it is filtered in column J, and i am trying to get a count of just those rows that are visible but i am getting a high number like if it counting more than just what is visible, Is there a specific vba method to get this count, i tried using the below...

I am a beginner at Excel VBA. I just wanna know what code I am going to use for changing the value of the selected column if found duplicate. For example, I want to create a code that changes the duplicates found from their original name to their original name + "_01" (or something similar). It...

Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...

Hi alll, Just coming up with a difficult problem at the moment. Trying to SUM forecast data in a Range, but using unique variables to decide what that range is. Forecast Sheet is as follows; A2123456 Stock Sheet is as follows; F25 We want to be able to see based on the Date stock goes...

Hi, Thanks in advance for any advice on this. I am trying to get one cell to calculate a sum in a range of cells up to the cell/column that has a value on another row. Please see my example below: A1 should sum values in B1:E1 based on the last column that has a value in row 2. In the example...

I am in need of some help to do this in VBA. I have a range of values in a Workbook1.Sheet1.F2:F1048576. I wish to check if any of these values appears in a second range in Workbook2.Sheet1.A2:A1048576. (The actual length of each of both ranges will vary, hence why I've used the full length...

Hey all, I'm writing a macro to set the source data of a chart to several contiguous table columns but I'm stumped at the syntax. The table column headers can change so I'm trying to refer to their index numbers instead. 1 Dim Table1 as ListObject: Set Table1 = Sheet1.ListObjects(1) 2 Dim...

Hi all, I'm just trying to find a simple code that pops up a msg box saying if all the values of one range are matching all the values of another range or not. I know I can do that with a formula, but I need to do it with vba because I might use it in another applications...

lets say I have this table I would like a formula to count how many of the rows range contains the number X. for example how many row ranges contains the number 4? that would be 2 (the 4-9 and 2-5) I need this formula to be a part of a bigger one but currently I haven't managed this one yet

Good morning, I need the help to solve a problem. I need to search one text in a table with a range of date: Supplier Date Value A 19/10/2022 Madrid A 05/10/2022 Barcelona B 17/10/2022 Zaragoza B 09/10/2022...

Hello, I'm new to the forum. I've got a sheet where there sometimes exists shapes which cannot be targeted by the mouse (there are several different ones, they're not all the same shape). I want to be able to remove them anyway, however I want to also control which ones I remove since some...

I need to identify whether two dates (Start and End) fall within any months from 01 April 2021 to 30 September 2022 Some of the End Dates are blank which shows that particular record is still active. Example Just a small look into the columns. Apologies, don't know how to increase the number...

Hello everyone~ I have a problem with a task that I'm not sure how to do it. I have an excel file where I make quotations and it brings a total quotation at the end. According to that quotation result I have an ActiveX combo box that should bring a specific range of values, for example...

Im really not sure how to explain this but here goes, Starting from the right, as u can see each item has specific range of KP (from column K and L). We start with item 1 for example, which range from 0.211 to 0.216. Now i would like to match these range to the ones in column A. Once that...

Hello All, I need a formula that looks back 11 weeks from a given date and returns the Sunday at the beginning of that week. - Example, 27/10/2022. 11 weeks prior is 11/08/2022 and the Sunday beginning that week is 07/08/2022. The formula would return 07/08/2022. I also need one that looks...

I've got code here that will bring in information while looping through workbooks in a folder. It could be 5 workbooks or 50. Usually on the higher end. I'm bringing in 5 rows of information so every time i open a new workbook for information, i need it to go down to the 5th row and start again...