Multiple questions for beginners

[excelnewlearner]

Hi

New to the forum. With fairly basic excel skills. I am trying to make life easier by creating a template that can do the following.

A) in a sheet that has lots of items labelled numerically in the first column I.e. 1, 2, 3 ....
With a line in between each one for clarity...often I have to add new items which means I have to manually renumber from the top. Is there a way to do this automatically?

Obviously if there wasn't a row separating each one I could just drag down.

2) each number is linked to another sheet/tab which Is a backing sheet. Can this be automated to change automatically too? Sometimes I have to rename 50 items and backing sheets just because I entered a new row.

3) to make life easier I wanted to be able to generate quotes using a drop down. If I were to create the list then data validate is there a way that selecting from the list can pull the whole row of information into the sheet.


Hope this makes sense. Would really apprechiate the help.


Many thanks

 

[Scott Huish]

If they're sequential numbers, I don't understand why you would be adding #s in the middle, but it's easy to create that pattern with a formula

Book2
	A
1	CODE
2	1
3
4	2
5
6	3
7
8	4
9
10	5
11
12	6
13
14	7
15
16	8
17
18	9
19
20	10
21
22	11
23
24	12
25
26	13
27
28	14
29
30	15
Sheet1

Cell Formulas
Range	Formula
A2:A30	A2	=IF(MOD(ROWS($A$1:A1),2),-INT(-ROWS($A$1:A1)/2),"")

THen if you insert rows you can just copy the formula from above and paste down.

 

[excelnewlearner]

If they're sequential numbers, I don't understand why you would be adding #s in the middle, but it's easy to create that pattern with a formula

Book2
	A
1	CODE
2	1
3
4	2
5
6	3
7
8	4
9
10	5
11
12	6
13
14	7
15
16	8
17
18	9
19
20	10
21
22	11
23
24	12
25
26	13
27
28	14
29
30	15
Sheet1

Cell Formulas
Range	Formula
A2:A30	A2	=IF(MOD(ROWS($A$1:A1),2),-INT(-ROWS($A$1:A1)/2),"")

THen if you insert rows you can just copy the formula from above and paste down.

 

[excelnewlearner]

Thanks I will try this. Basically I might need to add a new item between say #2 #3 because either makes most sense for it to be with that section of other items. So the new item becomes the new #3 but now everything needs moving down 1 number if that makes sense