Hi all,
Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><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
Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
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
I am copying data from sheet ‘Validator’ to sheet ‘Ships’<o
The macro needs to do the following:<o
Locate the value in Validator!BD7 then find that value in sheet Ships! Column A, note the row number<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
Then it needs to start the whole thing again at Validator!BD8 and continue until a blank cell is found<o
Any help would be greatly appreciated
thanks in advance as always