Paste to next blank row?

All,

I have several sheets that all have 4 columns of data in.

I want to copy the data and paste it into one master sheet.

So I need code to copy the first sheet > paste into master then copy the second sheet and paste into master but just below the sheet1 stuff we just pasted and so on etc etc

I've tried using

Please Login or Register  to view this content.

but couldn't implement the code correctly...any ideas?

Please attach a sample and will write you a better code. Go to advance then attachment

Boom that worked! Thanks guys, perfect!

This happens to work perfectly for my purposes as well - but I need to Copy Paste/Transpose to the Master sheet. Is there a tweek you can provide me???
Thanks in advance!

dingo,
You need to start your own thread!