We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim Numb As Long Private Sub Workbook_Open() Dim lastRow As Long lastRow = Sheets("Temp").Range("A" & Rows.Count).End(xlUp).Row Numb = Sheets("Temp").Range("A" & lastRow).Value + 1 Sheets("EXPENSE FORM").Range("N2").Value = Numb Sheets("Temp").Range("A" & lastRow + 1).Value = Numb ActiveWorkbook.Save End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need help Creating PowerShell Script||4||42|
|compare column in an Excel spreadsheet.||1||41|
|Calculating earleist date and latest date based on MAX and MIN in Weeks and Days Late.||2||41|
|Excel Macro causing an incorrect entry on first line||5||14|