Search:

Type: Posts; User: LuciaLourenco; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Many, many thanks Maudibe Problem solved :D ...

    Many, many thanks Maudibe

    Problem solved :D

    LL
  2. Hello Please see post below the attached file...

    Hello

    Please see post below the attached file and description.

    Many thanks for any help


    LL
  3. Thanks for the help duthiet but even so the...

    Thanks for the help duthiet but even so the problem remains...

    Let's see if I can explain better with an example file.

    Please find attached a file with 3 users (sheets) (that can be N( and 1...
  4. Copy filtered rows to another sheet skip last row

    Hello,

    I'm trying to copy some filtered rows (including the criterie "blank") from several sheets to one sheet only but when the last row have the criteria BLANK the row is not copied.

    The code...
  5. Many thanks RetiredGeek I'll do it like that....

    Many thanks RetiredGeek

    I'll do it like that.

    :)

    LL
  6. Almost there RetiredGeek! This code copy the...

    Almost there RetiredGeek!

    This code copy the excel files in the first directory "Working Files" :) but doens't copy the excel files inside of the subfolders.

    The source folder structure is like...
  7. Hi Berton, I'm using only Excel 2007 with...

    Hi Berton,

    I'm using only Excel 2007 with .xlsx format.

    And if I use FileExt = "*.xlsx", the error is the same...

    Any ideas?

    Many thanks in advance
  8. Hi Maudibe Yes, that is very stange becuase I...

    Hi Maudibe

    Yes, that is very stange becuase I have lost of excel files in the folder.

    Even if I change the line code to FileExt = "*.xlsx", I get the same error!

    What is stange is that if I...
  9. Thanks for the tip Maudibe but I've those...

    Thanks for the tip Maudibe but I've those configurations as you indicate and I still have the error.... :(

    Any other idea?

    Tks

    LL
  10. Hi Steve, Doesn't work as well... I'm getting...

    Hi Steve,

    Doesn't work as well... I'm getting the same error 53 "File not found".


    LL
  11. Copy excel files and folder structure from subfolders with vba

    Hi,

    I need to backup a folder structure with the excel files (all the other extensions aren't to copy) from a location to another.

    I'm using the following code, that work just fine for ALL...
  12. Sorry Maudibe but I didn't see the 2nd post :( ...

    Sorry Maudibe but I didn't see the 2nd post :(

    But works jst fine :D

    Many thanks for your help.


    LL
  13. Thanks for the info Maudibe The copy process...

    Thanks for the info Maudibe

    The copy process is ok but the paste is not.

    Meaning:
    1) copy the filtered rows from the 1st sheet and paste it ok in sheet MKT starting on cell A1
    2) copy the...
  14. Hi Steve, Thanks for the reply. The...

    Hi Steve,

    Thanks for the reply.

    The filtered rows from each sheet is to paste in the sheet "MKT", starting in cell B8.

    I've tried the following code:

    For Each wTarget In Worksheets ...
  15. Copy filtered rows from several sheets to one sheet

    Hello,

    I have a file with several sheets with filters and I need to copy the filtered rows (according the filter applied) from all sheet to one sheet only.

    The code that I'm using is:...
  16. **SOLVED** Super!! It work's just perfect :D ...

    **SOLVED**

    Super!! It work's just perfect :D

    Many, many thanks Steve

    Regards

    LL
  17. If you telm me the code to copy from source and...

    If you telm me the code to copy from source and paste it on target I think that I can you it for all the other values.

    Yes, the technician will be always in J3.

    The code should tranfer only the...
  18. The values to be copied from the source (Tech...

    The values to be copied from the source (Tech code, Total A - 1, Total A - 2, Act 1, Act 2, Result 1, Result 2, etc) will be paste in to the target file in the correspondent lines.

    There will be a...
  19. I need to copy the source from each day (day 1...

    I need to copy the source from each day (day 1 and others) in to the target.

    The target file will have a sheet "day 1" will the source data from all technician, side by side in each column.


    LL
  20. Hi Steve, Thank you for getting back to me. ...

    Hi Steve,

    Thank you for getting back to me.

    Please find attached 2 woorkbooks:

    1) "Source_Workbook.xlsx"
    - Where I have the data to copy from
    - I will have 1 file for each...
  21. Copy different columns from several files to 1 single column in 1 file

    Hello,

    I have several workbooks in severeal folders and I need to copy some ranges in different columns from each one of those files to ONE file only.

    I'have 2 problems:
    1) The data (the...
  22. It works! Many thanks Rory :cool: LL

    It works!

    Many thanks Rory

    :cool:


    LL
  23. Hi Steve, Sorry... but I'm getting the same...

    Hi Steve,

    Sorry... but I'm getting the same error "Unable to set the Locked property of the Style class" :(

    Any other ideas?

    Thanks

    LL
  24. Hello Rory, It works just fine for a single...

    Hello Rory,

    It works just fine for a single file :D but I'm need to apply it for several files in different folders and I'm getting the error message "Unable to set the Locked property of the...
  25. How can I modify the "Normal" Cells Style using VBA?

    Hello,

    How can I modify the "Normal" Cells Style using VBA?

    The parameter that I need to modify is in:
    - Normal Style
    - Modify
    - Format button
    - Protection tab
    - Uncheck option...
Results 1 to 25 of 36
Page 1 of 2 1 2