+ Reply to Thread
Results 1 to 1 of 1

Autofill table in Sheet A with conditional entries in Sheet B-Z

  1. #1
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Autofill table in Sheet A with conditional entries in Sheet B-Z

    Hello all

    I have attached a file to demonstrate what I want to do.
    When I get a request to get a quote for a particular product combination, I would create a new sheet, name it Quote - 1, and fill in the relevant information.
    When I am able to get a quote $ amount, such as in Sheet "Quote - 1" Rows 10-15, I enter the dollar amount into cells R10:R49.

    What I would love to have happen is for the "Master" sheet to autofill with these quotes as soon as a $ amount is put in for each entry in each sheet (or possibly when a Yes is put in cells AF10:AF49).
    Is this possible? I think I could do this myself if everything was in one sheet, but this scenario requires drawing the info from multiple sheets, including sheets that haven't even been created yet, and I require some assistance.

    In order to limit the size of this file, at the end of each month I will be removing the individual Quote Sheets. I would simply copy and paste the values of the Master sheet at that point, and let the new entries simply add on to the existing Master sheet. I would also delete the Quotes from the master sheet every 3 - 6 months, either manually or automatically if I figure out how to make that possible.

    I am not familiar with any Macro programming, but if that is the best way to go about this, and someone knows a link to a helpful article for my purposes, I'm okay with attempting to learn some basics.
    Please let me know if additional clarrification is desired.
    Thanks in advance!
    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)

Tags for this Thread

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