+ Reply to Thread
Results 1 to 2 of 2

Auto-populate from one sheet to another

  1. #1
    Registered User
    Join Date
    Manassas Virginia
    MS-Off Ver
    Excel, Word Power Point

    Auto-populate from one sheet to another


    I'd like to start by apologizing if I don't explain myself correctly as this is my first time seeking help on a forum, and if I am not using the correct terms to Excel formulas and so on.

    I am making a spreadsheet for my church of things that we have set to get done and what we would like to get done as far as remodeling, stage designing, sound equipment, etc. I have a spreadsheet done of all things needed as shown below as Columns.
    | Product Name | Part # | Manufacturer | Uses | Quantity | Price |
    Speaker 625 Yamaha stage 2 $100
    Cone 12 Liona stage $20

    I want to make a separate list on a different TAB(Sheet) that from all the data or numbers added to the quantities list, to automatically add only as quantity is being added to that Row

    | Product Name | Part# | Manufacturer | Quantity |
    Speaker 625 Yamaha 2

    I have tried creating a Table of each category and creating a Pivot Table on new tab but have not been able to really get what I want from it. I don't know how to really handle that yet as I am still training on Pivots but I'd like some tips and tricks or a different way of getting this done. Is there an easier way? Please Help Me.
    Thanks in advance for your time
    Last edited by kmelgar13; 11-07-2018 at 10:27 AM. Reason: was not finished with question/request

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Hello kmelgar13,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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