+ Reply to Thread
Results 1 to 3 of 3

Autopopulate a cell on one sheet, based on a calculation on another sheet

  1. #1
    jjward101
    Guest

    Autopopulate a cell on one sheet, based on a calculation on another sheet

    I have created an excel sheet to simplify pricing for my customers while offering them a visual experience showing them the pricing options, and savings by being a "plan member".
    The difficulty I have, which is stopping me from progressing is this:

    In the attached workbooks, I have the following sheets:
    Labor Calculator
    Set-Up
    Flat-Rate Book

    I am trying to populate the materials markup column in the flat rate book worksheet, based on a chart in the set-up sheet. "If the price is between X and Y on this sheet, then the multiplier will be Z on the other sheet.

    I have searched high and low on google for how to accomplish this, with absolutely no luck. I know it Can be done, because I have seen it in other spreadsheets over the years and was not smart enough to save one for later (later being now) since I didn't think i'd ever need it.

    Can anyone possibly provide me some guidance? The workbook is attached.

    (The labor calculator sheet works perfectly and as intended)
    Attached Files Attached Files

  2. #2
    jjward101
    Guest

    Re: Autopopulate a cell on one sheet, based on a calculation on another sheet

    wow. I am a little shocked no one has replied. I will keep looking elsewhere. Thanks

  3. #3
    jjward101
    Guest

    Re: Autopopulate a cell on one sheet, based on a calculation on another sheet

    Got great help on this over on Mr. Thanks!

+ 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. Autopopulate items from one sheet to another based off list selection.
    By creed84 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2015, 02:17 AM
  2. Autopopulate one sheet from data of other sheet based on a criteria
    By Gaillee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2014, 09:21 AM
  3. [SOLVED] Commission Sheet - Autopopulate based on Date from Data Sheet
    By noobasaurus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2014, 01:08 PM
  4. [SOLVED] VBA to Auto Populate the “AutoPopulate” sheet as data is being entered in EnterData sheet
    By bjnockle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-13-2014, 09:10 AM
  5. Show data based on selected parameters
    By pphg in forum Excel General
    Replies: 4
    Last Post: 02-11-2013, 12:22 PM
  6. Replies: 5
    Last Post: 01-06-2011, 09:29 AM
  7. [SOLVED] Hide/unhide sheet macro based on cell calculation
    By Greg Fisher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2005, 05:19 PM

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