+ Reply to Thread
Results 1 to 4 of 4

Copying sheets from different files into a single file

  1. #1
    Registered User
    Join Date
    12-21-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Copying sheets from different files into a single file

    Hi,

    I am interested in a way to merge/copy sheets from multiple Excel files into a single Excel file.
    Some tool or script (python/java?) that will work in Unix and Windows systems, with/without MS Excel installed.
    While preserving existing cell format/style.

    Something equivalent to going over each sheet and copying all the data into a new sheet in a single(new) Excel file (and keeping the format/style - I've found some scripts that dont preserve styles, like pandas in python).

    cross-post:
    You are not allowed to post any kinds of links, images or videos until you post a few times.

    Thank you.
    Last edited by visual90; 12-21-2021 at 09:53 AM.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,487

    Re: Copying sheets from different files into a single file

    Please read forum rules. Especially p. 3.
    Cross-post: https://www.mrexcel.com/board/thread...-file.1190884/
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    12-21-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Re: Copying sheets from different files into a single file

    Oh wow it's a different forum isnt it though? it's not like a son-forum of this forum or something right? I though I'd post on different forums to expose my question to as many unrelated people who might know the answer...

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,487

    Re: Copying sheets from different files into a single file

    Sure you can post into various forums. But you should inform about it.
    Please read Forum Rules, it is not so long.

+ 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. Copying sheets from multiple files into one new file
    By Navin Agrawal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2019, 02:06 PM
  2. extract sheets from multiple excel files and compile into a single file
    By pramesh.pokharel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2018, 01:06 PM
  3. [SOLVED] Copying a single column in multiple Excel files into one Excel file
    By Danech07 in forum Excel General
    Replies: 10
    Last Post: 07-22-2016, 10:26 AM
  4. Merge multiple excel files into single file as different sheets
    By saidineshbabu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2015, 12:38 AM
  5. Copy sheets from different files into one single excel file
    By FixandFoxi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 01:01 PM
  6. Copying data from multiple files (with mult. sheets) into one file and create a graph
    By Macedonia in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-30-2010, 07:37 AM
  7. convert multi-sheets file to single-sheet files
    By yahata in forum Excel General
    Replies: 3
    Last Post: 04-22-2007, 06:54 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