| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to generate next number
Hi, i need a macro to look in sheet 2 column A and look at the last filled
cell. In the last filled cell i have a number. When i run macro, i need to generate (in sheet1 A1) the number from the last filled cell +1. EX: sheet 2 last filled cell = 29 sheet1 after macro i need to have in A1 = 30 Can this be done? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| generate different number | Excel Worksheet Functions | |||
| Serial number generate | Excel Worksheet Functions | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| how can text be set up to generate a number? | New Users to Excel | |||
| generate serial number | Excel Worksheet Functions | |||
Threaded Mode
