Excel VBA

[ErvinV]

Hello,

I badly need help on a file I am working on. After a VBA form, a data in row form gets copy pasted. What I want to happen is for the recently added data in row form in Sheet1 to be copied to sheet2 in column form via transpose, for it to happen over and over as I have to track a daily weekly and mo thly consolidated data. Is this possible? Thank you! 

[#2]

@ErvinV This is possible, but you may want to use a formula to bring the data into the 2nd sheet rather than copying and pasting the data, so you can avoid having 2 copies of the same data.  Otherwise, what about using a PivotTable to summarize (the weekly and monthly consolidated data)?

The formula you can use is something like =TRANSPOSE(Sheet1!A1:H1).