Posts by Redahussien

    hi,

    can you help please with VBA to remove any extra empty rows between the tables. and keep a fixed number of row , say 1 row only. so all the vertical separation between tables will be the same.

    please check the attached file.


    there is actually more than two columns of tables ,but i give sample of two.


    highly appreciate you help.

    thanks in advance.

    Re: Track new data


    Quote from cytop;778208

    I would doubt anyone could help with the information you have given. Please take the time to explain your process, what information changes, how, and what information you want to track.


    Ideally upload a sample workbook showing a before and after scenario.


    [sw]*[/sw]


    Please help i uplaoded the sample detailed file

    Files

    • sample.xlsx

      (10.15 kB, downloaded 107 times, last: )

    Hi everyone,
    Each product has four stages s1 s2 s3 s4
    I want to track the stages each product pass through
    As per below explanation
    Table1(the main table)
    Pro1 s1
    Table2
    Pro1 s1


    Table1
    Pro1 s2
    Table2
    Pro1 s1
    Pro1 s2


    Table1
    Pro1 s3
    Table2
    Pro1 s1
    Pro1 s2
    Pro1 s3
    So table2 track the changes in the product stage.
    I think All the coding should be done on table2
    Please help