Master excel should pass data to child excel by itself

Occasional Visitor

Hi, i am newbie to excel and i need some experienced advice here.

i have master excel which have all the data , now based on this i want with the help of reference column to put few columns details in child excel by itself.

any suggestions?

1 Reply
Have a look at Data, Get Data, From File, From workbook. That allows you to pull in the data from any workbook into your current workbook (the pulled in table can be refreshed so it is up to date, for example when your file is opened). After that, you can use functions like XLOOKUP to get the data belonging to a certain item.