Results 1 to 105 of 105

split Tables into multiple Tables for multiple sheets with different structure & arranging

Threaded View

abdo meghari split Tables into multiple... 02-23-2023, 02:30 AM
abdo meghari Re: split Tables into... 02-24-2023, 01:08 AM
abdo meghari Re: split Tables into... 02-25-2023, 05:13 AM
JohnTopley Re: split Tables into... 02-25-2023, 06:37 AM
abdo meghari Re: split Tables into... 02-25-2023, 05:06 PM
Marc L Re: split Tables into... 02-25-2023, 08:13 PM
abdo meghari Re: split Tables into... 02-26-2023, 12:43 AM
Marc L Re: split Tables into... 02-26-2023, 01:49 AM
abdo meghari Re: split Tables into... 02-26-2023, 02:44 AM
Marc L Re: split Tables into... 02-26-2023, 03:01 AM
JohnTopley Re: split Tables into... 02-26-2023, 03:46 AM
Marc L Re: split Tables into... 02-26-2023, 04:27 AM
abdo meghari Re: split Tables into... 02-26-2023, 05:04 AM
abdo meghari Re: split Tables into... 02-26-2023, 05:13 AM
JohnTopley Re: split Tables into... 02-26-2023, 05:38 AM
JohnTopley Re: split Tables into... 02-26-2023, 06:26 AM
Marc L Re: split Tables into... 02-26-2023, 10:52 AM
abdo meghari Re: split Tables into... 02-26-2023, 08:58 AM
Marc L Re: split Tables into... 02-27-2023, 10:56 AM
Marc L Erratum ... 02-28-2023, 03:44 AM
Marc L Re: split Tables into... 02-26-2023, 10:36 AM
abdo meghari Re: split Tables into... 02-26-2023, 04:01 PM
Marc L Re: split Tables into... 02-26-2023, 07:50 PM
abdo meghari Re: split Tables into... 02-27-2023, 04:22 AM
Marc L Re: split Tables into... 02-27-2023, 07:51 AM
JohnTopley Re: split Tables into... 02-27-2023, 09:33 AM
Marc L Re: split Tables into... 02-27-2023, 10:25 AM
abdo meghari Re: split Tables into... 02-27-2023, 03:35 PM
abdo meghari Re: split Tables into... 02-27-2023, 03:47 PM
Marc L Re: split Tables into... 02-27-2023, 06:34 PM
JohnTopley Re: split Tables into... 02-28-2023, 03:31 AM
abdo meghari Re: split Tables into... 02-28-2023, 05:04 AM
Marc L Re: split Tables into... 02-28-2023, 10:18 AM
abdo meghari Re: split Tables into... 02-28-2023, 03:23 PM
Marc L Re: split Tables into... 02-28-2023, 04:27 PM
abdo meghari Re: split Tables into... 03-01-2023, 05:01 AM
Marc L CRASH time so questions time ! 03-01-2023, 08:28 AM
abdo meghari Re: split Tables into... 03-01-2023, 08:50 AM
Marc L Re: split Tables into... 03-01-2023, 09:04 AM
Marc L Re: split Tables into... 03-01-2023, 10:54 AM
abdo meghari Re: split Tables into... 03-01-2023, 10:46 AM
abdo meghari Re: split Tables into... 03-01-2023, 11:38 AM
JohnTopley Re: split Tables into... 03-01-2023, 12:52 PM
Marc L Re: split Tables into... 03-01-2023, 03:39 PM
abdo meghari Re: split Tables into... 03-02-2023, 06:55 AM
Marc L Re: split Tables into... 03-02-2023, 08:28 AM
JohnTopley Re: split Tables into... 03-02-2023, 09:30 AM
abdo meghari Re: split Tables into... 03-02-2023, 06:57 AM
JohnTopley Re: split Tables into... 03-02-2023, 07:49 AM
Marc L Re: split Tables into... 03-02-2023, 08:21 AM
Marc L How it may work, or not ... 03-05-2023, 02:59 PM
abdo meghari Re: split Tables into... 03-02-2023, 03:23 PM
abdo meghari Re: split Tables into... 03-02-2023, 03:24 PM
Marc L Re: split Tables into... 03-02-2023, 08:59 PM
abdo meghari Re: split Tables into... 03-03-2023, 11:16 AM
abdo meghari Re: split Tables into... 03-03-2023, 11:42 AM
Marc L Question #2 ... 03-03-2023, 11:57 AM
abdo meghari Re: split Tables into... 03-03-2023, 12:34 PM
JohnTopley Re: split Tables into... 03-03-2023, 01:11 PM
Marc L Q2 and half ... 03-03-2023, 01:07 PM
Marc L Re: split Tables into... 03-03-2023, 01:16 PM
abdo meghari Re: split Tables into... 03-03-2023, 01:36 PM
abdo meghari Re: split Tables into... 03-03-2023, 01:39 PM
JohnTopley Re: split Tables into... 03-03-2023, 03:31 PM
Marc L Question #3 ... 03-03-2023, 07:35 PM
abdo meghari Re: split Tables into... 03-04-2023, 06:22 AM
Marc L Q3 and half ... 03-04-2023, 07:15 AM
Marc L Re: split Tables into... 03-07-2023, 11:27 AM
abdo meghari Re: split Tables into... 03-04-2023, 07:38 AM
Marc L Still Q3 & half ... 03-04-2023, 08:10 AM
abdo meghari Re: split Tables into... 03-04-2023, 11:56 AM
Marc L Q3 ... 03-04-2023, 12:08 PM
abdo meghari Re: split Tables into... 03-04-2023, 12:25 PM
Marc L Q3 solved ... 03-04-2023, 12:37 PM
abdo meghari Re: split Tables into... 03-04-2023, 12:42 PM
Marc L Question #4 : last but not... 03-04-2023, 12:44 PM
abdo meghari Re: split Tables into... 03-04-2023, 01:52 PM
Marc L Re: split Tables into... 03-04-2023, 04:52 PM
abdo meghari Re: split Tables into... 03-05-2023, 03:59 AM
Marc L Re: split Tables into... 03-05-2023, 07:54 AM
abdo meghari Re: split Tables into... 03-05-2023, 08:54 AM
Marc L How that works ... 03-05-2023, 10:11 AM
abdo meghari Re: split Tables into... 03-05-2023, 03:19 PM
Marc L Re: split Tables into... 03-05-2023, 03:29 PM
abdo meghari Re: split Tables into... 03-05-2023, 03:36 PM
Marc L Re: split Tables into... 03-05-2023, 03:40 PM
abdo meghari Re: split Tables into... 03-05-2023, 03:56 PM
Marc L Re: split Tables into... 03-05-2023, 06:38 PM
Marc L Re: split Tables into... 03-05-2023, 07:04 PM
Marc L Re: split Tables into... 03-05-2023, 07:17 PM
abdo meghari Re: split Tables into... 03-06-2023, 03:29 AM
Marc L New set of questions ... 03-06-2023, 06:15 AM
abdo meghari Re: split Tables into... 03-06-2023, 06:31 AM
Marc L Re: split Tables into... 03-06-2023, 08:07 AM
abdo meghari Re: split Tables into... 03-06-2023, 08:38 AM
Marc L Re: split Tables into... 03-06-2023, 09:12 AM
abdo meghari Re: split Tables into... 03-06-2023, 09:49 AM
Marc L Re: split Tables into... 03-06-2023, 11:18 AM
Marc L Re: split Tables into... 03-06-2023, 01:33 PM
abdo meghari Re: split Tables into... 03-06-2023, 02:23 PM
Marc L Re: split Tables into... 03-06-2023, 03:31 PM
abdo meghari Re: split Tables into... 03-07-2023, 03:16 AM
Marc L Try this ! 03-07-2023, 07:17 AM
abdo meghari Re: split Tables into... 03-07-2023, 10:15 AM
abdo meghari Re: split Tables into... 03-07-2023, 11:14 AM
  1. 02-27-2023, 06:34 PM #11
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question Re: split Tables into multiple Tables for multiple sheets with different structure & arran


    On our side the circumstances are the same than before …

    Anyway, as in case I post an Excel basics VBA procedure according to your initial attachment it will be an one shot starter,
    I will not modify it for what your forgot / misexplained, to be sure to not waste any time,
    in 'tt' sheet column A you can have for example 20 files but only with three possible data structures
    and only three expected layouts results like in your initial attachment ?

    According to post #23 did you think at least about a strategy ?


    To John : did you start something ? So in this case I let you ending your code …
    Last edited by Marc L; 02-27-2023 at 06:46 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do you split a table up into multiple smaller tables by column?
    By born2dive00 in forum Excel General
    Replies: 3
    Last Post: 03-04-2022, 08:30 AM
  2. Index Multiple tables from Multiple Sheets (Same Workbook) into Master Table
    By Tjfinley in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2021, 03:41 PM
  3. Sorting on multiple keys/multiple tables/multiple sheets
    By BoomerN in forum Excel General
    Replies: 7
    Last Post: 11-28-2020, 06:55 PM
  4. Delete and add rows to multiple tables on multiple sheets using inputbox
    By Oliver_watkins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2020, 04:56 AM
  5. Copy Paste multiple tables from multiple sheets into Outlook email
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2015, 12:21 PM
  6. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM
  7. [SOLVED] Split a long table to multiple tables
    By amasson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-02-2013, 05:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1