Results 1 to 2 of 2
  1. #1
    Race-winners is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2015

    Some Advice

    1 2 3 4 5 6 7 8 9 10 11 12
    A 0.038 0.011 0.002 0.08 0.033 0.002 0.002 0.035 0.7 0.05 0.033 0.008
    B 0.342 0.474 0.103 0.1 0.343 0.103 0.103 0.51 0.56 0.1 0.343 0.05
    C 4.21 0.02 0.99 1 5.1 0.99 0.99 0.96 1.1 1.1 1.1 1.1
    I have this from 1 to 1550 so L6 is just a ref cell when I click a button it looks up the row number and displays the column a1.b1.c1.d1.e1 and displays the respective results.
    Now I have done this using a shortcut cntrl M to go up and cntrl N to go down.
    The problem is I have five other cells which vary the results of lets say A1 to E1
    rtw 1
    going 2
    variance 2
    ado 1
    so by adjusting RTW from 1 to 2 the cells at A1 coloured red will change to lets say from .038 to .022
    so I go through 1500 results then change cell RTW to 2 and have to start again from 1 to 1500; as RTW goes up to eight that makes 12000 clicks or cntrl n till it get to 1500 then change RTW to 2 then cntrl m back to 1 if you see what I mean.
    In real terms as the other cells go up to 5 that's just over 1 million results I started at 12:45 and have just finished one sheet, so that is 5 hours lol
    Theoretically I can do it with just 5 cells and make cell A1 start at .001 have cells b c d e at zero and when A1 reaches 10 then b1 becomes .001 it reaches 10 again and cell b1 becomes .0002 etc but that's still 10,000 just to make cells a1 and b1 reach 10 in divisions of .001 again that way is 10 million variances.
    There must be a way?

    Anybody fancy giving me a quick tutorial on how to start!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    You have 1550 columns? This is Excel spreadsheet? Why are you posting in an Access forum?

    I haven't yet seen anything that can't be accomplished with VBA.

    However, I don't really understand what you are doing. Very little of what you described makes sense to me. How does L6 reference translate to "displays the column a1.b1.c1.d1.e1 and displays the respective results"? If adjusting rtw should change A1, what exactly are you doing manually? What are you 'going through'? Are you manually typing .022 to replace .038?

    I don't know what ctrl+m and ctrl+n should do. When I use ctrl+n in Excel, it opens another blank workbook. Ctrl+m does nothing as far as I can see.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. New-and need help as well as advice
    By bjd1020 in forum Access
    Replies: 8
    Last Post: 11-16-2012, 02:25 PM
  2. Need some advice and help
    By winterh in forum Access
    Replies: 9
    Last Post: 04-18-2012, 06:41 AM
  3. IIF Statement Advice
    By BinHDreW in forum Access
    Replies: 8
    Last Post: 08-31-2011, 06:02 PM
  4. Need Report Advice
    By Kevo in forum Reports
    Replies: 1
    Last Post: 08-04-2011, 09:22 PM
  5. Need advice on what I have so far
    By rumplestiltskin in forum Database Design
    Replies: 2
    Last Post: 05-25-2006, 12:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums