Previous Topic Next Topic

How to increment numbers automatically in excel using macro

Closed
Bhavanim Posts 2 Registration date Thursday September 5, 2013 Status Member Last seen September 5, 2013 - Sep 5, 2013 at 03:57 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 5, 2013 at 08:58 AM
Hi,
I have a column A1 which has values like Tc001 and B1 and Tc002 > I just want to increment only the numbers. How can i achieve it using macros?

Regards,
Bhavani

4 responses

Answer 1 / 4
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 5, 2013 at 07:47 AM
in excel 2007
clcik excel icon on top left and click excel options
click advanced
check (put a tick) against
"enable fill handle and cell drag-on ....."

hit ok at the bottom


type in A1
TC001
take the cursor to bottom right of A1
The cursor will become plus sign(+)
click this plus, hold and drag down as many cells as you like.
0
Answer 2 / 4
Bhavanim Posts 2 Registration date Thursday September 5, 2013 Status Member Last seen September 5, 2013
Sep 5, 2013 at 07:51 AM
I am not able to do this when it is a merged cell. Can u help me in this?
0
Answer 3 / 4
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 5, 2013 at 08:56 AM
why merge cells? is it for sosmetic purposes. iln that case demerge and do this and merge again. otheriwse post the data. or send the file through speedyshare.com
0
Answer 4 / 4
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 5, 2013 at 08:58 AM
try at the end of the merged cells. does it work.
0

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses