+ Reply to Thread
Results 1 to 4 of 4

VB Code to copy data in closed workbook at 1st blank cell

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to copy data in closed workbook at 1st blank cell

    Hello:

    Please refer to attached files. (Book1 & DestinationCLosed"
    I have data in Excel file Called Book1 as shown in sheet.
    I need a VB Code to copy data N11:Q down up to the data to closed workbook called "DestinationClosed", the location of the file is at cell
    value B1

    The copy shoudl be at "ClockInOut" Sheet at 1st blank cell in column A.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: VB Code to copy data in closed workbook at 1st blank cell

    Hi Riz,

    Here is the basic idea of what you are after. It may need to be edited if you have extra sheets in either of the workbooks etc.

    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to copy data in closed workbook at 1st blank cell

    Hi spitfireblue:

    Thanks alot....works great.
    Riz

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: VB Code to copy data in closed workbook at 1st blank cell

    No problems, glad I could help

+ 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. VB Code to perform copy and paste values n closed workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2015, 08:02 PM
  2. [SOLVED] Vba code to copy data to closed workbook
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-28-2014, 04:40 AM
  3. VB code to copy from closed workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2014, 02:59 PM
  4. VBA code for copy data from closed workbook to "Data " sheet of current workbook
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-13-2014, 02:23 AM
  5. [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
  6. Copy Data from Closed workbook (bbb.xls) to Open workbook (aaa.xls) (Part 2)
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2013, 02:06 AM
  7. VBA Code to Copy and Move Closed Workbook
    By kozman2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 09:36 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