Hi everyone, need help on writing this macro:

I need something that will copy a set range (well say A1:A10) on "Tab A" and paste transpose on columns A to J (all in the same row) on "Tab B"

Finally I need the macro to paste to the next avaliable line. So the data in A1:A10 changes daily and the idea is that you every morning you open the file, updat ethe data which changes the value in A1:A10 then press this macro button which will paste the data in columns A to J on the next avaliable row.

I am using it for an automated metrics system that keeps historical data by clicking a button.

Thanks in advance for any help.