+ Reply to Thread
Results 1 to 2 of 2

how to show up 2 values generating a cell

  1. #1
    Registered User
    Join Date
    09-09-2010
    Location
    Ancona, Italy
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cool how to show up 2 values generating a cell

    Hi there!

    I'm going to explain what I need to show up.

    In my worksheet there are a row for duration (months) and a coloumn for taxes that generate a value.

    If I click on this value, I'd like the respective tax percentage and months would appear on another worksheet.

    -- A2 A3 A4 (months)

    B1 B2 B3 B4

    C1 C2 C3 C4

    (%)

    By clicking on C4 it should show up what written on A4 (months) and in C1 (%)


    Thanks in advance

    Catia

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: how to show up 2 values generating a cell

    You'd need VBA for this, are you ok with that?

    If so:
    What are the names of the sheets?
    What is the range that you might click in?
    How do you want the data to appear on your other sheet? for example, a list which builds up every time you click a different cell, or just two cells which are rewritten every time you click a different cell on your first sheet?
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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