Modify code to also transpose data into table

[Butcher1]

I have the following code which will copy and paste various things from the Calculator sheet into the Journal sheet. In addition to that, I need Caclulator!R2:243 copied and pasted as values and transposed into the Data sheet, specifically into the table that starts at A1.

Thank you much!

Please Login or Register  to view this content.

[vba_php]

just copy the range, paste it on the other sheet and transpose it by writing the function in the top level cell only, I think. you need these:

https://docs.microsoft.com/en-us/off...l.range.select

https://docs.microsoft.com/en-us/off...cel.range.copy

https://docs.microsoft.com/en-us/off...e.pastespecial

https://support.microsoft.com/en-us/...9-4b6dfac76027

[sintek]

Caclulator!R2:243 copied and pasted as values and transposed into the Data sheet, specifically into the table that starts at A1.

Please Login or Register  to view this content.