| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to generate next number
Hi,
Yuo can have a macro if you want but you don't need one, try this =OFFSET(Sheet2!A1,COUNTA(Sheet2!A:A)-1,0) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "puiuluipui" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to generate next number
Hi Mike. I really need a macro.
I am using some macros and i need to use this macro along with the other ones. But i really don't know how to make this work. Can you help me with a macro? Thanks! "Mike H" wrote: Hi, Yuo can have a macro if you want but you don't need one, try this =OFFSET(Sheet2!A1,COUNTA(Sheet2!A:A)-1,0) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "puiuluipui" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to generate next number
A macro it is then
Sub Sonic() Dim LastRow As Long Set SrcSht = Sheets("Sheet2") Set DstSht = Sheets("Sheet1") LastRow = SrcSht.Cells(Cells.Rows.Count, "A").End(xlUp).Row DstSht.Range("A1").Value = SrcSht.Range("A" & LastRow) End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "puiuluipui" wrote: Hi Mike. I really need a macro. I am using some macros and i need to use this macro along with the other ones. But i really don't know how to make this work. Can you help me with a macro? Thanks! "Mike H" wrote: Hi, Yuo can have a macro if you want but you don't need one, try this =OFFSET(Sheet2!A1,COUNTA(Sheet2!A:A)-1,0) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "puiuluipui" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to generate next number
On Tue, 9 Mar 2010 13:26:01 -0800, Mike H
wrote: A macro it is then Sub Sonic() Dim LastRow As Long Set SrcSht = Sheets("Sheet2") Set DstSht = Sheets("Sheet1") LastRow = SrcSht.Cells(Cells.Rows.Count, "A").End(xlUp).Row DstSht.Range("A1").Value = SrcSht.Range("A" & LastRow) End Sub +1 should be added at the end of the last statement like this: DstSht.Range("A1").Value = SrcSht.Range("A" & LastRow) + 1 Lars-Åke |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to generate next number
Hi Mike, your first formula gives me an error, and the macro retrieves the
last number. I need to display last number +1. Am i doing something wrong? Thanks! "Mike H" wrote: A macro it is then Sub Sonic() Dim LastRow As Long Set SrcSht = Sheets("Sheet2") Set DstSht = Sheets("Sheet1") LastRow = SrcSht.Cells(Cells.Rows.Count, "A").End(xlUp).Row DstSht.Range("A1").Value = SrcSht.Range("A" & LastRow) End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "puiuluipui" wrote: Hi Mike. I really need a macro. I am using some macros and i need to use this macro along with the other ones. But i really don't know how to make this work. Can you help me with a macro? Thanks! "Mike H" wrote: Hi, Yuo can have a macro if you want but you don't need one, try this =OFFSET(Sheet2!A1,COUNTA(Sheet2!A:A)-1,0) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "puiuluipui" wrote: 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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to generate next number
It's working.
Thanks! "puiuluipui" wrote: 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! |
| Reply |
| 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 | |||
Hybrid Mode
