Filling catagories + creating increasing numbers row

[Cheetah]

I have 2 questions:

1:
From this:
A1: category 1
A2:
A3: category 2
A4:
A5:

To:
A1: category 1
A2: category 1
A3: category 2
A4: category 2
A5: category 2

Edit: found at http://www.contextures.com/xlDataEntry02.html Very handy!

2: I want a column filled with numbers from 1 to X where X is the last active B-row.
I tried recording a macro by filling the first row with 1, and the second with =A1+1 but when it loops, it only fills 1,2,1,2,1,2 etcetera......

Thanks in advance guys, you are great

[se1429]

Hi,

Try this macro regarding your first question:

Please Login or Register  to view this content.

Make sure you backup your data before running the macro.

Regards.