How to Copy Two Separate table (with Different Fields) and transfer to dedicated sheet?

[ivandgreat]

[h=2]

[/h]

Hi,

I'm new in excel programming and I'm seeking to all gurus out there to help me about my excel problem.

I have two different table in one single sheet (Sheet1) which is separated to each other from a single row with there respective fields. I want to copy each table without the header and transfer there rows to each respective excel File (XFile1 and XFile2).

Hope your support about this.

br,​