Numbering Line Automatically

[chris89]

I want to have automatic incrementing line numbering in Column A, sheet "All_Amend", but only if there is adata int he corresponding cell in Column, after the data is copying from "Form" sheet.

Programme Amendment 1.1.xls
	A	B	C	D	E	F	G
14	No	Amentd	TxDate	Date	TxTime	Amendt	ProgrammeTitle
15		Date		Difference
16	1	12/01/2005	31/01/2005	13	asda	jhk	kh
17
18	2	13/01/2005	14/01/2005	1	wr	wef	kjk
19
20	3	15/02/2005	20/03/2005	24	kjl	ljl	ljlj
21
22	4	18/01/2005	13/02/2005	19
23
Form

Programme Amendment 1.1.xls
	A	B	C	D	E	F	G
159	79	24/01/2005	30/01/2005	5	12:30pm-1:00pm	Delete	Musical
160						Insert	CloseUp"Spider"(Ep.9)
161	80	26/01/2005	30/01/2005	3	7:00pm-7:30pm	Delete	EntertainmentNow(SS.2)(Ep.12)LastEpisode
162						Insert	EntertainmentNow(SS.2)(Ep.13)
163	1	12/01/2005	31/01/2005	13	asda	jhk	kh
164
165	2	13/01/2005	14/01/2005	1	wr	wef	kjk
166
167	3	15/02/2005	20/03/2005	24	kjl	ljl	ljlj
168
169	4	18/01/2005	13/02/2005	19
170
All _Amend

Pls help....

 

[chiello]

Try this:

Cartel1
	A	B	C	D
1			A1:=IF(B1<>"",1,"")
2	1	a	A2:=IF(B2<>"",MAX($A$1:A1)+1,"")
3
4	2	b
5
6
7
8	3	c
9
10	4	d
11	5	e
12
Foglio1

Does it work for you??

Post for feedback

Ciao

 

[chiello]

Html doesn't work..

Formulas are:

A1: =IF(B1<>"",1,"")
A2: =IF(B2<>"",MAX($A$1:A1)+1,"")
Copy down for A3, A4...


Ciao