Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts
    G'day all...
    ok.. let me try to get this right..
    I created an .xls program (thanks to Hans)
    each sheet has a chart of company stockmarket codes, with all relevant details.
    Each day, (OR whenever i wish) I cut and paste my portfolio details into a preset chart and end up with up to 31 sheets.
    Alphabetical cells are constant, Numerical cells alter as I buy/sell companies.

    "Progressives" sheet chart, I want to automatically "LOOKUP" its relevant value from each sheet, and grow itself as sheets are added, including, (if possible) the "looked up sheet" title, which will be in date form..

    can this be done mate?
    cheers.. kio
    Attached Files Attached Files

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='kio' post='796409' date='05-Oct-2009 09:59']"Progressives" sheet chart, I want to automatically "LOOKUP" its relevant value from each sheet, and grow itself as sheets are added, including, (if possible) the "looked up sheet" title, which will be in date form..

    can this be done mate?
    cheers.. kio[/quote]
    No, not without VBA.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    A fully automated solution seems overkill to me.
    See the attached version. If you enter a date in the next available cell in column B on the Progressives sheet, and fill down the formulas in columns C:H from the last filled row, you'll get the results you want.

    Warning: columns C:H in the attached version may initially display #REF. This should be resolved if you recalculate the sheet; it's due to a language difference.
    Attached Files Attached Files

  4. #4
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hans:
    Thanks mate.. that will work fine.. and "yes" it was a bit of overkill eh!! *smiles*
    Webgenni:
    Thank you also.. still working out what all this stuff can do.. will have to work on what VBA even IS

  5. #5
    New Lounger
    Join Date
    Sep 2009
    Location
    Canada
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='kio' post='796507' date='05-Oct-2009 18:17']Hans:
    Thanks mate.. that will work fine.. and "yes" it was a bit of overkill eh!! *smiles*
    Webgenni:
    Thank you also.. still working out what all this stuff can do.. will have to work on what VBA even IS [/quote]

    Visual Basic for Applications.

    Depending on your age (yes, I'm dating myself-----age-wise that is)
    if you've had any interaction with Basic or GWBasic, you'll like VBA.
    It's a very powerful programming language (for some of us old fossils
    who still think in terms of
    IF somehting-something THEN
    GOTO
    ELSE
    do NOTGO
    ENDIF

Posting Permissions

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