+ Reply to Thread
Results 1 to 4 of 4

Macro to copy and paste information from one sheet to another (closed) workbook

  1. #1
    Registered User
    Join Date
    01-22-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    65

    Macro to copy and paste information from one sheet to another (closed) workbook

    Hi all.

    I am new to VBA and programming, have an idea I would like to execute but I am struggling to create.

    I would like information from one sheet in a workbook to be copied and pasted into another sheet in another workbook(2). The second workbook which receives this information will be closed. In the sheet that will send the information, I have the following headings REQUEST FROM:REQUEST FOR:DATE REQUEST SENT:DETAILS OF REQUEST from A9-A12. Information will then be typed into B9-B12. I want the information from B9 -B12 to be copied and pasted under the corresponding headings in the second workbook.

    The information from the first workbook will be sent by various people, who have access to their own copy. Only I will have access to the second workbook that receives this information , hence why it has to be closed. Therefore every time information is sent to the second workbook, it needs to go onto the next blank line.

    Hope this makes sense. If anyone has a code that I can use for this, I'd be very grateful.

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,241

    Re: Macro to copy and paste information from one sheet to another (closed) workbook

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    To add a file to a new post

    To add a file to an existing post.

  3. #3
    Registered User
    Join Date
    01-22-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    65

    Re: Macro to copy and paste information from one sheet to another (closed) workbook

    Please see attached
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,241

    Re: Macro to copy and paste information from one sheet to another (closed) workbook

    Your original question does not match your examples.

    Here is a code that will be easy to understand.
    Right click on the "Send Request" shape and select assign macro,new

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by davesexcel; 09-25-2015 at 04:28 AM.

+ 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. Copy and Paste in closed workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2014, 08:31 AM
  2. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  3. Macro to copy row to specific sheet in closed workbook
    By newbie-excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-04-2013, 12:51 PM
  4. [SOLVED] Macro Copy and Paste from one sheet to another sheet only where there is information
    By Elmarie_Potgieter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2013, 03:13 AM
  5. Copy 2 sheets from a open workbook and paste to a closed workbook
    By grimston in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 03:27 PM
  6. Macro to copy over and paste data in to a work sheet from a closed workbook
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2009, 04:04 AM
  7. Copy One Sheet From One Closed Workbook To Another Closed WB
    By teshiburu1988 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2009, 11:49 AM

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