Need Help with Data Capture Spreadsheet

[TheNagsHead]

I'm sure its possible but way above my level, good luck mate

Cheers James

This looks like it can be adapted to suit your requirements.

Atho55 thanks I will check it out this evening

Here's a possible sheet for you, had to add it as a RAR files as BA don't let you upload macro files. I've posted the code below as it's never wise to open macro enabled files from people you don't know.

Thanks spreadbetting for taking the time to write the code for me. I will check it out this evening.

[TheNagsHead]

I will have the code completed in next 1 -2 weeks and will post it in the forum. Its really basic but might help someone who isn't an advanced programmer, thanks again to the people who contributed to the thread.

[Zedzed1]

Is there someone that have this spreadshead from post 1. Im also searching something like that?

Thank you already?

[Atho55]

From memory =SUM(VLOOKUP(xx,xx,x,x)-VLOOKUP(xx,xx,xx,x) sort of thing

[jamesg46]

From memory =SUM(VLOOKUP(xx,xx,x,x)-VLOOKUP(xx,xx,xx,x) sort of thing

Thanks Atho