TomT
New Member
I'm working on a new workbook, and my original data set seems to be growing as I think of new ideas for what to include.
Originally, it was a dashboard for tracking active and closed jobs at work. Realizing that there were additional missing pieces in the day to day tracking of jobs, the data keeps expanding in scope.
My thinking is that each missing piece would be its own dashboard, with a corresponding data sheet. This could get to be cumbersome and potentially lead to mistakes, which will cost time and money.
For example, the original idea was to track which jobs I worked on each day. Then I realized that no one is tracking what resources are being used, so I need to include that data as well. There is also no way (other than sorting through a paper trail) to see at a glance which jobs I've worked on.
Each of those scenarios requires a unique set of data, all tied to together by a project code.
Is it 'normal' to have multiple data sets with one variable tying them together--project code--(for lookup functions), or to have just one set of data that sprawls across the sheet?
Originally, it was a dashboard for tracking active and closed jobs at work. Realizing that there were additional missing pieces in the day to day tracking of jobs, the data keeps expanding in scope.
My thinking is that each missing piece would be its own dashboard, with a corresponding data sheet. This could get to be cumbersome and potentially lead to mistakes, which will cost time and money.
For example, the original idea was to track which jobs I worked on each day. Then I realized that no one is tracking what resources are being used, so I need to include that data as well. There is also no way (other than sorting through a paper trail) to see at a glance which jobs I've worked on.
Each of those scenarios requires a unique set of data, all tied to together by a project code.
Is it 'normal' to have multiple data sets with one variable tying them together--project code--(for lookup functions), or to have just one set of data that sprawls across the sheet?