Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 13th February 2009, 11:54 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,317
Default Excel Help Needed

Hi All

I am haveing problems with one of my excel sheets, i wrote a new excel sheet for ratings i am using, i have always imported my data the same way using.

When i wish to rate a new race and i have copied the infor to a text document i update the query and it adds the new data over the old no problems.

I wanted to update and test some older ratings i had but when i do the web query it seams not to replace the old data correctly and moves my references around.

This is kinds hard to explaim with out showing you but i will put up 2 sheets the first would be the correct format the second is what happens after i update the query.

If you look at the sheet you will see that all the information needed is taken from the "Field" and "Form" form sections.

The field is a manual copy and paste so no problems there but the form is the inported data, and as you can see in the second copy it has moved the references for some unknown reason.

I have another sheet i use that does not suffer from this problem so help in working this out would be great.
Attached Files
File Type: xls Copy of New Ratings.xls (224.0 KB, 189 views)
File Type: xls Copy (2) of New Ratings.xls (227.5 KB, 172 views)
Reply With Quote
  #2  
Old 15th February 2009, 02:33 PM
stugots stugots is offline
Banned
 
Join Date: Jan 1970
Posts: 1,131
Default

strange Shaun, has shifted the affected references by 55 rows - B269 to B313 - which is the equivalent of 5 form entries - but why, i have no idea
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:43 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655