Need help autopopulating from master list
Closed
dillon4477
Posts
1
Registration date
Sunday December 11, 2016
Status
Member
Last seen
December 11, 2016
-
Dec 11, 2016 at 10:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2016 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2016 at 11:24 AM
Hello,
I am building a budget and inventory tracking system for a landscape company. I have data that I import from a field service tracking software. I import as a csv file then copy the following columns: "Worker", "Location" and "Actual Time" at the job site and paste into the weekly sheet. I want to add a column named "Budgeted Time" next to "Actual Time" so I can quickly calculate if they spent to much time at the job.
My thought was to have a MASTER tab and list all the Locations in one column and all the respective Budgeted Times in another column, then have the Master feed or auto populate the budgeted time into the weekly sheets based on the corresponding column (i.e. Location) on the Master List.
Thank you so much for you help.
SD
I am building a budget and inventory tracking system for a landscape company. I have data that I import from a field service tracking software. I import as a csv file then copy the following columns: "Worker", "Location" and "Actual Time" at the job site and paste into the weekly sheet. I want to add a column named "Budgeted Time" next to "Actual Time" so I can quickly calculate if they spent to much time at the job.
My thought was to have a MASTER tab and list all the Locations in one column and all the respective Budgeted Times in another column, then have the Master feed or auto populate the budgeted time into the weekly sheets based on the corresponding column (i.e. Location) on the Master List.
Thank you so much for you help.
SD
Related:
- Need help autopopulating from master list
- Master royale - Download - Strategy
- Yu-gi-oh master duel download pc without steam - Download - Strategy
- Typing master 11 mod apk - Download - Education
- Counter strike 1.6 cheats list - Guide
- Samsung master reset code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 19, 2016 at 11:24 AM
Dec 19, 2016 at 11:24 AM
Hi dillon4477,
Sounds good, I'm missing the question though. Are you looking for the formula, then look in to VLOOKUP.
Best regards,
Trowa
Sounds good, I'm missing the question though. Are you looking for the formula, then look in to VLOOKUP.
Best regards,
Trowa