+ Reply to Thread
Results 1 to 1 of 1

VBA Output based on what's typed into Cell.

  1. #1
    Registered User
    Join Date
    06-13-2008
    Posts
    5

    VBA Output based on what's typed into Cell.

    Hey guys-
    This is a strange one, so I've attatched the spreadsheet to this thread.
    Basically, it selects horses for races based on other tipsters choices.
    First of all, I go to a website (http://www.gg.com/tips) to get their choice and times of the race for one paticular meeting. I then paste this as text into the "Insert Page" to add the race times and their choice of horse. I input all the tipsters selections, by dignifying their horse name with a 1.
    It all works it out, and puts the horse selections into 1st Selections, ready for copying and pasting into a website.
    The Sheet 2nd Selections just uses another method of selecting the horses.
    It bases the results on the figures in the 'Results' Sheet, which shows how well each tipster has done.

    Right- Ideally, what I would like to do is on the first page (enter), once the results come in, I would like to type in a 'W' or a 'L' in the I Column next to the horses whether they have won or lost. It would then scan along the row, and where there was a 1, it would find which tipster had done it, then input this into the results sheet. If it was a W, it would add one onto the Wins, and if it was a L, it would add one onto the Losses.

    Cheers,
    Sam
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. conditional cell based on actions of another cell
    By florischu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2008, 07:29 PM
  2. Update Screen Location based on cell address
    By ItsMillerTime in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2008, 02:29 AM
  3. Re-running code based off the updating of a cell
    By Rivalwon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2007, 01:21 PM
  4. Is it possible to return a value based on cell format?
    By blaidan in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-12-2007, 11:16 AM
  5. Refence another workbook based on value in a cell
    By tonywig in forum Excel General
    Replies: 4
    Last Post: 05-10-2007, 09:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1