Extrapolating information from one table to another

[Tloso]

Hello Everyone,

I am new to this so apologies for any bad form in Forum etiquette.

I currently have a master table on one sheet and I am looking to create a couple of other tables on separate sheets. I am looking to link the tables so that the new one can extrapolate some of the existing data from the master table. I am currently using vlookup but is there a more efficient method? I would love it if there is a way where the new tables can add rows to accommodate new entries and information in the master table automatically.

Thanks for your time and help I greatly appreciate it.

Ciao,
T

 

[DILIPandey]

Hi T,

You can create multiple pivot tables based on your master table, suggest you to search internet for pivot table and you will learn it quickly in case you don't know. Thanks.



Regards,
DILIPandey