1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Create master worksheet from other worksheets, auto-update any changes in the worksheets

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.

submitted by /u/buffunderfluff
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#master worksheet
#worksheets
#lego sets
#update
#master sheet
#inventory
#minifigures
#auto-update
#combine
#Marvel sets
#Star Wars
#Excel
#information
#change