+ Reply to Thread
Results 1 to 2 of 2

Post data to another sheet

  1. #1
    Registered User
    Join Date
    12-01-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    95

    Post data to another sheet

    Hello Excel Gurus.

    I need help to come up with a VBA Macro for my Excel worksheet.

    I have a workbook with 2 sheets, [TR Sheet and Masterlist sheet]

    The TR sheet has 4 columns where I type the data.

    The Masterlist has 9 columns where I will post the data coming from TR sheet. If the TR Type is RETURN, the QTY will be added to Masterlist and if the TR Type is BORROWED, the QTY will be deducted from the Masterlist. Also, the Notes on each item will be copied to the Masterlist. Once the TR sheet data is posted, data must be erased so that there will be no double transaction. My purpose is to key the items on the TR sheet and merge the items on the Masterlist instead of keying it directly on the Masterlist because there are more than 500 items on the list. I have attached a Sample screen shot before and after the posting or running the code.

    I hope somebody can share their expertise. Any clarification, please let me know.

    Thank you.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,143

    Re: Post data to another sheet

    Please read the yellow banner at the top of this page on how to attach a sample workbook.

+ 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] Command button to post data from one sheet to another one
    By ewolfe48 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2016, 06:38 PM
  2. Help on macro to fetch data from one sheet and post on the other
    By preond in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2016, 09:15 AM
  3. [SOLVED] Calling data to another sheet post filtering
    By moonshinewillie in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-08-2016, 04:49 PM
  4. Need help with a VBA script to post data from one sheet to another
    By TomInMB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2015, 05:42 PM
  5. Command button to post data from one sheet to another one
    By ricepm55 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2013, 02:06 PM
  6. Replies: 3
    Last Post: 07-08-2006, 08:35 AM

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