+ Reply to Thread
Results 1 to 4 of 4

VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

  1. #1
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    74

    VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

    Hello,

    Can anyone please assist me in how I would go into 4 workbooks and pull a certain cell and copy and paste that data into the current open workbook w/ the macro. I am new to VBA and trying to start out basic. An example of what I am trying to accomplish is below.

    I need to go into workbook1, workbook2, workbook3, workbook4, and pull a cell off each sheet named the Trial Balance, however, the length of the trial balance will vary so the number of rows varies. The total is always in column C, but the number of rows vary. A unique identifier is the cell directly to the left (column B) always has the word "Total:" beside the column C total that I needed copied and pasted. I would then like to copy and paste the Trial Balance total in column C from each workbook in cells A1, A2, A3, A4 of the current workbook with the macro. Can someone please provide any guidance on this? Any help is greatly appreciated!

    Thanks!

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

    Duplicate thread

    https://www.excelforum.com/excel-pro...k-w-macro.html

  3. #3
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    74

    Re: VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

    This is the same end result data wise but a different question on how to do it differently

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

    Same to me, just divide the total by 2 should give you the result that you want.

+ 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. [SOLVED] Get data from Closed workbook and paste in current Workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-08-2015, 02:45 PM
  2. Macro to copy and paste information from one sheet to another (closed) workbook
    By V.Cell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2015, 04:25 AM
  3. [SOLVED] Copy a Worksheet from a Closed Workbook to the Current Opened Workbook
    By glennchung in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-28-2014, 12:55 PM
  4. Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  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 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
  7. 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

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