Recording data, but not beginning in cell A1?

[London_Calling]

as the title, really.

I would like to record football data (example: unders and overs, 0-0 and 1-0 and 0-1) on the same worksheet, side-by-side rather than on separate workbooks.

I'd imagine it's dead simple or near impossibe - any suggestions very gratefully received !

cheers.

[Captain Sensible]

you could try sticking them on separate sheets then stick the bits you want all on one sheet using references like =+Sheet1!O8 =+Sheet5!A2 etc

[a1ehouse]

Can't you just change the top Left Hand Cell value when you select Excel>Log Current Prices? Otherwise CS's suggestion is the only way.

[London_Calling]

After rooting around for a while, I did find a solution . . . if anyone is interested:

You can create links from one workbook to another, inserting whatever range you want from the source workbook into the dependent workbook - the phrase that gets you there is 'creating external reference formulas' (sounds grand, it's actually copying and pasting in a particular fashion).

Anyway, it's operating as I wanted, as we speak, so bob-a-job.


Cheers for your tips and help, lads.