Copy and paste conditional data to new worksheet

I am new to macros but I know that it will make my life easier if I can get this working properly.

I have some data ('Master' worksheet) with a specific SKU in column C and for each SKU I have a worksheet. I would like a macro to filter the data and copy/paste all the rows with the given value to the appropriate worksheet (so all the rows with a code value of 1.1 get copied to the 1.1 worksheet). I've attached sample data. Also, I do not want the titles copied, just the data.

Thank you in advance for any help!

I should probably add that for my real data, I have 74 SKUs and I have a separate worksheet for each one.

Hi emq,

Try with:

Please Login or Register  to view this content.

Hope this helps,

Regards.

Thank you. Works on the sample data, will try it shortly on the real stuff (then mark this solved).

This isn't working with my actual spreadsheet/data.

I can't think of what the difference would be between my sample and my actual data.

I'm getting an error as follows: "subscript out of range"

and it points to this row when I debug

m = Worksheets(ShtName).Range("A" & Rows.Count).End(xlUp).Row


Any ideas?

That being said though, while I am getting that error the macro does seem to be executing the correct steps and copying/pasting the data. So I am not sure if that error is a problem or not.

I'm still unable to use this on my real data and I can't figure out the difference between it and my sample data.

Any thoughts?