Hi there Everyone...
Another one has me baffled
I have a list of items which each have a description, date, a score and a price attached.
This list is stored on a seperate spreadsheet at the moment, which is being updated all the time.
for Example...
item "300" could be available on 01/01/05 or 01/09/05. Its
Both dates would result in a score of 15 and its title would stay the same.
However, the prices would change. The item on the 01/01/05 would cost say £300 but the item on the 01/09/05 would cost £500.
I need to be able to tie up the information from one spreadsheet to another...
I want to input the item number on the spreadsheet and the information relating to the title and score would come up automatically. I would then like it to give me an option from the dates available and then automatically work out the cost...
At the moment i have about 400 items...(ARRGHHH)
Thanks for your help
Another one has me baffled
I have a list of items which each have a description, date, a score and a price attached.
This list is stored on a seperate spreadsheet at the moment, which is being updated all the time.
for Example...
item "300" could be available on 01/01/05 or 01/09/05. Its
Both dates would result in a score of 15 and its title would stay the same.
However, the prices would change. The item on the 01/01/05 would cost say £300 but the item on the 01/09/05 would cost £500.
I need to be able to tie up the information from one spreadsheet to another...
I want to input the item number on the spreadsheet and the information relating to the title and score would come up automatically. I would then like it to give me an option from the dates available and then automatically work out the cost...
At the moment i have about 400 items...(ARRGHHH)
Thanks for your help