I don't have any code yet to show on this one. Basically, I want to take pivot tables from two different spreadsheets and paste their values and formats, plus a title for each, into another spreadsheet that already has existing data. Each table is only 4 columns wide, so can (and should) fit side by side. I know how to copy and paste, and think I can figure out how to create a title, but I don't how to do the pasting side by side (ideally with a column in between). Here's a rough sketch of the how the finished product should look:
Row 1 BlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBla
Row 2 MoreBlaMoreBlaMoreBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBlaBla
Skip 2 rows
Pivot Table 1 Heading----------------- Pivot Table 2 Heading
Pivot Table 1 Values ----------------- Pivot Table 2 Values
Skip 2 Rows
More Bla (later pastes)
Any help is greatly appreciated.
Bookmarks