Need to add data to table in result sheets

**humacdeep** · 02-20-2012, 03:02 PM

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** · 02-20-2012, 04:32 PM

hi Humac, can you post file in question?

**humacdeep** · 02-20-2012, 04:54 PM

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** · 02-20-2012, 05:05 PM

try this:

Please Login or Register  to view this content.

PS. Not tested

**humacdeep** · 02-20-2012, 05:10 PM

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** · 02-20-2012, 05:30 PM

try this:

Please Login or Register  to view this content.

Run code "test"

**humacdeep** · 02-20-2012, 05:57 PM

Thanks a LOT Watersev... its working

Need to add data to table in result sheets

LinkBack

Thread Tools

Rate This Thread

Display

Need to add data to table in result sheets

Re: Need to add data to table in result sheets

Re: Need to add data to table in result sheets

Re: Need to add data to table in result sheets

Re: Need to add data to table in result sheets

Re: Need to add data to table in result sheets

Re: Need to add data to table in result sheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions