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

To advertise on these
forums, e-mail us.

Thread Tools Search this Thread Display Modes
Old 13th February 2009, 11:54 PM
Shaun Shaun is offline
Join Date: Jan 1970
Location: Western Australia
Posts: 5,336
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, 194 views)
File Type: xls Copy (2) of New Ratings.xls (227.5 KB, 177 views)
Reply With Quote
Old 15th February 2009, 02:33 PM
stugots stugots is offline
Join Date: Jan 1970
Posts: 1,131

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

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 06:29 AM.

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