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

Macro So the macro I want will take information from the inbound daily load plan. The macro will be like an update button. So for example the information for DD 130 (H column) or DD 228 (H column) should be filled to match the data provided from the inbound daily load plan tab rows 15 and 16 column J. Now should I later change doors 130/228 to rows 38 and 39 I would want the data on the breakdown tab to update the information viewed when the button I clicked again. The J column in updated manually throughout the day that is why the macro will need to be reading through the range of the column…ask questions if need be so I can clarify. Also Row 5 on the breakdown tab is pulling from G column

Copying and pasting a range using VBA to Word document. I have code for a cell. Just need a range

Can someone show me how to plot y as a function of x for the range of times?

In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K7:K32. what is the correct formula to use?

I need to copy and paste the same range on 100 worksheets into one list on a summary tab. I actually used this last night and misplaced the file i needed.

This is my micro formula for excel 2016 how can i make this work for the whole sheet Private Sub Workbook_Open() Dim c1 As Range Set c1 = ThisWorkbook.Sheets("Sheet1").Range("B3") If IsDate(c1) Then If Now >= c1 Then MsgBox "The Date in Sheet1 cell b3 has been reached or passed." End If End If End Sub

hello so i got this formula from you but i dont know how to divide each line so its written properly can you tell me each part on each line Private Sub Workbook_Open() lst = ActiveSheet.UsedRange.Rows.Count Dim c1 As Range For i = 1 To lst Set c1 = ThisWorkbook.Sheets("Sheet1").Range("B" & i) If IsDate(c1) Then If Now >= c1 Then MsgBox "The Date in Sheet1 cell b3 has been reached or passed." End If End If Next i End Sub

i have a custom function (vba code) to reverse words in a string, but it only works by having the cell reference (which contains the string of words) within this custom function, but not the string itself. Can you modify the vba code for me to make this work both ways or just allowing the string in this custom formula will be enough. Function ReverseWords(cell As Range) Dim InputStr As String Dim InputArray() As String Dim OutputArray As String Dim WordsCount As Integer InputStr = cell.Value 'Split all the words and put it 'in an array InputArray = Split(InputStr, " ") WordsCount = UBound(InputArray) 'Read all the words in reverse 'Order and return to function For i = WordsCount To 0 Step -1 ReverseWords = ReverseWords & InputArray(i) & " " Next End Function

HI i am trying to write a sumifs formula that when pasted over to the next cell the sum range will skip six columns in the data dump. i.e.my current formula in A1 is =SUMIFS('Data Dump EO & BN'!E:E,'Data Dump EO & BN'!$B:$B,'New Format'!$C$2:$T$2,'Data Dump EO & BN'!$A:$A,'New Format'!$A$35) When i paste it over into B1 E:E goes to F:F in the data dump but i need it to go to K:K without manually doing it.

getting errors for the code below: Private Sub Auto_Open() Dim vntToday As Variant vntToday = WorksheetFunction.Text(Date, "mmmm dd") On Error Resume Next Sheets(vntToday).Select If Err <> 0 Then MsgBox "Worksheet doesn't exist." Else: Range("A1").Select End If End Sub