ErikAnderssonen
New Member
- Joined
- Jun 15, 2016
- Messages
- 1
I'm having a problem.
I wish to create a Excel template to use in my daily work. Today i use Word and it is a pain in the ** when copy and pasting.
My wish is to have a column which works lika a numbered list. The Excel template will display a list of items and I which to numer these descending (like 3.1, 3.2, 3.3...)
[TABLE="width: 500"]
<tbody>[TR]
[TD]3.1[/TD]
[TD]Name of product[/TD]
[TD]123456[/TD]
[TD]1 pcs.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Some technical text[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]And some more[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3.2[/TD]
[TD]Product 2[/TD]
[TD]654321[/TD]
[TD]3 pcs.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Technical text[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there any good solutions for this? Like a drop down list which displays the next number depending on the number above (there could be some blank cells between and may vary).
And is there any useful solution which can by automatic change the numbers below if I insert a/(a couple of) new row(s), like it would if I used a numbered list in Word.
I wish to create a Excel template to use in my daily work. Today i use Word and it is a pain in the ** when copy and pasting.
My wish is to have a column which works lika a numbered list. The Excel template will display a list of items and I which to numer these descending (like 3.1, 3.2, 3.3...)
[TABLE="width: 500"]
<tbody>[TR]
[TD]3.1[/TD]
[TD]Name of product[/TD]
[TD]123456[/TD]
[TD]1 pcs.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Some technical text[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]And some more[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3.2[/TD]
[TD]Product 2[/TD]
[TD]654321[/TD]
[TD]3 pcs.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Technical text[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there any good solutions for this? Like a drop down list which displays the next number depending on the number above (there could be some blank cells between and may vary).
And is there any useful solution which can by automatic change the numbers below if I insert a/(a couple of) new row(s), like it would if I used a numbered list in Word.