Thanks for the help, much appreciated
Type: Posts; User: Howardc
Thanks for the help, much appreciated
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
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.
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...
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...
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,...
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...
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,...
Hi Excel Fox
Thanks for picking this up. I have amended the values and it now works perfectly.
Once again thanks for your help
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...
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
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...
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
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...
Managed to sort out my problem. Incoming Mail settings set up twice. Removed one and mail no longer duplicated
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
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.
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
...
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
Hi Excelfox
Thanks for the advise, much appreciated
Howard
Hi Excelfox
Thanks for all the assistance, which is highly appreciated
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
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...
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...
I will certainly give it a bash