Forum Discussion

olga_x's avatar
olga_x
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 list will be adjusted from time to time, some product lines will be added or deleted)

Other sheets contain planned/sales data per each sales manager per product list on the 1st sheet and per months.

So I want to see the list of products on the 1st sheet as frozen cross-sheet area and by tapping bookmarks/sheets, view data per each manager in corresponding product lines. 

I mean in my view the 1st sheet in a workbook acts as frozen cross-sheet with defined size and other sheets can be viewed one by one together with the list of products on the 1st sheet.

So if I adjust the list of products on the 1st cross-sheet (add or delete lines), it automatically adds/deletes lines with data on other sheets, so no data will be lost or mixed.

Maybe it's possible to reach this purpose by formatting a single sheet, I don't know. Please advise.  File example is attached. The fact is that we have many such files per sales areas and it's time consuming to adjust/check every sheet in case of some changes in product list. 

2 Replies

  • Prologys's avatar
    Prologys
    Copper Contributor

    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

Resources