Retrieving value from another sheet based on column

Hello guys,

I've been working on a macro (with the help from this forum) that condenses data from multiple ranges to a new sheet. I'm almost done with the macro but I'm stuck on this one final part.

I've attached an example but I'll explain the scenario.

The raw datasets are in ranges that are 3 columns wide.
the macro so far lists all the unique instances in the first sheet into one range.
What I'm having trouble with is grabbing the counts from the ranges in sheet 1 to the condensed range.

Can anyone point me in the right direction??

Also, if anyone wants the macro I have so far, I would be glad to share it.

kookymonster

Would you mind re-attaching the workbook with the code. It probably could be modified to do what you want.

Thanks for taking the time to take a look.

This is the code I have so far. Everything up to
" 'Gets counts from sheet 1" works. After that, i've just been trying out different things with no success

Please Login or Register  to view this content.

Here is one way to move your data?

Please Login or Register  to view this content.

...

Here you go,

I attached a workbook so you can see how it works. This code will loop through any amount of ranges you have in your workbook and transfer the data.

You may have to fiddle with the sheet names a bit I have them set as
Sheets(1) 'Get Counts
Sheets(2) 'Moving Counts

I also noticed you have another version of excel so you may need to edit the .row and .columns because your verson has more rows and columns than mine.


Here is the code:

Please Login or Register  to view this content.

...

Hope it helps ,Post back any issues.