+ Reply to Thread
Results 1 to 3 of 3

Learning Curve: Using a macro to input data from an invoice into an expense report

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    Waco, Tx
    MS-Off Ver
    Excel 2013
    Posts
    12

    Learning Curve: Using a macro to input data from an invoice into an expense report

    Hi guys, I recently asked about saving and auto-numbering an invoice and I'm still working on that. The next part I am trying to figure out is how to have that information that I save automatically populate another excel worksheet. The catch though, is I'm trying to get it to save on the next available line in the expense report. So if Row D already has an invoice, it moves onto Row E, etc.. Thanks!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,111

    Re: Learning Curve: Using a macro to input data from an invoice into an expense report

    Hi,

    Do you really mean ROW D, ROW E, or Column D, Column E. Assuming you are referring to rows then you'd just use code similar to (assumes you've just copied a range of data)

    Please Login or Register  to view this content.
    However for more specific advice upload your workbook.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-31-2014
    Location
    Waco, Tx
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Learning Curve: Using a macro to input data from an invoice into an expense report

    Those are the two workbooks, and the invoice one is still being worked on to get it to save, auto-populate, and clear properly.
    Thanks for any help.
    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)

Similar Threads

  1. Creating a macro that will copy data from an input form to an Invoice database
    By uqwee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 09:07 AM
  2. Learning VBA - Suggestion for Beginners Learning Curve
    By sighlent1 in forum Excel General
    Replies: 1
    Last Post: 08-26-2010, 12:58 PM
  3. Replies: 4
    Last Post: 12-26-2008, 03:23 AM
  4. Crawford Learning Curve
    By mindyme in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-29-2008, 10:44 AM
  5. more help please <-noob learning curve
    By Radonsheep in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 11-15-2006, 05:17 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