C
Calsonic
Let me try and explain what Im trying to do.
I have a spreadsheet for ordering parts for photocopiers.
Then I have individual worksheets with the parts for each model copier.
What I want to be able to do is on the main sheet, set it up in the
following way.
Cell 1 is the part number
Cell 2 is the part description.
cell 3 and 4 are for quantity and one other figure.
I want to make cell 5 a drop list to choose what model copier i want the
part for, and when that is chosen, cell 2 becomes a dropdown list, listing
all the parts on that model copier from the appropriate worksheet.
Then when I select the part I want, the part number is added to cell 1
automatically.
I can make this spreadsheet work if I just had one model copier on another
worksheet, but how can I use multiple worksheets for different models?
TIA
Geoff...
I have a spreadsheet for ordering parts for photocopiers.
Then I have individual worksheets with the parts for each model copier.
What I want to be able to do is on the main sheet, set it up in the
following way.
Cell 1 is the part number
Cell 2 is the part description.
cell 3 and 4 are for quantity and one other figure.
I want to make cell 5 a drop list to choose what model copier i want the
part for, and when that is chosen, cell 2 becomes a dropdown list, listing
all the parts on that model copier from the appropriate worksheet.
Then when I select the part I want, the part number is added to cell 1
automatically.
I can make this spreadsheet work if I just had one model copier on another
worksheet, but how can I use multiple worksheets for different models?
TIA
Geoff...