link 2 tables

[TomasMe]

Good morning everyone,

I'm making my internship in a company, and have a lot of work with excel. I'm ''beginner'' so struggling some times.
What I need to do is :

	A	B	C
1	Company	Group	Quantity
2	ABC	2	30
3	DEF	1	20
4	GHI	2	25

This is the main table, where you enter all the values (company name, group of consumption, and quantity of consumption).

	E	F
1	(Group) 1	(Group) 2
2	20	30
3		25

This is how the second table should look like. If I enter infos in the first table, I need that it appears automatically in the second one.

Sorry for my English, hopefully I was clear. Thank you for your help !

[NeedForExcel]

You can give Pivot Tables a try.. It wont get you the data exactly in the same format but something similar.

Or try out the Excel attached.

[Pepe Le Mokko]

Hi and welcome
please read the yellow banner.
Thanks

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I shall do it for you this time.)

https://www.mrexcel.com/board/thread...ables.1117992/