Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an excel spreadsheet, with over 3000 rows. I have to review and
sort daily, then go back to the next blank row and start entering data. I am looking for a quick macro I can asign to a button that will take me to the next free row A?. Tried this ham fisted code, but not working 'find next line for data entry Dim CurrentRow As Integer 'this variable will be changed according to the row being searched CurrentRow = 13 Do CurrentRow = CurrentRow + 1 Loop While Worksheets("Concern Log").Range("B" & CurrentRow) < "" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
where can i find grid data entry in excel? | New Users to Excel | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
where on earth can I find data entry forms in Excel 2007 | Excel Discussion (Misc queries) | |||
Can't seem to find way to have easy data entry AND analysis - idea | Excel Discussion (Misc queries) | |||
How do I find an unknown value on a line made from known data? | Excel Discussion (Misc queries) |