Again I must say, Pascal you have been extremely kind in spending your
time with this, it is very much appreciated I am now going through the
code trying to understand,
Thanks and very best wishes
Stewart
On Mar 4, 9:08 pm, bpascal123 wrote:
> Please find the code below with comment, although it
Please find the code below with comment, although it is a little erratic...
It's really a basic pattern matching.
I assume G3198/3 is not the same as G31983 or 000G3198/3 or else...
Sub CompareCopyPasteByeBye()
'''DECLARE VARIABLES FOR OBJECTS AND ELSE
Dim wbk As Workbook
Dim wksA As Worksheet
Thanks for the code and having tried this it works well, would it be
possible to comment the code so I could follow it step by step and
maybe try understand whats happens and when
On Mar 4, 2:55 am, bpascal123 wrote:
> Hi Trawets,
>
> Find your workbook attached, it should do.
> Please check the
Hi Trawets,
Find your workbook attached, it should do.
Please check the accuracy, since your data there are symbols and other
stuff in your data, it could match data that don't include dashes or
slashes... and the code below should be tweaked.
I think you can run it from the vba editor window or a
send a file
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: trawets
Sent: Saturday, March 03, 2012 12:51 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Macro to compare highlight and copy value to a new
sheet
Hi
I have a s
