+ Reply to Thread
Results 1 to 105 of 105

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

Hybrid 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. #1
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 (Windows 10 64-bit)
    Posts
    875

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

    Next question : according to your post #36 last attachment for the PR-2023-00003 data is it normal the empty 'Sr' column ?
    this is because I copy data manually . in realty will filled numbers 1,2,3 as in BS Q 4286.pdf file in last column ,
    if you want to manually correct the 'tt' worksheet or if you prefer a 'Sr' automatic numbering.
    Neither this nor that . will auto fill when import form original PDF file contains numbers and the word is ITEM not SR as in BS Q 4286.pdf file
    In the last case, as 'Sr' is like an ID for each data row so the 'tt' worksheet Change event VBA procedure
    can not update anymore just the result worksheet relative cell to be changed but must reload all this worksheet data.
    this is not problem to update data , then I will delete whole data in tt sheet and re- import again from PDF files to do that .

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2507 Build 16.0.19029.20136) 64-bit
    Posts
    31,548

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

    I add a new PDF to the last file I posted and had no problem: but I am dropping out of this thread as I have done all I can to provide a solution.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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: 3
    Last Post: 03-04-2022, 08:30 AM
  2. Replies: 6
    Last Post: 04-22-2021, 03:41 PM
  3. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1