Forum Discussion
maso1687
Jan 30, 2023Copper Contributor
Pull data from separate sheet, then stop updating once pulled.
I have to track manpower for my job and we are trying to build a spreadsheet to track day by day changes. The below is a very simplified version of what I use. The yellow cells calculate the number o...
maso1687
Jan 30, 2023Copper Contributor
I am always open to suggestions! Unfortunately this is the info I have to work with, and I can't even imagine what it would take to pull information/documentation together from other departments. To be clear, I am not in an HR role, but I do track labor for my region. The spreadsheet I am attaching is an extremely simplified version of what I use. I am actually tracking labor across about 40 sites with roughly 800 employees.
https://docs.google.com/spreadsheets/d/1dD8Nj8_I-jrYOG_hK8mFylP0F2PNunaX/edit?usp=share_link&ouid=100692498345959033872&rtpof=true&sd=true
https://docs.google.com/spreadsheets/d/1dD8Nj8_I-jrYOG_hK8mFylP0F2PNunaX/edit?usp=share_link&ouid=100692498345959033872&rtpof=true&sd=true
mathetes
Jan 30, 2023Gold Contributor
See if the attached makes any sense. I've automated a good deal of it, but since I don't know exactly what form your "raw data" comes in, the changes I've made may not work as smoothly as possible. There are a few comments in the spreadsheet, but feel free to come back with any questions.
- maso1687Jan 30, 2023Copper ContributorThank you! I appreciate the help!