+ Reply to Thread
Results 1 to 5 of 5

Combining multiple workbooks with the specifice name in one workBook on baisi of Worksheet

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Delhi, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    32

    Combining multiple workbooks with the specifice name in one workBook on baisi of Worksheet

    Hi Guys...!!

    Hope you all are well..

    This forum site is more helpful site for me to fix up the issue's i have and had.. So Thanks to the Admin.

    Here is my issue.

    I just want to combine multiple workbooks with different name in to one sheet which in a same location

    I have a workbook name work Allocation in the workbook I allocate item to my SMT Associate and create a backup in the same sheet with a specific name of the sheet.

    Now I have different workbook with a name of the SMT associate where I need to transfer the data according to the their in there in the the specified worksheet which is same as it appears in allocations.

    and again I also need to pull the data from the SMT associate workbook to the work allocation sheet after completing with the format

    Guys can anyone please help me here ?

    Many thanks in advance for all your help and time.

    Thanx,
    Nitesh
    Attached Files Attached Files
    Nitesh

  2. #2
    Forum Expert (Lazarus)
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    .
    Posts
    2,594

    Re: Combining multiple workbooks with the specifice name in one workBook on baisi of Works

    Also: http://www.ozgrid.com/forum/showthread.php?t=177606

  3. #3
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,161

    Re: Combining multiple workbooks with the specifice name in one workBook on baisi of Works

    Thanks cytop.

    Nitesh,

    I'm afraid your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    10-02-2012
    Location
    Delhi, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    32

    Re: Combining multiple workbooks with the specifice name in one workBook on baisi of Works

    Thanx for guiding me ... sorry for this ...

    Please let me know how do I close this ?

  5. #5
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,161

    Re: Combining multiple workbooks with the specifice name in one workBook on baisi of Works

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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