Is it possible to have excel automatically put rows of data below specific cells?

[iuseexcelatwork]

I have to keep an excel sheet updated with work related data. For example I have to type a code, lets say 123, into the cell 1B. If I type that code into 1B, then the cells below the code have to always have an orange background and certain numbers in them. Can I somehow automate this? Just like in the example below, whenever I type 123 I want the cells beneath 123 to look as in the example. There are hundreds of similar code batches. I type 3421 and beneath 3421 will always be certain batch of codes. Is that possible? I apologize if my explanation is in un-adequate.

	123
	2222	m
	3333	n
	4444	t
	1111	b

<tbody>
</tbody>

 

[bobsan42]

Yes it is.
But much more information will be needed.

 

[hiker95]

There are hundreds of similar code batches. I type 3421 and beneath 3421 will always be certain batch of codes.

iuseexcelatwork,

Welcome to the MrExcel forum.

Can we have another screenshot of what the results for 3421 should look like?

 

[iuseexcelatwork]

iuseexcelatwork,

Welcome to the MrExcel forum.

Can we have another screenshot of what the results for 3421 should look like?

It should look something like this. If you could teach me how to do it, that would be great.

 

[hiker95]

iuseexcelatwork,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get an answer.

I would prefer to have a screenshot of the raw data, and, a screenshot of what the results should look like (manually formatted my you).


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you are not able to provide the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[iuseexcelatwork]

iuseexcelatwork,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get an answer.

I would prefer to have a screenshot of the raw data, and, a screenshot of what the results should look like (manually formatted my you).


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you are not able to provide the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

I was asked to provide a screenshot, isn't that a screen shot? It is a screenshot.

Anyway, which numbers are used is irrelevant. I'd like to know the principle.

Whenever I type 123 in the b column on any row of my choosing :

Like this:

123

<tbody>
</tbody>

I want it to insert rows 2-4 automatically because they will always be the same whenever I have to type 123. Like in the example below:

	123
1	34535	i	454
2	64554	u	343
3	45645	h	345
4	34535	j	345

<tbody>
</tbody>

 

[bobsan42]

Well, If we're talking about principles - something for starters:
- I would keep column B only for the 123 etc. that you want to enter as code - meaning I would keep the orange sub-lines contents to the right of column B
- All codes with related sub-data should be entered somewhere where Excel can reach them - e.g. in another sheet
- For the sheet on which codes will be entered:
Under some conditions and if you're careful you could go with some tricky formatting and formula w/o VBA
With VBA:
Use Worksheet_Change event to activate when you change a cell; Check if the cell is in column B; Check if Code entered is Valid or existing;Transfer subdata from other sheet;

 

[hiker95]

I want it to insert rows 2-4 automatically because they will always be the same whenever I have to type 123. Like in the example below:

iuseexcelatwork,

Excel 2007
	B	C	D
1	123
2	2222	m
3	3333	n
4	4444	t
5	1111	b
6
7
8
9	123
10	34535	i	454
11	64554	u	343
12	45645	h	345
13	34535	j	345
14
Sheet1

Per your examples, if you type into cell B1, 123, you will get one set of results?????

Per your examples, if you type into cell B9, 123, you will get a different set of results?????


I do not have a clue how to solve your request.


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[iuseexcelatwork]

iuseexcelatwork,


Excel 2007

	B	C	D
1	123
2	2222	m
3	3333	n
4	4444	t
5	1111	b
6
7
8
9	123
10	34535	i	454
11	64554	u	343
12	45645	h	345
13	34535	j	345
14

<tbody>
</tbody>

Sheet1​

Per your examples, if you type into cell B1, 123, you will get one set of results?????

Per your examples, if you type into cell B9, 123, you will get a different set of results?????


I do not have a clue how to solve your request.


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

The code (123) always goes into a cell in the B column, and one code has always one set of data paired with it. For example 123 will always be paired with the same data set. Another code(for example 456) will be paired with another data set. So each code will represent a data set. How about we use words for data sets? To make things clearer.

A

B

C

D

1

123

2

watermelon

a

4pcs

3

chicken

b

5pcs

4

orange

c

6pcs

<tbody>
</tbody>

The goal is to type or paste 123 in a cell in the B column and have watermelon, chicken, orange appear below it, as seen in the example above.

A

B

C

D

1

456

2

cucumber

c

1pcs

3

potato

b

2pcs

4

meme

a

3pcs

<tbody>
</tbody>

For another number, for example 456, the data set would be cucumber, potato, meme. So 123 will always be watermelon, chicken, orange. 456 will always be cucumber, potato, meme. Is it somehow possible for it to autofill the data for me in columns B,C,D if I just type 123 in 1B .

 

[bobsan42]

Yes - read my post above hiker95