Now I am stuck. I am trying to transfer the bookie openers , top fluc and SP to my results file.
I have copied from Top Sport and pasted into excel.
I can split the figures into different columns but cannot carry the font colours across.
Green font 4.6, red font 4.6, 4.4


I can carry the green only or have all black but not green, red and black. Next problem will be getting these into their appropriate columns ie Openers, Top Fluc and SP.
I am hoping that somebody has been there , done that and has a solution.
Thanks in advance
Beton

Just run a formatting macro after you have done the transfer.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Some of he bookies sites suck badly when it comes to getting the prices where you want them, i have a sheet around here that imported from 6 different sites, was used when we tried to back lower priced lays on betfair, Mark can tell you how well that worked when the bookies got wind of it.

The sheet should have all the formulas and macros needed, just need to find it.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Thanks Shaun, Beton & myself would be grateful if you can find it.

Cheers.
Garyf.

Sure will take a look, in the process of moving so the main pc is down but should be on my backup drive.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Shaun
Thanks
Where are you moving to? You sure picked some good weather. I just lost my back fence.
Beton

Clarkson area

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

What part of Perth are u?

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Munster.
Really blew down here last night. Lost power briefly. lost the back fence but that's life. and what insurance is for.