I am trying to attempt to create a payroll spreadsheet with certain aspects and with multiple worksheets. so what im trying to accomplish is this
1/ on my main worksheet would have the payroll template there would be 2 columns (1) would be "routes" (2) would be the dollar value of that route.
2/ i want to be able to pick from a drop down list in colume (1) which will have various routes such as A,
B, C, D, E etc
3/ once i have selected a route in colum (1) i want to have the dollar value that is associated to that route to show up in column (2)
ex/ route A worth $1
route B worth $2
route C worth $3
so in column (1) i pick route "A" then in colum (2) it will show up as "$1" (dollar sign not needed)
- as for multiple worksheets, i will have my 1st worksheet as my payroll template and the 2nd worksheet will have my drivers names and routes and values of the routes which will be a master list of all my data
is there any way to do this, i have managed to create a dropdown list but thats about it, i have not been able to link any values together.
Bookmarks