Macro help required to export data

[#1]

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

[#2]

Any solution for above query?

Many thanks,

[Miguel_Angel_Baeyens]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica