+ Reply to Thread
Results 1 to 3 of 3

Specific data from one worbook to another (Excel 2010).

  1. #1
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,052

    Post Specific data from one worbook to another (Excel 2010).

    Hello there,

    I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice Register (sheet 2) simply named Tax Invoice & Statement Template.

    The Cash Book has 14 tabs (Totals, 12 tabs for each month of the year and a Summary). Each month has a separate Income and Expenses section. From the Invoice Register in the second workbook, I would like to extract the following data: Date Paid, Customer and Amount Paid and send this information to the Cash Book but to the relevant month e.g. any amounts paid during April go into the April income, amounts paid in May go into May income etc.(with the Date Paid and Customer details of course). There may be only one payment during a month or there may be a dozen payments in a month so a "NextRow" function would obviously be needed.

    Anybody have any ideas for a macro or am I askig too much of VBA?

    Cheers,
    vcoolio

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Specific data from one worbook to another (Excel 2010).

    no, not asking too much, have you tried recording a macro of you doing it and then inpsecting the code?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,052

    Re: Specific data from one worbook to another (Excel 2010).

    Hi Nathan,

    No I haven't. The macro for my Invoice template works really well (increments the invoice number, saves the invoice to another file, clears contents and posts the basic invoice details to a register) but what I am asking is full of variables and I basically haven't got a clue where to start!

    Cheers.

+ 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. Replies: 3
    Last Post: 06-20-2014, 04:50 PM
  2. Copy data from one worbook to another.
    By gazzauk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 12:38 PM
  3. Exporting a chart from Excel 2010 to a specific slide in PPT 2010
    By dodsonmrf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 06:45 AM
  4. Auto close excel (2010) at specific time bypassing data validation
    By vstrom22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 11:53 AM
  5. Macro for Excel 2010 Data to Notepad in a specific format
    By fisher28303 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2012, 03:37 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