+ Reply to Thread
Results 1 to 3 of 3

New to Excel,maybe its an easy question.

  1. #1
    Registered User
    Join Date
    01-21-2016
    Location
    Romania
    MS-Off Ver
    2013
    Posts
    1

    New to Excel,maybe its an easy question.

    Hello, I'm new here , kinda new to difficult things on excel so I have a question, I think its possible but I don't know how to do it.


    I'll take this example, I made standings at football on England Premier League, I have 2 different standings, one for Home,one for Away and I have the score from each match . For example:

    Home:
    Arsenal 3-0 3-1 1-1 2-1 and so on
    Chelsea 2-1 1-0 4-0 3-2 ...

    Away:
    Watford 1-1 1-2 3-2 1-2 ..


    I have 20 teams on home standing and same 20 on away, now in same sheet I have a table with Home vs Away and its incompleted,and here is the thing,lets see this time is Arsenal vs. Watford , is it possible when I write Arsenal on ticket I have below, excel can copy me all values from Arsenal(Home standing) and when I write Watford to copy me all scores from Watford away?


    I dont know how but something like when I write Arsenal copy B2:B10(all scores) dont know if I explained well,let me know if you dont understand something. Thanks.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,959

    Re: New to Excel,maybe its an easy question.

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,663

    Re: New to Excel,maybe its an easy question.

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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. [SOLVED] Easy Question for you Excel Gurus - If? Match? Lookup?
    By aware073 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-11-2015, 04:11 PM
  2. [SOLVED] Easy question about Objects in VBA for Excel
    By saurabhmangal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2014, 06:02 AM
  3. [SOLVED] organised data with multiple critera in the same column
    By yzbob in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-05-2013, 01:14 AM
  4. Easy Excel Question
    By czah7 in forum Excel General
    Replies: 3
    Last Post: 11-15-2011, 03:01 AM
  5. Total Excel Noob with what is probably very easy question
    By milkmoney11 in forum Excel General
    Replies: 2
    Last Post: 03-14-2009, 11:34 AM
  6. easy excel question
    By ness80 in forum Excel General
    Replies: 5
    Last Post: 01-22-2007, 02:05 PM
  7. Easy Excel VB question (I think!)
    By Just Kev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2006, 10:00 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