Need help autopopulating from master list

Closed
Report
Posts
1
Registration date
Sunday December 11, 2016
Status
Member
Last seen
December 11, 2016
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi dillon4477,

Sounds good, I'm missing the question though. Are you looking for the formula, then look in to VLOOKUP.

Best regards,
Trowa