Macro to copy header row and data row in separate sheets

**aganesan99** · 03-19-2014, 10:08 AM

Hi,

I am facing a situation like, I need to copy the individual data row along with the header row in a separate sheets.

Please find attached the sample file.

Can someone help me on this.

Appreciate your help.

Thanks,
aganesan99

**Fotis1991** · 03-19-2014, 11:19 AM

Hello

Try this

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 03-19-2014, 11:20 AM

Maybe:

Please Login or Register  to view this content.

**aganesan99** · 03-19-2014, 11:28 AM

Thanks Fotis for your timely help

aganesan99

**aganesan99** · 03-19-2014, 11:29 AM

Thanks Davis for your help. Great.

aganesan99

**aganesan99** · 03-19-2014, 12:28 PM

Hi Fotis,

I have a row above the header column and it is also getting copied.

I don't want that to happen. Can you help?

Thanks,
aganesan99

Macro to copy header row and data row in separate sheets

LinkBack

Thread Tools

Rate This Thread

Display

Macro to copy header row and data row in separate sheets

Re: Macro to copy header row and data row in separate sheets

Re: Macro to copy header row and data row in separate sheets

Re: Macro to copy header row and data row in separate sheets

Re: Macro to copy header row and data row in separate sheets

Re: Macro to copy header row and data row in separate sheets

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to copy and paste based on criteria to 11 separate sheets

[SOLVED] Excel vba copy data from general sheets and organize them in separate sheets.

Copy Multiple Columns of Data from Duplicates in 1st Column into Separate Sheets

Copy and paste data to separate sheets based on mutiple criteria again

Copy and paste data to separate sheets based on mutiple criteria

Bookmarks

Bookmarks

Posting Permissions