Copy and Paste rows to multiple worksheets based on a cell value.

[gaidon]

So I have been reading through the forums trying to see if this was figured out already but am having no luck. I have a worksheet that has a master page. From that page I need to look at the number in column k and then copy the entire row to a corresponding sheet in the workbook. So if 1 is in column k the entire row gets copied into sheet "1 gallon". This goes up to the number 14 so anything 14 and above gets put into the "14 gallon" sheet.

Thank you in advance for any help you can give.

[StephenR]

And are you doing this regularly or as a one-off? Will the data in your first sheet be added to or replaced? Should data in the other sheets be overwritten or added to? The code to transfer to sheets is straightforward, but would help if you could clarify these details.

[gaidon]

This sheet is used as a template on a monthly basis. So each month we just change the name of the first tab. So each month we start with a blank sheet and add in the information from a seperate sheet from another department.

[StephenR]

Try this:

Please Login or Register  to view this content.

Remove the space in 13 sheet name.

[gaidon]

Awesome thanks so much. That was a lot less code than I thought it would take.

Thanks for your help and time.