Code to select dynamic range based on value in column A

[tompee29]

Hi Guys,

Hoping you can help.

I just need some code to select a range of data based on a value in column A then copying this data to the clip board.

Value in column A will either be 0 or 1. If it is a 1 then i need this data copied.

So on the attached sheet the data selected and copied would be range A1:K57

Test sheet attached.

Many thanks in advance.
Tom.

[berlan]

Try:

Please Login or Register  to view this content.

(output will be in pasted in A1 in Sheet2)

[tompee29]

that's great thanks.

Do you know what the code to just select the data range then set as print area??

Many thanks,
Tom