Get instant live Excel expert help to learn how to find range in Excel

Hello! How do I Create a one-variable data table for the range E2:H18 using the Number of Attendees as the column input cell. Format the results with Accounting Number Format with two decimal places.

I am using Microsoft DatePicker to give me a dropdown calendar wherever I need to insert a date on my sheet. In this case my "dates" are in A2:A100, D2:D100, and F2:F100. Here is the code I'm using and it works just fine. Private Sub DTPicker1_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) With DTPicker1 .Height = 20 .Width = 20 If Not Intersect(Target, Range("A2:A100, D2:D100, F2:F100")) Is Nothing Then .Visible = True .Top = Target.Top .Left = Target.Offset(0, 1).Left .LinkedCell = Target.Address Else .Visible = False End If End With End Sub My problem is that I simply don't know anything about VBA (this was built with great difficulty using YouTube). I want this code to extend across multiple sheets in my workbook. Suggestions?

I have a .csv product file and one column has pricing data and the column next to it is empty. I need to fill in the data that matches the pricing column. For example if one of the box is 22.99 I need the empty colum box on same row to be certain number. And if another box is same price then same number gets filled. But if it's different number different number is filled and so forth. 1. Do you see column P (Header is Variant Price) 2. Next to the column on the left is column O (Header is Variant grams) (So you can see that it's filled with 136 right) 3. I have to basically fill the column O (variant grams) that corresponds to number range 4. So let's say if column P has number range from 1-8.99 I need the corresponding column on left (O Variant grams) to be a certain number. So same row, and so forth 5. Column O is prefilled with 136 and the following range will be used to fill in the Column O boxes and delete 136 (if it's 136 then just it will not delete it) range 0 - 7.99 = 136 grams (word gram will be omitted just need it to be a number) 7.99 - 14.95 = 226 14.96 - 26.95 = 317 26.96 - 35.95 = 431 35.96-53.95 = 1360 53.96 - 64.95 = 2276 64.96 - 74.95 = 2948 74.96 - 1000 = 3175 These are temporarily ranges, but as my shop prices and shipping weight changes, I'm hoping the formula or vba can be easily changed by me

On Tab "Employee Information" I need Column V to use the if formula from Column P to decipher whether the Employee file Single "S", Married "M", or Do Not Withhold "DNW". Once it deciphers this, if the answer is "S" I need it to lookup the tab "Payroll Calculator" AG4 for the first Employee, and find the Gross Taxable Percentage from the named group "SingleFedTaxTable" or tab "Data" range H14 through I20, to find the percentage on J14 the J20. If the answer is "M" I need it to lookup the tab "Payroll Calculator" AG4 for the first Employee, and find the Gross Taxable Percentage from the named group "MarriedFedTaxTable" or tab "Data" range H26 through I32, to find the percentage on J26 through J32. If the answer is "DNW" I just need it to answer with a 0.

ESCRIPTION: I have a .csv product file and one column has pricing data and the column next to it is empty. I need to fill in the data that matches the pricing column. For example if one of the box is 22.99 I need the empty colum box on same row to be certain number. And if another box is same price then same number gets filled. But if it's different number different number is filled and so forth. 1. Do you see column P (Header is Variant Price) 2. Next to the column on the left is column O (Header is Variant grams) (So you can see that it's filled with 136 right) 3. I have to basically fill the column O (variant grams) that corresponds to number range 4. So let's say if column P has number range from 1-8.99 I need the corresponding column on left (O Variant grams) to be a certain number. So same row, and so forth 5. Column O is prefilled with 136 and the following range will be used to fill in the Column O boxes and delete 136 (if it's 136 then just it will not delete it) range 0 - 7.99 = 136 grams (word gram will be omitted just need it to be a number) 7.99 - 14.95 = 226 14.96 - 26.95 = 317 26.96 - 35.95 = 431 35.96-53.95 = 1360 53.96 - 64.95 = 2276 64.96 - 74.95 = 2948 74.96 - 1000 = 3175 These are temporarily ranges, but as my shop prices and shipping weight changes, I'm hoping the formula or vba can be easily changed by me SO UPDATE... I did a session and got this formula =IF(P444<14.95,226, IF(P444<26.95, 317, IF(P444<35.95, 431, IF(P444<53.95, 1360, IF(P444<64.95, 2276, IF(P444<74.95, 2948, IF(P444<1000, 3175, 0))))))) But this was wrong so need the correct one. So this is the formula I got for the second time =INDEX(Sheet1!$D$2:$D$9,COUNTIF(Sheet1!$C$2:$C$9,"<="&$P2)+1) and is accurate but not sure how to apply to the whole column.. same number shows up

If the range of cells present in a text, I want the name that is present, for example I have a list of user names, if their name is present in the paragraph, I want that name to be extracted

create a range named AE that includes every AvgRev value for Economy cars, and create a range named AP that includes every AvgRev value for Premium cars.

In the Airport worksheet, a. create a range named AE that includes every AvgRev value for Economy cars, and b. create a range named AP that includes every AvgRev value for Premium cars. AE stands for Airport Economy, AP stands for Airport Premium.

On Tab "Employee Information" I need Column U to use an if formula from Column P to decipher whether the Employee file Single "S", Married "M", or Do Not Withhold "DNW". Once it deciphers this, if the answer is "S" I need it to lookup the tab "Payroll Calculator" AG for the Employee's Taxable Gross Wage, and using this number find the Gross Taxable Percentage from the named group "SingleFedTaxTable" (or tab "Data" range H14 through I20), to find where the The Taxable Gross Wage falls between the H and I columns on the Data tab, the percentage on J14 the J20 from the row which the The Taxable Gross Wage falls in between then needs to be displayed on the "Employee Information" in column U. If the answer is "M" I need for it to do the same as above, but using the named group "MarriedFedTaxTable" or tab "Data" range H26 through I32, to find the percentage on J26 through J32. If the answer is "DNW" I just need it to answer with a 0. If there any way this can be worked out?

In cell E2, enter a formula using the HLOOKUP function to determine a staff member's base salary (which is based on the number of years of service). a. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since base salary is tiered based on the number of years of service, find an approximate match