Posts by tqv1969

  • Copy Data Range From 1 Workbook To Another

    Re: Copy Data Range From 1 Workbook To Another


    Dear xlite,


    I've tested your new files and it worked. Many thanks Xlite.
    But the issue to me that is I've got one macro to edit the raw sheet to clean one after I bring all raw sheets(Sheet2 in this case) orginally to one sheet.
    That means I need to edit all of them one by one first and apply your code later to bring all reparate sheets to test.xls later. If that is the case, I must edit one by one manually before apply your code.
    Do you have any other way to do the same as current code but bring original Sheet2 content to Test.xls?


    I understand that the Good House Keeping will help but I can't avoid that b/c the resources file are big and a lot. Sorry I ask you again.


    Best regards,
    TQV1969

  • Copy Data Range From 1 Workbook To Another

    Re: Copy Data Range From 1 Workbook To Another


    Dear xlite,


    I've attached here the two workbooks with data I want to copy to Test.XLS and data from Sheet2 for all three files. The modified code is in Test.xls file.
    You can see the result of the code in Sheet2 in Test.xls.
    Btw,There are any issues if i copy different sheet name from different files to Test.xls and in that case what the code should be.


    Many thanks again for your time with me:) I hope this time it work!
    Best regards,
    TQV1969

  • Copy Data Range From 1 Workbook To Another

    Re: Copy Data Range From 1 Workbook To Another


    Dear xlite,


    I can select all sheet now but one more issue is the second set of data didn't connect from the last row in out put file but ONE row right after that. So the second set of data overwrite on the previous one but leave first row left only and so on for those next files.
    I'm sorry to border you so many times but I tried my best but It couldn't.:crying:


    Best regards,
    TQV1969

  • Copy Data Range From 1 Workbook To Another

    Re: Copy Data Range From 1 Workbook To Another


    Dear xlite,


    I've tried with my dir as C:\Copy\ and change to Sheet2 for those Sheet(1) in your code. And it showed message again.
    I've got the source file with data in Sheet2 and want to copy all sheet contents from each of them to final file in Sheet2 also.
    Did I do some thing wrong?:crying:


    Best regards,
    TQV1969

  • Copy Data Range From 1 Workbook To Another

    Re: Copy Data Range From 1 Workbook To Another


    Dear Xlite,


    I'm TQV1969 that you helped me in Sat. I've got the same situation and I've tried your code but it showed the error message "Compile error: Sub or Funtion not defined" and highlight yellow backgroud for "GetFileList" in your code. Is it one other code for that or excel's funtion originally?


    Thanks.
    TQV1969

  • Consolidate Data From Many Sheets To One Sheet

    Re: Consolidate Data From Many Sheets To One Sheet


    Dear Xlite,


    That's code is great that help me to move between sheets. I've got only one problem left: how can i get the name of sheet fill in automatically in Sheet1 and Sheet2 as your example file?
    Some body can help?


    Best regards,
    TQV1969

  • Consolidate Data From Many Sheets To One Sheet

    Dear Gurus,


    I'am have one data file with so many sheets those need to edit and bring them to final summary sheet.
    I dont know how to move between sheets and edit them automatically.
    Editing will need to add the brand name next to the variance name and the sheet name in one new column. And bringing those rows with completed data only to All sheet from those sheets in workbook.
    Your help is very much appreciated.
    Best regards,
    TQV1969

  • Don't hide row with at least one cell with color

    Dear Gurus,


    I tried the VBA to hide the row if the range of cells e.g: C2:E2 are blank and the macro hide all rows if they find the conta of cells = 0 . But the issue that I want to keep those row that is blank but have at least one cell with color in back groud + comment.
    1- Can I do that in VBA?
    2- Can I check the empty range instead of counta cells in above condition for hide the rows?


    Best regards,
    TQV

  • Convert date & time to just date

    Re: Convert date & time to just date


    Dear sjobevakare,


    I've got the nearly same question and I've got one suggestion that I think it will work for you. You try the formula of Wigi but add one more thing as following:
    =DATEVALUE(DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1))
    Hope it help.


    Best regards,
    TQV

  • Compare data between two sheets

    Re: Compare data between two sheets


    Dear Dave,


    Thnaks for your help but I'm not successful. What I want is to search one of row in sheet 1 to find the same in sheet 2. In case it is match bold all of them with green back ground. If not(match with most of cells but 1 or 2 are diff.), highlight those different cells in that row in both two sheet.
    Can we have the solution to bring all of them into one sheet data where the same will be unique; And those are not exact 100% will be high light those cells are diff and add one more column with name of sheet to know where they come from.
    Thanks.
    TQV