Excel - Data Capture, Help Required

[thewald]

Hi

Firstly, I hope you all have a very prosperous 2015.

If anybody has a couple of minutes to spare I would appreciate some help with the following excel issue.

I have en excel sheet which I have linked thru guardian to three betfair markets - Match Odds, 2.5 & Correct Score.

I manually link all games one by one. I would like certain data from each game to be captured and kept without me having to manually copy and paste info.

The attached sheet is an example of what I wish to do. Data is automatically entered into row A (at present i then copy and past it into a lower row) is there a way that excel will automatically copy my data into a lower row and then do the same when the data in the top row changes?

I have noticed something similar in the record data spreadsheet, the data automatically moves down a row when new data arrives.

I think this may be a macro or VBA issue, which is beyond my excel knowledge.

Any help greatly appreciated.

And again, hope you all have a happy and prosperous 2015

Nick

[thewald]

In hindsight, posting on New Years Eve probably wasn't the best time.

Anybody?

[nigelk]

Couple of questions. Have the sheets always got the same name and is the information you need capturing always the same cells?

Cheers,Nigel.

[thewald]

Hi Nigel

Thanks for getting back to me.

Yes, the sheets are always named the same and it is the same data from the same cells i wish to 'collect' every time

Thanks

[beech19721]

Hi Nick,

Did you find a solution to this, as it was something i wanted to do too?

Many Thanks

Graham