help with an excel file

[Alan Lowbands]

Hi guys,
I know this is off topic but does anyone know how to fix this file?
Looked online but none of the macro's I could find helped and I couldn't get the number to the clipboard or add it too the list.

any help would be appreciated.

cheers
Alan

 

[LWolf]

Dim a As Variant
a = Cells(x, 1).Value
Cells(x, 2).Value = a

regards,
LWolf

 

[Alan Lowbands]

Thanks LWolf,

Sorry for the late thanks. Got side tracked

much appreciated

regards
Alan