Sequential Numbering

[JakeinCLT]

Hi all, I'm new to this site. I'm building a cabinet part calculator to help me stream line process. I would like to use an number and letter in the same cell to identify the cabinet(letter) and the part(number).

I will try to explain:

At the top of the sheet in cell D3 I have V1("v" for vanity #1)
And then all down column A I need part numbers such as V1-1,V1-2,V1-3.....

This will be my third cabinet calculator. I hope to organize this one better each time. Of course Im stumped on the first column.

Regards,
Jake

 

[T. Valko]

Hi all, I'm new to this site. I'm building a cabinet part calculator to help me stream line process. I would like to use an number and letter in the same cell to identify the cabinet(letter) and the part(number).

I will try to explain:

At the top of the sheet in cell D3 I have V1("v" for vanity #1)
And then all down column A I need part numbers such as V1-1,V1-2,V1-3.....

This will be my third cabinet calculator. I hope to organize this one better each time. Of course Im stumped on the first column.

Regards,
Jake

If you type in cell D3:

V1-1

Then, "grab" and hold the fill handle with your left mouse button. The fill handle is that little black square in the bottom right hand corner of the selected cell. Then drag down and the -1 will increment as desired.

If you need the V1 to incremnt then you'll have to give a more specific explanation of how the sequence increments.

 

[JakeinCLT]

Thanks for the quick response. I probably didn't explain that very well, and since I'm a newbie I cant post a screen shot.

At the top of my page I have a Header with the cabinet info in separate cells. One of those cells[D3] contains the assembled cabinet ID#, which is V1. To identify each part of the cabinet I want to use the whole cabinet # dash 1,2,3,4,5....

In column A, it would look like:
V1-1
V1-2
V1-3
V1-4
etc...

I read the help section on including text and numbers in the same cell. I'm just not sure how add to the dash 1,2,3,4,5....

Thanks,
Jake

 

[MukMuk]

You can try this:

<TABLE style="WIDTH: 219pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=290><COLGROUP><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 768" span=2 width=42><COL style="WIDTH: 155pt; mso-width-source: userset; mso-width-alt: 3766" width=206><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 32pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=42>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=42>B</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 155pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=206>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>V1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=A2&"-"&B2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>V1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=A3&"-"&B3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>V1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=A4&"-"&B4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>V1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=A5&"-"&B5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>V1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=A6&"-"&B6</TD></TR></TBODY></TABLE>

Hope it helps.

 

[T. Valko]

Thanks for the quick response. I probably didn't explain that very well, and since I'm a newbie I cant post a screen shot.

At the top of my page I have a Header with the cabinet info in separate cells. One of those cells[D3] contains the assembled cabinet ID#, which is V1. To identify each part of the cabinet I want to use the whole cabinet # dash 1,2,3,4,5....

In column A, it would look like:
V1-1
V1-2
V1-3
V1-4
etc...

I read the help section on including text and numbers in the same cell. I'm just not sure how add to the dash 1,2,3,4,5....

Thanks,
Jake

What I described in my other reply will do what you want.

Enter in D3: V1-1

With cell D3 still selected...

Hover your mouse over the fill handle until the "fat plus sign" turns into a "skinny plus sign". Then "grab" the fill handle by left clicking and holding then drag copy the down the column. As you do the entry will increment as such:

D3: V1-1
D4: V1-2
D5: V1-3
D6: V1-4
D7: V1-5
etc
etc

 

[Nalani]

At the top of my page I have a Header with the cabinet info in separate cells. One of those cells[D3] contains the assembled cabinet ID#, which is V1. To identify each part of the cabinet I want to use the whole cabinet # dash 1,2,3,4,5....

In column A, it would look like:
V1-1
V1-2
V1-3
V1-4
etc...

I think the OP is using Row 3 as a Header and wants the "numbering" in Col A like so:

Excel Workbook
	A	B	C	D
3	S1	T1	U1	V1
4	V1-1
5	V1-2
6	V1-3
7	V1-4
8	V1-5
9	V1-6
10	V1-7
11	V1-8
12	V1-9
13	V1-10
14	V1-1
15	V1-2
Sheet1

A5 copied down.

This is wrong though because after V1-10, it goes back to V1-1.

 

[JakeinCLT]

Thanks everyone,

Nalani's picture is what I'm trying to do(without the repeat of course).

@Biff, I'm using Excel 2004 for Mac. I have a white fat + sign when I hover over a cell, and a thin solid black + sign when I click and hold the lower right corner of a cell. Is the fat black + sign a newer feature? It's Tax Free Weekend here in NC, so upgrading might be a good excuse to stimulate the economy.

Thanks,
Jake

 

[T. Valko]

Thanks everyone,

Nalani's picture is what I'm trying to do(without the repeat of course).

@Biff, I'm using Excel 2004 for Mac. I have a white fat + sign when I hover over a cell, and a thin solid black + sign when I click and hold the lower right corner of a cell. Is the fat black + sign a newer feature? It's Tax Free Weekend here in NC, so upgrading might be a good excuse to stimulate the economy.

Thanks,
Jake

I don't get a fat black + sign in my versions of PC Excel. It's a fat white + sign.

 

[JakeinCLT]

Thanks Biff,

Yeah, the fat white + sign is the regular cursor. Since I'm on a mac some things are different. Thanks so much for helping me.

Regards,
Jake

 

[T. Valko]

Thanks Biff,

Yeah, the fat white + sign is the regular cursor. Since I'm on a mac some things are different. Thanks so much for helping me.

Regards,
Jake

Good deal. Thanks for the feedback!