Search:

Type: Posts; User: Howardc

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thanks for the help, much appreciated

    Thanks for the help, much appreciated
  2. Custom Cell Format To Display 8 Digit Numeric Value As Date In DD/MM/YYYY Format

    I would like to know how to set a custom format so that if a user enters a date for eg as 28022014 , it will automatically format as 28/02/2014
  3. My apologies-have read the link to Cross Posters...

    My apologies-have read the link to Cross Posters and agree 100% with the sentiment. Will post solution on all the sites for once found, where I have cross posted


    My code is partly working.
  4. Unfortunately, I don't understand your code I...

    Unfortunately, I don't understand your code

    I have tried to write my own code.

    If I copy the files from the sub-folders to C:\extract it works, but the code does not open the files containing...
  5. Thanks for the reply When running your code, I...

    Thanks for the reply

    When running your code, I get "Compile Error: Syntax error" and the following code is highlighted


    c00="C:\Pull\" & replace(createobject(wscript.shell").exec("cmd /c Dir...
  6. Code to open up files in folder and sub-folder

    I Have the folowing code where I want to open up all files in a folder C:\pull as well as all the folders within C:\pull where the name contains ACCNTS(P). These are all XLS files

    See code below,...
  7. Thanks for the Reply. I removed this section...

    Thanks for the Reply.

    I removed this section from the code and changed GP % target to incorporate each branch for eg GP % target-Br1 , GP % target-Br2 and then set up a table and had a Vlookup in...
  8. Hi Excel Fox I have tried to automate your...

    Hi Excel Fox

    I have tried to automate your formula using VBA code, but it returns true for all the items

    Sub Dup_Val_SameRef()


    Dim LR As Long
    LR = Cells(Rows.Count,...
  9. Hi Excel Fox Thanks for picking this up. I...

    Hi Excel Fox

    Thanks for picking this up. I have amended the values and it now works perfectly.

    Once again thanks for your help
  10. Hi Excel Fox Thanks for letting me know. I...

    Hi Excel Fox

    Thanks for letting me know. I have now used the formula as an array. It is howver, not giving me the correct solution

    What Is need is where the value in Col F & G match for Eg F8...
  11. Hi Excel Fox Thanks for your reply. The...

    Hi Excel Fox

    Thanks for your reply. The formula is giving me false for all the items. The items in Yellow should give me true

    Your assistance in resolving this will be most appreciated
  12. Delete Rows where data is the same but in different columns

    I have values in Col F and G. Where the value in Col F is the same as in Col G and the control (ref #) in Col E is the same, then the rows contain this criteria are to be deleted

    I have...
  13. Replies
    5
    Views
    4,611

    Thanks for the reply I sorted out the problem,...

    Thanks for the reply

    I sorted out the problem, by amending the code slightly



    For Each wbk In Workbooks
    If wbk.FileFormat = xlcsv Then
    wbk.Close
    End If
  14. Replies
    5
    Views
    4,611

    Hi ExcelFox I while back you provided me with...

    Hi ExcelFox

    I while back you provided me with code to close csv files that are open.It worked previosly, but when using it, one of the csv files won't close called

    BR1...
  15. Managed to sort out my problem. Incoming Mail...

    Managed to sort out my problem. Incoming Mail settings set up twice. Removed one and mail no longer duplicated
  16. Thanks for the info but it did work. I receive...

    Thanks for the info but it did work. I receive emails I get two emails from the same source i.e each email received is duplicated
  17. How To Stop Duplicate Incomig Emails In Outlook

    I have Outlook 2010 and recently copied my emails from my old PC on to my Laptop.

    I receive duplicate emails of all incoming emails. Please advise how I can prevent this from happening.
  18. Replies
    2
    Views
    1,103

    Thanks for the help, much appreciated ...

    Thanks for the help, much appreciated

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.eileenslounge.com/viewtopic.php?f=44&t=40455&p=313035#p313035
    ...
  19. Replies
    2
    Views
    1,103

    Macro to delete Non Duplicate Records

    I have highlighted duplicate records in Col A using Conditional formatting.

    I would like a macro to delete the rows containing non-duplicate records the are containied in Col A
  20. Replies
    10
    Views
    18,952

    Hi Excelfox Thanks for the advise, much...

    Hi Excelfox

    Thanks for the advise, much appreciated

    Howard
  21. Hi Excelfox Thanks for all the assistance,...

    Hi Excelfox

    Thanks for all the assistance, which is highly appreciated
  22. Hi Excelfox Thanks for the help, much...

    Hi Excelfox

    Thanks for the help, much appreciated. I need one more favour. I would like to delete 50 rows after the last value in Col A
  23. Hi Excel Fox I had a rethink. Where there are...

    Hi Excel Fox

    I had a rethink. Where there are Col A is blank, then the entire row must be deleted for Eg if A7 , A11 is blank then these rows must be deleted, not hidden

    I have tried to write...
  24. Hi snb & Excel Fox I have amended my code, but...

    Hi snb & Excel Fox

    I have amended my code, but when hiding the row manually and saving and then re-opening , I realised that you cannot hide a column in a CSV file as when it its re-opened the row...
  25. I will certainly give it a bash

    I will certainly give it a bash
Results 1 to 25 of 194
Page 1 of 8 1 2 3 4