Results 1 to 1 of 1

Auto Copy PO Line Items into Summary Report

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2010
    Posts
    12

    Auto Copy PO Line Items into Summary Report

    Hi everyone.
    I am using an excel PO template to create Purchase Order for supplier.
    With this template, I wish to know how I can use macro to auto copy each line items into another summary worksheet that I named it as "Transaction".
    Currently, I have to key in all line item manually to create this report, hope someone could help me in this regards.
    Attached is the PO template for your reference.

    Thanks.
    CJ Yap
    Attached Files Attached Files
    Last edited by Yap Chin Joo; 11-12-2013 at 12:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert Detailed Time Attendance report from Biometrics to Summary Report
    By firescorpio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2013, 02:48 AM
  2. Auto Sort line items based off of cell color
    By Jscott1601 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2013, 11:43 AM
  3. Auto Sort line items based off of cell color
    By Jscott1601 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2013, 03:03 PM
  4. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 PM
  5. [SOLVED] Auto Archive LIne Items in Excel Worsheet
    By Perplexed Excel User in forum Excel General
    Replies: 0
    Last Post: 07-20-2006, 05:50 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