Forum Discussion

Copper Contributor

Jan 10, 2020

is it possible to create a cross-sheet in Excel workbook?

Hello! I will try to explain what I need and maybe you could help me with which functionality of Excel is better to use. I need to have a single list of products on one sheet in a workbook (the lis...

excel

Prologys

Copper Contributor

Jan 10, 2020

olga_x

Hi Olga, this sounds like a good PowerPivot solution.

Here you can use the update button to refresh all data.

You can even keep out all the data from the file if it becomes to big.

There are a lot of samples available on YouTube on this topic.

Regards,

Jaap