Problem with adding differents codes to unique numbers within columns: VBA or maybe not ?

[jaryszek]

Hi Excel Gurus,

how are you ?

I'm writing to you because i have problem connected with pulling out data.


I have two sheets: Base and Result.

In Result sheet i have number, sum (if there are 2 possibly values in sheet Base my macro is summing theirs contributions, for example:
77060620150 in base has duplicate in column A so my macro summed up its sums in Result sheet. (2916,63 + 1579,13 from Base = 4495,76 in Result)
and Difference.

The problem is that i have got a request to add also unique codes for each number from Base sheet.
In my example 77060620150 has 2 codes: 110 and 411 and i want to assigned them to Code columns (there will be max 3 kind of codes) in Result sheet.

Do you have any idea how to do it in VBA or without it?
This seems for me very difficult.

Thank You for your help,
Best Regards,
Jacek Antek

[jaryszek]

Hi Guys,

i have found the solution - the best !

Please Login or Register  to view this content.