Cut & paste values in range to specific sheets

**Samba1** · 06-16-2010, 03:41 AM

Hi All -

Hoping you can help me on this one, as you always do!

I've put together a simplified, dummy worksheet to help explain. In cells A4:A7 on Sheet 1 I have data validation options. The options are Product 1 through Product 4. I will only have one of each option, but they will be in random order. I also have a sheet for each product.

I need to be able to take the data from each row, and paste it into the correct sheet - all at the same time, with the click of a button. For example, A:4 is "Product 2", so B4:D4 would need to be pasted on the Product 2 Sheet.

I'm okay with copying, inserting, buttons, etc. Just not sure how to look at a range and then "sort" the data accordingly.

Greatly appreciate any help you can provide! Thanks!

KT

**pike** · 06-16-2010, 07:18 AM

Hi Samba1,
You haven't attached your dummy workbook.

**Samba1** · 06-16-2010, 01:58 PM

Originally Posted by pike

Hi Samba1,
You haven't attached your dummy workbook.

Thank you - attached.

**pike** · 06-21-2010, 07:50 PM

Hi Samba1,
Been away and missed this one

maybe something like.....

Please Login or Register  to view this content.

**Samba1** · 06-29-2010, 08:55 PM

Hi Pike -

Thank you for the code! I feel horrible that I haven't gotten back to your post, but I keep waiting for time to learn & try the code but I just haven't had time. For now, I've done fixed values instead of variable so I'm getting by. When I have some time I'll try it out.

Thanks again - Samba