+ Reply to Thread
Results 1 to 1 of 1

Auto populating of formula with result based on input data and party name

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,248

    Auto populating of formula with result based on input data and party name

    Dear All Forum Contributors,

    Let me explain ,what I want to achieve.I have more than 5 parties here stated only sample parties there might be more than 100 parties.Each party has 3 sheets namely M1,I1 & O1.Now what I want is that,

    1.All sheets should be hidden
    2.There should be only two sheet unhidden.First sheet name should be Input Field based on dropdown/Data validation used of party and second would be output sheet where result are being displayed of party based on Input filed.
    3.In order to display the result,I have for your kind info I have made the formula in subsequent sheet O5,O4,O3,O2,O1 sheets based on the input data of I5,I4,I3,I2,I1 and Master sheet M5,M4,M3,M2,M1 where everything is defined of respective party.

    Like this if my parties are more than 100 is goes a long way in finding the sheet input data and output data with master sheet defined all the terms & condition.Hence I thought if there could be only two sheet where data is fed into 'input' sheet and based on the data result is being displayed in 'output' sheet with terms & condition defined in master sheet-M5,M4,M3,M2,M1 of each party and formula is defined in output sheet of each party in O5,O4,O3,O2,O1.

    It means auto populating of formula & results of each party in output sheet based on party name in input data.
    I have checked all the formulas,everything is correct.

    I would be very much thankful if I am get helped.You can use any method as you desire.

    I will be eagerly waiting for your reply.

    With Best Rgds,
    Suresh

    Encl. Dummy file
    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. [SOLVED] Need Help with Formula for Eligibility Result Form based on 2 input Variables
    By jlepp06 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 08:08 AM
  2. Auto-populating COMMENTS based upon results of a formula
    By CQHixi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2012, 01:20 PM
  3. Auto-Lookup Value based on formula result (VLOOKUP?)
    By alexrawnsley in forum Excel General
    Replies: 2
    Last Post: 06-04-2012, 03:07 AM
  4. Auto populating data based on previous business day
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2012, 05:08 PM
  5. Auto populating field determined by previously input details
    By Newton1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2010, 04:26 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