Hi,
I don't known if the message is to go to Ayush, if it is, please Ayush,
could you remove files sent to the discussion's subject since it seems to
be files with confidential infos.
Please find the user request below. If it's not Ayush, could someone else
in charge of the forum do it?
Regards,
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 bpascal...@gmail.com wrote:
Hi Trawets,
Find your workbook attached, it should do.
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
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 bpascal...@gmail.com wrote:
Please find the code below with
Hi
I have a standard work book with 3 sheets , in sheet 1 2 there is
data,
in a column of sheet 1 there are a list of values, 10 digit string
with letters and numbers these values may or may not match values that
are contained in a column in sheet 2, where there is a match I would
like to copy
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
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