Forum Discussion
kheffley
Aug 30, 2021Copper Contributor
adding columns to a linked worksheet to sort with worksheet
I have a master worksheet that I use to enter information. I have separate worksheets that contain columns that are linked to information from my master, and columns that are NOT linked to the maste...
Riny_van_Eekelen
Aug 30, 2021Platinum Contributor
kheffley Consider NOT having separate worksheets. Excel has great capabilities to filter and summarise raw data in many ways, using built-in functions. Easiest when all data is in one data set.
- kheffleyAug 30, 2021Copper ContributorHow do I do that?
- Riny_van_EekelenAug 30, 2021Platinum Contributor
kheffley Can't really answer without seeing the data you are dealing with.
- kheffleyAug 30, 2021Copper Contributor
See attached workbook with worksheets I am working with. I am an amateur when it comes to excel so try not to be too hard on criticizing my creation:)