D
dizza
Greetings Forum memebers!
I'm new to this board, and thought I'd ask for some advice from the
knowledgable people here..
Here is what I am trying to do... I have a workbook with 3 sheets
(Sales, Schedule, Data). The idea is that an employee will input the
date, customer's name, phone #, and have a drop down with a list of
services to select. This would all be included on the Sales sheet. The
data for the drop down box is on the Data sheet, and right now only
includes the text of the service, no prices.
So here is question #1 - How would I make it so that when the employee
selects "Item #4" in the list, it will fill in that Cell with that Item
and then also input a price in the next column to the right? For
Example, Employee selects "Oil Change" from the drop down box. The cell
that has the drop down box now will change to say "Oil Change" and the
cell to the right will have $39.00 in there.
Question #2 - How could I have the date, customer's name, phone #, and
selected service, be populated on the "Schedule" sheet with the same
columns. So when we type in the info on the first sheet, it enters it
into the Schedule sheet as well. Two requirements for this... I need
the cells on the Schedule sheet to stay blank until the data is entered
on the Sales sheet.. and second, the Service type needs to be populated
from the item selected from the Drop down box on the Sales sheet.
Hopefully I haven't confused the heck out of you guys and gals with
that long paragraph. Any help you could provide would be greatly
appreciated.
David
I'm new to this board, and thought I'd ask for some advice from the
knowledgable people here..
Here is what I am trying to do... I have a workbook with 3 sheets
(Sales, Schedule, Data). The idea is that an employee will input the
date, customer's name, phone #, and have a drop down with a list of
services to select. This would all be included on the Sales sheet. The
data for the drop down box is on the Data sheet, and right now only
includes the text of the service, no prices.
So here is question #1 - How would I make it so that when the employee
selects "Item #4" in the list, it will fill in that Cell with that Item
and then also input a price in the next column to the right? For
Example, Employee selects "Oil Change" from the drop down box. The cell
that has the drop down box now will change to say "Oil Change" and the
cell to the right will have $39.00 in there.
Question #2 - How could I have the date, customer's name, phone #, and
selected service, be populated on the "Schedule" sheet with the same
columns. So when we type in the info on the first sheet, it enters it
into the Schedule sheet as well. Two requirements for this... I need
the cells on the Schedule sheet to stay blank until the data is entered
on the Sales sheet.. and second, the Service type needs to be populated
from the item selected from the Drop down box on the Sales sheet.
Hopefully I haven't confused the heck out of you guys and gals with
that long paragraph. Any help you could provide would be greatly
appreciated.
David