VBA Cutting and Pasting from one worksheet to another based on value

Hi All,

I am almost there! I have code finding a value (Label5) from userform5 and finding that value in a spreadsheet (Pipeline) then cutting that row.

Where I am stuck is how to then get it to paste that data in the last row of worksheet (B&P Archive). I cant seem to apply anything I've found searching to my instance. I am also going to have it do the cut and paste in another worksheet that's why you see the SS designations.

Thanks in advance!

Here is what I have so far:

Please Login or Register  to view this content.

worked perfectly! Thank you!