+ Reply to Thread
Results 1 to 2 of 2

Adding to a List in Another Workbook?

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Smile Adding to a List in Another Workbook?

    Hello all. I am new to VB and am wondering how to do this.

    I have one workbook (Quote) to create a customer quote when a sale occurs and additional workbook (Booking) for a list of all of the booked orders.

    I am wondering if there is a way to create a button that when clicked automatically adds the order number and quantity into the booking list in the other excel sheet.

    Here is an example of what I want to pull from the quote sheet:

    quote_example.PNG


    And here is an example of the booking list:

    book_example.PNG


    I want the information from the quote sheet to automatically update the booking list when the button is clicked. I have no idea what I am doing...any help is greatly appreciated!
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Adding to a List in Another Workbook?

    Select the developer tab

    Select Record Macro

    Select the text you want to copy
    Select the area you want to paste it to
    Paste your data
    Select the Data you copied

    Stop the Macro recorder.

    There you are. You have the Basis of a Macro.


    I cannot post any code for some reason so I an attaching a couple of files for you to look at
    Attached Files Attached Files
    Last edited by mehmetcik; 08-03-2018 at 01:25 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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] Adding info to a list already created and using autofill within the list
    By excel is cool in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-04-2016, 03:53 PM
  2. Replies: 2
    Last Post: 08-11-2015, 01:24 PM
  3. Macro to filter rows of one workbook based on list of values in another workbook.
    By jarrodprice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2015, 02:55 PM
  4. [SOLVED] Taking new data from one list and adding it to another list via VBA
    By Michael D in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-11-2014, 06:47 PM
  5. Adding and Deleting to a list in a workbook other than the active workbook.
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 11:00 AM
  6. Replies: 2
    Last Post: 02-22-2013, 07:16 AM
  7. How do I copy data from one workbook to create drop down lists in another workbook
    By mikeuk24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2013, 05:08 PM

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