Aug 30 2021 08:53 AM
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 master.
When I sort the MASTER, any worksheet containing the linked columns sort properly, however causing the information in the unlinked columns to become out of sort and incorrect.
How can I fix this so the information in the unlinked columns stay with the linked columns once sorted?
Aug 30 2021 09:09 AM
@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.
Aug 30 2021 11:48 AM
Aug 30 2021 11:50 AM
@kheffley Can't really answer without seeing the data you are dealing with.
Aug 30 2021 01:06 PM
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:)
Aug 30 2021 09:35 PM
@kheffley See attached workbook. I have inserted a sheet called "Raw Data" that holds all information you are collecting. No fancy formatting, no empty rows and rather than working with colors, add a separate column for the status that you are indicating with them. I would also put the notes is a separate column, NOT attach them to a cell like you have done (changed that for a few, but not all). The idea is that all information is visible, accessible in one single structured table. From there, you can sort the data, create summaries and reports. It depends a bit on your Excel version, though, and how comfortable you are with e.g. Pivot Tables.
Aug 31 2021 10:21 AM
Aug 31 2021 11:51 AM
Jul 11 2022 09:18 AM