range between cells

I have a list of clients and I am trying to see how many clients I have in multiple ranges of premiums. For example: how many clients do i have with premium between 5,000 and 10,000. The issue that I'm having is that the column I'm trying to calculate from has hidden cells so I think my range...

I have made a formula which corresponds to certain components. I need to make this formula for each day of the year for 9 components, using information from another worksheet in the file. However the cell range is from e.g. 1:23 for the second day it is 24:47, so forth. I cannot drag this...

Hi all, I am not able to write a vba code for a specific action I would like to do in excel. I attach two screenshots to explain myself better with an example. Screenshot_1: I want to write text "Level_1" in column A, until in column B the text "Level_2" is found. And then, do the same but...

Objective: I want to export a known range of Cells to a .txt file with the click of a command button. I want the file to be automatically saved with the name as the value of a cell (A12) I already did some research and was able to slightly change an existing code I found that someone created to...

Dear Seniors, I would like to share a question regarding unique list in between range. I have a data in which Column A have a range 1 to 999 and all are unique values. I want to show 1-333 rows data in Column B I want to show 334-666 rows data in Column C I want to show 667-999 rows data in...

Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Cells.Count = 1 Then Target.Value = UCase(Target.Value) End If End Sub I have this vba to change all lowercase to uppercase in the workbook. However, I would like to use this macro only on c12:c19 and c21:33. Is there...

Dear Excel Gurus, i am trying to arrange in my excel template a way where the VBA code can select a between range for a date range. eg. PromiseShip Date is the filer option and the range that i would like to select is 06/03/2017 - 12/03/2017. The data set is coming from the SQL Cube...

Hi, I want to put different text name for value depend on to which ranges value belong. My ranges: 0 - 15: text name: "AAAA" 6-28: text name: "BBBBB" more than >29 : "CCCCC" I have below code, but I know that my condition are wrong: looking_date = ws.Range("B2").Value if looking_date < 15...

Hopefully this will get a quick response. I need a formula for search B3:B18 if any of those matches G20 then 2, if not then -2

I have a range of cells in row 39, with calculated percentages. If a change is made that makes any cell in the range fall below 5%, I would like a popup stating "Exceeded 5% Availability". This is the VBA code I'm using so far with no result. Private Sub Worksheet_Calculate() If...

I need to judge whether a number falls between a range of 2 numbers. Ex: A1=332.024 B1=349.956 C1=335.23 So D1 must give 1 (since between the range) else 0. If C1=332.02 D1=0 If C1=349.9566 D1=0 If C1=332.024 D1=1 If C1=349.956 D1=1 What formula should be punched in D1? Thnx in adv

<tbody> I am realy new in Vba. I have a long data series in excel. but I want to select and cut some specific data range which are in column A and start with "MIN" till 33 rows after that. In each column there are 60 data series with...

Hi there I have got a spreadsheet with a database of people and all their details, Surname (E), Name (F), Gender (L), Date of Birth (M), Age (O), etc... So I have a demographics sheet that I calculate ages, gender etc and would like to do the following 2 tables. 1. Working out ages between 2...

Hello, I have to run a fairly tedious task of conditional formatting for large tables. The catch is that I have to run this formatting one column at a time and within sections. Obviously in small datasets, this is fine, but I am trying to get vba to do this for me since my tables can get quite...

Hi. I would like to use a excel formula to resolve this problem. Column C is the anwser I pretend. In the same cell it will return the name of the correct range. Ex: Between 200 and 300 there are numbers involved that are included in Range 1 and Range 2 (see second table) <tbody> Cell A B C...

I am trying to get the following to work: (rowCount is my variable) Range("L" & rowCount:"R" & rowcount).Select but I am getting a Compile Error:Syntax Error. Can anyone help me and let me know where I am going wrong with this? Many thanks J

I have used this subroutine to define an entire worksheet several times. Private Sub worksheet_beforedoubleclick(ByVal Target As Range, Cancel As Boolean) But I would like to be more surgical and specify specific cells. I need to detect a double click F2, F4, F6, F8 and F10, each of these...

(Spreadsheet can be downloaded at the bottom of this post, with all notes included). Hello peoples! I've always enjoyed trying to crack formulas myself and used this forum many times to help me, thank you. This one's got me stumped and I would really appreciate a nod in the right direction...

Hey guys and girls, I found this website via Google trying to solve a problem I'm trying to solve with Excel 2010, so I decided to make an account and post my problem here as it seems a friendly community. I have the following list (showing part of it)...

I have searched and searched threads and can't seem to find what I am looking for. The problem may be that I am an amateur and cannot convert what others have done in to what I am trying to do. The data is a copy of CSV file in to a spreadsheet. Below is what the paste looks like: 100100...