Forum Discussion
Excel VBA
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 ...
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).