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

hi iam doing a macro that copies a formula from cell 2 and past it down to the last cell, the problem is the last cell is changing everytime so i want the macro to automatically identify it! here is a sample of m code Range("H3944").Select Range(Selection, Selection.End(xlUp)).SelectRange("H3944").Select Range(Selection, Selection.End(xlUp)).Select

Using the hlookup function in cell h11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range e5:n8). Be sure to use appropriate relative and absolute cell references. Hint: you will need to use a funciton within the hlookup function to determine the appropriate row................. Something in my formula is not working. Can you help me?

We use a card processing service that uses fees. Their transaction range is weird and need help formulating in excel so we can just enter the balance and have the fee before we fill out any other information on the website.

Col 1, Col 2, Col3, Col4, Col 5 etc Row 1 = Name, Date 1, Date 2, Date 3, Date 4 etc Row 2 = Name1, 82, number, number, number etc Row 3 = Name2, number, 82, number, number etc I am wanting a summary Cell based on todays date that can be used to select the name of a person with a certain number. So the formula uses the same row references but the column reference will change relative to Today(). So, when Today is Date 1, Name 1 would display as it has 82 in one of the cells. If today was Date 2 then Name 2 would display as it has 82. I'm looking at Index Match but i don't know how to make the range dynamic in this way

why wont this work? Sub TwelveMonkeyssubmit() ' ' TwelveMonkeyssubmit Macro ' Sheets("12 MONKEYS").Select Range("K3,Q3,W3,AC3").Select Selection.Copy Sheets("Sheet2").Select Range("A1,A2,A3,A4").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Select ActiveSheet.Paste End Sub it should take data from "12 MONKEYS" "K3,Q3,W3,AC3" and paste it in Sheet2" "A1,A2,A3,A4"

I know how to select the first range, but I'm not sure how to select the second range at the same time. This is the question I need help with: Select the range A4:A7 and the range F4:F7. Create pie chart and move it to a chart sheet named Pie Chart.

I need help creating a pie chart Here is the instruction as far as what I need to do: Select the range A4:A7 and the range F4:F7. Create pie chart and move it to a chart sheet named Pie Chart.

Sub Omlaag() Dim i As Integer i = 1 Dim j As Integer j = 1 Do Until i > 6 Application.Wait (Now + TimeValue("0:00:01")) If Range("K" & j).Value > 0 Then Omlaag() & j = j + 1 Range("K" & j).Value = Range("K" & j).Value + 1 i = i + 1 Loop End Sub This is my Sub and I want it to repeat the Omlaag() Sub when reaching the If Range("K" & j).Value > 0, but next to this I also want it to execute the j = j + 1 function How do I execute 2 things in 1 If statement?

How do I execute 2 things in 1 If statement? Example: Dim i As Integer Dim j As Integer i = 1 j = 1 If Range("K2").Value > 0 Then j = j + 1 & i = i + 1 Executing 2 things in 1 if/then statement

How do I filter the "Leads Pivot" Table by a date range using excel on a mac?