+ Reply to Thread
Results 1 to 2 of 2

Merging in one excel

  1. #1
    Registered User
    Join Date
    10-05-2018
    Location
    india
    MS-Off Ver
    window 365
    Posts
    1

    Merging in one excel

    please help me to get the data in one excel with naming conversion of the excel.

    As I am 72 excel reports in one folder with different names and I need all the data in one excel sheet with the name versions.

    example:

    1. sheet with the name for "ABC corp.xls"
    2. sheet with the name for "DEF corp.xls"
    3. sheet with the name for "GHI corp.xls"

    all in one excel with the name conversion for excel ABC cop.10 rows after that DEF cop.15 rows then GHI cop. 20 rows like wise.

    Thanks in advance.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Merging in one excel

    Hello chintusant and Welcome to Excel Forum.
    Perhaps the information in the linked video tutorial will help.
    https://www.youtube.com/watch?v=rSQw...ature=emb_logo
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 1
    Last Post: 11-02-2017, 09:20 PM
  2. Merging multiple Excel files into tabs of one excel file without having to copy and paste?
    By BrettRCourtney in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2013, 03:43 PM
  3. Merging many excel files in to single excel file
    By jsrakesh4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2013, 02:06 AM
  4. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  5. Merging cells/merging cell content.
    By rhintintin in forum Excel General
    Replies: 3
    Last Post: 09-23-2010, 10:42 AM
  6. Merging multiple excel files into 1 excel spreadsheet
    By uberblah in forum Excel General
    Replies: 8
    Last Post: 11-08-2005, 08:58 AM
  7. Merging data from an excel worksheet into an excel template
    By pkasler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2005, 01:07 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