Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can i run a macro to export all sheetobjects to one sheet in excel workbook (not different sheet)? NOTE: All objects have got same header.
example objects:
First | Last | Count |
---|---|---|
AB | Z | 2 |
BA | Y | 2 |
CD | X | 5 |
DA | W | 10 |
First | Last | Count |
---|---|---|
IA | K | 6 |
JK | L | 8 |
MO | A | 7 |
P | S | 12 |
So Fianl result on Excel Sheet would be
First | Last | Count |
---|---|---|
AB | Z | 2 |
BA | Y | 2 |
CD | X | 5 |
DA | W | 10 |
IA | K | 6 |
JK | L | 8 |
MO | A | 7 |
P | S | 12 |
Can someone please help me or share a macro?
Thanks,
Dinesh
Any solution for above query?
Many thanks,
Hello Dinesh,
Take a look at this post (among many others) on how to export to excel. Now you will need to add as many paste lines as different tables you have. You better use CopyValuesToClipboard from the second line on, you only need the headers once. Besides, you will need to do some tweaking to get the proper range where to paste the contents. If your tables have the same number of rows, this will be quite easy.
Hope that helps.
BI Consultant