auto numbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there
have got a tuff one here. Probably its easy for you guys but I am stuck.

I have got an excel database spreadsheet for incoming orders. So when the order leaves I put the date (leaving date)in a column next to it. The spreadsheet should return a downfollowing number in the next column.
Here is what I got
1. The cell where the number should appear has something lik
IF(C4,show number,""
(If in C4 is date out, then return the next number,""
2. The number should come out of a downfollowing number range that I store in another worksheet. Probably it should pick a number, cut and paste it in the cell, and don

Hope that somebody was able to follow this wheird explanation. Sorry about tha

Thanks for your tim

Matt
 
Matt
A little hard to follow. I gather that you have a number in another
worksheet. I also gather that you want this number incremented by one and
placed in a Column D cell when a date is entered in a Column C cell of the
same row. I assume that you want the number that is in this other worksheet
incremented at the same time. Is this right?
If this is right, you will need an event macro that is triggered by the
entry in Column C. The macro would look something like this: Note that I
elected to name the cell in the other worksheet that has the number
"TheNumber".
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Target.Column = 3 Then
Target.Offset(, 1) = Range("TheNumber") + 1
Range("TheNumber") = Range("TheNumber") + 1
End If
End Sub
HTH Otto
Matt said:
Hi there,
have got a tuff one here. Probably its easy for you guys but I am stuck.

I have got an excel database spreadsheet for incoming orders. So when the
Click to expand...
order leaves I put the date (leaving date)in a column next to it. The
spreadsheet should return a downfollowing number in the next column.
Here is what I got:
1. The cell where the number should appear has something like
IF(C4,show number,"")
(If in C4 is date out, then return the next number,"")
2. The number should come out of a downfollowing number range that I store
Click to expand...
in another worksheet. Probably it should pick a number, cut and paste it in
the cell, and done
 
That is what I want it to do, but I don't know how I can get this macro to work. Not so into Vb
Could you give me little advice ther

MAtt
 
Back
Top