+ Reply to Thread
Results 1 to 4 of 4

Macro to Select 2 rows from one work book to Another workbook with multiple tabs on each

  1. #1
    Registered User
    Join Date
    02-21-2014
    Location
    Dallas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Macro to Select 2 rows from one work book to Another workbook with multiple tabs on each

    Hello All,
    I have 2 workbooks. The workbooks have 36 tabs for each department. Workbook 1 are current charges for the departments and workbook 2 is the revenue for each department. I would like to take the top 2 rows from workbook 2 and add them to workbook 1 at the bottom of each tab. I was able to get it to work to a specific row but the workbook 1 has variable rows for each tab.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to Select 2 rows from one work book to Another workbook with multiple tabs on ea

    Hi Das,

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    02-21-2014
    Location
    Dallas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Macro to Select 2 rows from one work book to Another workbook with multiple tabs on ea

    xladept,
    That worked like a charm. Thank you so much.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to Select 2 rows from one work book to Another workbook with multiple tabs on ea

    You're welcome!

+ 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 data from multiple sheets in workbook to different work book but on one worksheet.
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2014, 11:31 PM
  2. Recording a Macro to be used on multiple spreadshets within work book
    By sds33 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2013, 04:49 AM
  3. Replies: 0
    Last Post: 06-12-2013, 09:05 AM
  4. Replies: 6
    Last Post: 02-01-2012, 05:29 PM
  5. [SOLVED] macro: copy multiple workbooks to multiple tabs in single book
    By Michael in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2006, 11:55 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