How to write matched results to a specific cell.

**shart2k12** · 01-09-2013, 12:40 PM

Hi,
The following routine compares the values in column "K" to cells in "A2:F17", if there is a match, matching cells would be colored. How and where do I insert a line to write the matched cells in cell "M2" for example? Values are numbers.
Your help is appreciated.

Please Login or Register  to view this content.

Thank you for your help.

**Jakobshavn** · 01-09-2013, 12:53 PM

Please Login or Register  to view this content.

**shart2k12** · 01-09-2013, 03:52 PM

Hi,
Thank you for your reply.
This works, but it overwrites the values on top of each other and only the last value from "A1:F17" is shown in "M2". How do I modify it so it writes all the values in "M2" separated by a dash or space?
Thank you again.

**Jakobshavn** · 01-10-2013, 09:01 AM

Here is the new version:

Please Login or Register  to view this content.

**shart2k12** · 01-10-2013, 09:50 AM

Thank you Jakob. Perfect.
Your help is highly appreciated.
Sam

**Jakobshavn** · 01-10-2013, 10:17 AM

Thanks for the feedback!

How to write matched results to a specific cell.

LinkBack

Thread Tools

Rate This Thread

Display

How to write matched results to a specific cell.

Re: How to write matched results to a specific cell.

Re: How to write matched results to a specific cell.

Re: How to write matched results to a specific cell.

Re: How to write matched results to a specific cell.

Re: How to write matched results to a specific cell.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions