Create master worksheet from other worksheets, auto-update any changes in the worksheets
Our take
I am working to create an inventory of all my lego sets and minifigures. Currently I have a worksheet for Marvel sets, one for Star Wars, and another for minifigures. I want to combine those 3 worksheets into one sheet. First question: how do I combine all the information in the worksheets into master worksheet. Second question: is there a way to ensure that if I change information on the "mastersheet", it will update on the subsequent worksheets? For example, if I have I update information on the master sheet on a marvel set, it will change the information in the marvel worksheet and vice versa. If it is possible how do I go about creating this? TIA for all help and recommendations.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience