Posts by Rmrekoj

    Quote

    Hi team,


    i am working with the merge all workbook into one master file.. require your help here to copy header at the top of Master sheet...

    also it would be very great full if the code get converted easy and faster with the help of Ubound array . :):)


    I have two open sheets with some of matching column header


    so first sheet is my main sheet where some column I need to fill from other sheet


    For ex


    I have column name ( Name, Address, Contact No) ( this is fixed row)


    and second sheet I have many columns but I want only require columns data
    in this sheet I have column name ( this row can be different not stable)
    (Name, last name, Contact No, Date, DOB, Address, etc…..)


    so I need just that 3 columns data to my main sheet till last row
    only this data ( Name, Address, Contact No)


    thanks

    Hi team,


    is there any way to set macro in ribbon tab like working in the quick access bar.... but issue is ribbon macro is showing in all of my excel file ,, and i dont want that.


    quick access is working good but showing small icon .. is there any option available please let me know



    thanks so much

    Hi team,


    I am working on a query and require your help on..


    as I have a database of group and sequence and with help of that I have to format my new data...


    this is the database.



    this is data


    result should get as per database like below.


    Thanks

    by using below code I am able to reduce the above macro time..still m searching a progress bar




    Code
    1. Cells.Select
    2. Selection.Copy
    3. Sheets.Add After:=ActiveSheet
    4. Cells.Select
    5. Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    6. :=False, Transpose:=False
    7. Application.CutCopyMode = False

    Hi team,


    with the help of your support I got the below code.
    and its working fine but taking too much time as its providing data from 4 excel file.


    so request you to can u please help me out...


    1) can u make it shorter & faster as this is huge due to which taking time.


    2) I would like to set progress bar so that I can wait accordingly rather that pressing key