As a disclaimer, I'm an amateur excel user.
I'm trying to create a spreadsheet that helps manage my printing jobs by doing the following:
Based on paper selection (c2), determines square feet (E2) (autofilled based on selection) as well as cost per sheet of paper (D2) (autofilled based on selection) .
Then based on DPI (dots per inch) selected (F2), determines amount (G2) and cost of ink used (H2).
When DPI (F2) is selected, Ink Use (G2) (total mL used) is autofilled in ((mL of ink used per square feet at the selected dpi (data lives on sheet2, b30:b32)) x (square feet of paper (E2) that was already determined)) and then cost of ink (H2) also autofills in ((cost of ink per mL used (data lives on sheet 2, (c30:c32)) x (total mL of ink used, G2)).
Finally, cost of ink (H2) + price per sheet of paper (D2) will be added together to give the total print job cost estimate (I2).
(Sorry if I'm using laymen's terms or being confusing.)
I'm attaching my spreadsheet and all of the data lives on sheet 2. I had to copy some lists onto sheet1 because the drop downs couldn't be created with lists from a different spreadsheet.
Basically, I'm trying to figure out how to make the above mentioned autofills happen.
Thanks so much!
Bookmarks