+ Reply to Thread
Results 1 to 6 of 6

Copying data over to a master record

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Copying data over to a master record

    I am trying to build a spreadsheet that would copy data from a packing slip over to what I am calling a master record. I envision a macro that would copy the data from pslip (tab) to Master Records (tab), each time I would press the macro (perhaps a button on the pslip tab) I would like for it to copy the packing slip data to the next available or open column on the Master Records tab. I have the rest of the pretty simple spreadsheet working but can't figure out how to get Excel to copy data to the next available column (and to keep it there as a mater record once it is deleted from the order or packing slip).

    My wife wrote a children's book about a new kid moving into a new classroom and I intend to use this to track sales. If the book starts to sell well we'll need to invest in a real book keeping program, in the meantime I was hoping to get by with this. Any suggestions are welcome and to the person who solves it - let me know if you want a copy of the book and I will ship you a complimentary copy along with our thanks.

    Any suggestions welcome.
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Copying data over to a master record

    Hi tommypkoch

    I'll be glad to look at this with you if your open to changing your Master Records layout from vertical to horizontal. Is that OK?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Copying data over to a master record

    Horizontal is just fine. Thanks

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Copying data over to a master record

    Hi tommy

    I suspect you'll be wanting more from this...play with it, let me know.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jaslake; 02-27-2015 at 06:06 PM.

  5. #5
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Copying data over to a master record

    Solved

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Copying data over to a master record

    Hi tommy

    Thanks for the rep.

    If this resolves your issue please mark your Thread as SOLVED.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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. Copying a range of data into another Master workbook below existing data
    By Grizz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2014, 06:24 AM
  2. Replies: 0
    Last Post: 04-16-2013, 07:29 AM
  3. Copying Data from Master and Creating new worksheet to save data
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 06:43 AM
  4. Replies: 1
    Last Post: 11-18-2011, 01:25 AM
  5. Getting data from a closed workbook to a master record
    By Garcia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2006, 09:16 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