I have 2 questions:

1.
In my workbook:
Sheet 1 there is text accross multiple rows
If column A in sheet 1 contains text I want that text (sheet1, column A) to be also seen in sheet 2 column "B"

2.
if Column B (in sheet 2) has text I would like column A to contain sequential numbers eg 1, 2, - Numbers in Column A only happen when there is text in column B - The sequential numbering will start in row 3, but the first number should be one.


Does that make sence?
Issy