VBA Copy And Paste

[bloodmilksky]

Hi Guys,

I was just wondering if anyone could help me with the below please.

I am looking to have all the values from column A Sheet 1 copied to Sheet 2 a1:cm1

but is it possible that once copied that the macro would run through and name that range based on the value in the top cell a1:a5 would be 1234, b1:b5 would be 5678 and so on.

any help would be greatly appreciated.

Jamie

 

[portews]

I'm not sure I understand what you want to do. You want to copy the Sheet 1 A column and paste it into Sheet 2 A thru CM? Then you want to name the range based on the value in the top row cell? They will all be identical, that won't work. Or do you mean they should be named with the pattern "1234" for the A column "5678" for B column to "364365366367" for CM column?

Please give an example of the output you're looking for, preferably in table format (see in my sig below if you need something to create tables in this forum.)