+ Reply to Thread
Results 1 to 5 of 5

Macro to transfer data from Input sheet to summary form

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    24

    Macro to transfer data from Input sheet to summary form

    I am looking to automatically transfer that data that is input into the "Input Data" tab to the "Invoice Form" tab in the corresponding cells. Is this possible? Does it involve a macro/VBA?

    Also when there are multible rows populated in the "input data" tab will it be possible on the Invoice Form tab to scroll back through the previous rows of data?

    See the file attached. I'd say it is rather basic but I have no expereince of using Macros.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Macro to transfer data from Input sheet to summary form

    See attached

    alan
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-20-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Macro to transfer data from Input sheet to summary form

    Alan,

    Thank you for that. Just a quick follow up. When the data is transferred to the Invocie Form sheet the it takes not only the data but also the format of the data. Can I change the format of the data in the Invoice Form Tab??

    When I copy the macro to my actual excel sheet it transfers across the formula within the cell to the Invoice Form tab as oppose to the content. Can I have it where the marcro just transfer across the data within the cell and not a formula or format?
    Last edited by CA_needing_help; 07-03-2013 at 03:40 AM.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Macro to transfer data from Input sheet to summary form

    Replace the code I gave you in the example with this:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-20-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Macro to transfer data from Input sheet to summary form

    Thanks Alan, it worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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