Posts by ivandgreat

    Please help me to create a macro for my table.


    I have four tables in my attached file as Ports, Sum, and SearchID, SearchPorts sheet, i wanted to have a macro that;

    • will update the columns SumCap, NoDepID and IDs in "Sum" sheet. The column "SumCap" will only calculate (sum up) the number of list in column E (RName) @ "Ports" sheet. Column "NoDepID" will count the number of IDs (no duplicate and not included the ID itself) exist in column E (RName). And column "IDs" will only list the IDs that was counted in column "NoDepID"


    • in "SearchID" sheet, when i search the ID, i would like only to filter from "Sum" sheet all IDs that was listed in it column "IDs" including the ID that i search, example was shown in my attached file.


    • in "SearchPorts" sheet, it will list down the corresponding table from "Ports" sheet that was search in "SearchID", together with the IDs mentioned in column "IDs", example was also shown in my attached file.


    br,

    Files

    • CasRoute.xlsx

      (58.32 kB, downloaded 5 times, last: )

    Re: 20$ How to Copy Separate tables (with Diff Fields) and transfer to next empty row


    Hi,


    I just thought of it is really hard to work on this kind of file, could you just help me to have a code to at least look on the "traffic routing" name from the sample files then copy the table below it until the last row of that table and paste it in a separate sheet at the next available row.


    A macro to open the all available files in that folder, copy, paste, then automatic with current date.

    Re: 20$ How to Copy Separate tables (with Diff Fields) and transfer to next empty row


    Hello again,


    It seems fine but i just forgot to notice something also to be consider,


    1. the sheet name is also the same as the file name
    2. there was a title name "Save Report" before the table, please check another attachments.
    3. Could it be possible instead of opening the file one by one, just open all existing files in specified folder (open, copy, paste and close the file one at a time until it opens all and update the excel file)
    4. instead of excel file, open the html as excel, since the table is the same.
    5. It is possible to copy all existing table to its specified table name (as sheet name).
    6. Please advise, as you seen the attachment.


    br,

    Files

    • 2004-1.xls

      (47.1 kB, downloaded 2 times, last: )
    • 2005-1.xls

      (24.58 kB, downloaded 1 times, last: )

    Re: 20$ How to Copy Separate tables (with Diff Fields) and transfer to next empty row


    Hello again,


    I thought of saving it in one file with different sheets (with respect to their table), i attached the sample output that will help you. Also I would like to add that after copying the rows from the source file, it is possible to add the source file name in first column (ex 2012-1) from each row to be able to distinguish each row from which file it came from?


    Hope i didn't make it hard for you about this additional request.

    Files

    • Summary.xlsx

      (12.27 kB, downloaded 4 times, last: )

    Re: 20$ How to Copy Separate tables (with Diff Fields) and transfer to next empty row


    Also, the tables sometimes located in other rows (row 5, row 12, row 23, etc), but still the table fields are the same for all.


    The unique name for each table is one row above the table field name, as per my example, Terminal Configuration has 2 table while Traffic Routing has only 1.


    I'm planning to look only for this name then start copying the rows (below their field name) with respect to each tables and transfer to much better sheet.

    Hi,


    I'm new in excel programming and I'm seeking to all gurus out there to help me about my excel problem.


    I have two or three different table in one single sheet (Sheet1) which is separated to each other from a single row with there respective fields. I want to copy each table without the header and transfer there rows to each respective excel File (XFile1, XFile2, XFile3).


    Hope your support about this.


    br,

    Files

    • Term.xlsx

      (12.7 kB, downloaded 3 times, last: )