I have been attempting to build a spreadsheet that will record bids and score them in excel. I am not great with excel. I have tried to do “ if” statements but there too many required to do so. Index and match work for a single bid but I don’t know how to extend that to the many bids that could be made.
I am trying to keep all the bid on the same line with some cells using “ drop downs” .however it is a large task and I am simply interested to see if there may be a better way. I do not know the slightest bit of VBA.
Can any one help with a suggested layout?
Cheers
Sorry I have tried and tried to upload, my screen goes light when I attempt to find the file and I can’t upload. ( on my iPad)
I am trying to keep all the bid on the same line with some cells using “ drop downs” .however it is a large task and I am simply interested to see if there may be a better way. I do not know the slightest bit of VBA.
Can any one help with a suggested layout?
Cheers
Sorry I have tried and tried to upload, my screen goes light when I attempt to find the file and I can’t upload. ( on my iPad)