Macro Help:VBA

[Puppies72]

Hi all,

Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I need a macro to update some data – can’t use vlookup as the data isn’t sorted the way vlookup requires it to be:<o></o>
I am copying data from sheet ‘Validator’ to sheet ‘Ships’<o></o>
The macro needs to do the following:<o></o>
Locate the value in Validator!BD7 then find that value in sheet Ships! Column A, note the row number<o></o>
Then copy Validator BI7:BZ7 and paste values only to sheet Ships!F:W at the row in which the value in Validator!BD7 was found <o></o>
Then it needs to start the whole thing again at Validator!BD8 and continue until a blank cell is found<o></o>
Any help would be greatly appreciated

thanks in advance as always

 

[Puppies72]

Hi all,

I am starting to piece together the code for this myself based on previous macros and code snippets I have, however...

can someone show me the code necessary to find the value from Validator!BD7 in Ships!column A

many thanks

 

[VoG]

Hi. This will give the row number or an error if a match isn't found.

rw = Application.Match(Sheets("Validator").Range("BD7").Value, Sheets("Ships").Columns("A"), 0)