Match column between two sheets and copy row format once column number matches

**kapil** · 07-30-2010, 07:09 AM

Hello,

Can someone look at the below code and tell me where I am making mistake. I have written this code to match a column between two tabs "Main" and "Backup". If the column number matches, the code should copy the row formatting of that column number from "Backup" sheet to "Main" sheet.

Currently, it is copying the formatting from "Main" sheet to "Main" sheet itself. Dont know where I am making mistake. Thanks.

Please Login or Register  to view this content.

**vikas.bhandari** · 07-30-2010, 07:21 AM

Hi there!!

I tweaked your code a little, and it is working fine now. Please use the following code :

Please Login or Register  to view this content.

Thanks,
Vikas

**kapil** · 07-30-2010, 07:51 AM

Thank You Thank You Thank You so much Vikas.

Really Appreciate your help

**vikas.bhandari** · 07-30-2010, 07:54 AM

Anytime

Please ensure to mark it solved!!!!!!

Vikas

Match column between two sheets and copy row format once column number matches

LinkBack

Thread Tools

Rate This Thread

Display

Match column between two sheets and copy row format once column number matches

Re: Match column between two sheets and copy row format once column number matches

Re: Match column between two sheets and copy row format once column number matches

Re: Match column between two sheets and copy row format once column number matches

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions