Macro based on Cell Data-Copy to Specific Location on Different Sheet

Stuck on some code....

Currently Cell Z2="Line1".

I would like to write a macro that says essentially if Z2="Line1" copy cells Z1000:Z1200 and paste into Cell A1 on Sheet titled "Sheet1".

If Z2="Line2", copy cells Z1000:Z1200 and past into Cell B1 on Sheet titled "Sheet1"
If Z2="Line3", copy cells Z1000:Z1200 and past into Cell C1 on Sheet titled "Sheet1"
On through "Line100"

Any suggestions? Thank you!!

Hello
Maybe something like the following code would work for you:

Please Login or Register  to view this content.

Not sure how you wish to trigger this but it could be a Worksheet Event or Form/ActiveX control. Range Z2 would need to have some validation of a correct input, for example a drop down with: Line1; Line2 etc.

DBY