Hi,
I need to make a macro that copies selective info from one sheet and pastes it in multiple sets in another worksheet. Here's what my main table looks like (column headings):

<BPC#> <MGL#> <COG ID> <Patient Initials (L,F)> <Specimen Type> <7 columns not shown> <Code>

The code given to each specimen--1, 2 or 3--will dictate how the specimen data is treated. I need to record a macro to make tube labels by taking the COG ID, Patient Initials and Specimen Type and pasting it in the separate "Labels" sheet. It should paste 10 sets for the samples coded with a "1" and 8 labels for the samples coded with a "2" or"3." Essentially, this is what I need to know:
1) conditionally copy and paste based on the code
2) paste the data a certain number of times based on the code
3) paste the data in the next blank cell and only in blank cells

I have tried different things that haven't worked and I'm getting really desperate! Please help!!

Thanks in advance,
Jenny