Comparing Data: Multiple Variables

**jomili** · 04-28-2010, 12:55 PM

In the attached file are two spreadsheets. On the "Former_Workspace" worksheet, in a former thread (http://www.excelforum.com/excel-prog...ring-data.html) SHG gave me a great macro to line up the two sets of data (columns A:B and D:F) so I could figure the differences in the Position Function Code totals. That macro is below, and works very well.

I've complicated things by adding another field, the PAC (Program Area), as you can see in the "Workspace" tab. Now I need to line it up by PAC, and within PAC by Position Function code. I tried using the same macro by naming the "Keys" range to include the PACs, but all that did was wipe out the PACs. So, I need help yet again. Any help you can provide to do my comparing would be greatly appreciated.

Please Login or Register  to view this content.

**jomili** · 04-29-2010, 09:36 AM

Bump. Still needing help.

**jomili** · 04-30-2010, 09:24 AM

Rebump. Still need help on this one.

**jomili** · 05-03-2010, 02:20 PM

Re-rebump. I'm stuck, stymied and frustrated, and could really use some help.

**jomili** · 05-04-2010, 04:39 PM

Still stuck, still in need of help. No replies yet. I have a solution that I THINK may work, but haven't tried it yet. If I concatenate columns A and B, and Concatentate D and E, I could then delete those columns, use the concatenated values in the original macro to sort, then recreate my deleted columns by un-concatenating. Seems like a long way around, but absent of a better idea that's what I'll try.