How to Copy Columns in Excel Using VBA. Many small businesses use Microsoft Excel for day-to-day accounting and other spreadsheet tasks. Occasionally, you might find it necessary to copy and paste ...

Using Visual Basic for Applications you can insert Excel charts into a new PowerPoint presentation programmatically rather than using the cumbersome copy-and-paste method.

To do so, copy the Excel cells, table, or worksheet. In the Word or PowerPoint document, place the cursor where you would like the Excel contents pasted and choose Paste Special.

You will definitely need to copy the "group" header info into fields for each row, or else you'll lose that information if you try to sort it.<BR><BR>Are you averse to using/writing a macro? Even ...