Need to add data to table in result sheets

[humacdeep]

Hi,

I have data in table format in sheet1 but when I run the below code its not copying the result data in table format (in received sheet). Could any one please have a look and help me?

Thanks in advance for your help!!

Please Login or Register  to view this content.

Regards,
Humac

[watersev]

hi Humac, can you post file in question?

[humacdeep]

Hi Watersev,

I have attached the file.

The below code is adding the result sheet to table but I am unable to make it dynamic. Please help.

Please Login or Register  to view this content.

Regards,
Humac

[watersev]

try this:

Please Login or Register  to view this content.

PS. Not tested

[humacdeep]

It is working if I delete the existing Received Sheet and run the Macro and its not working when I try to run the macro with out deleting the existng sheet .

[watersev]

try this:

Please Login or Register  to view this content.

Run code "test"

[humacdeep]

Thanks a LOT Watersev... its working