My big summation problem.

[Hunden]

Hello guys. In my firm we buy and sell items all over the world. Therefore we need a smart system that can see how much we earn in all currencies. The result has to be shown in DKK in graph in a new workbook (3). The picture shows 2 workbooks:
http://imageload.dk/files/dbcdfd2ec50ec63fedd81cb746d787a9.JPG

1) Currencies rates.
2) The sales with the currencies.
--------------------------------

In other words: I want to create a graph (Chart) in workbook3, that showing the distribution of sales on the various currencies. It is therefore necessary that the total sales amount of each currency is calculated. After that the amounts have to be determined in the same currency (DKK) and shown in a graph


can anyone help? I will appreciate it

[Bob Phillips]

So hunden is actually the same person as gacid, even though in one post he said that he had a similar problem to gacid, and BOTH of them thanked rbrhodes for having solved the problem.

I am speechless ...

[Hunden]

So hunden is actually the same person as gacid, even though in one post he said that he had a similar problem to gacid, and BOTH of them thanked rbrhodes for having solved the problem.

I am speechless ...

No, you're paranoid. I do not know the man, and I do not know why he has the same problem. Make your own judgment, i dont care.

[Hunden]

Is this very complex and should I hire pros to help me`?

[Bob Phillips]

No, you're paranoid. I do not know the man, and I do not know why he has the same problem.

Yet coincidentally, you show pictures of identical workbooks/workbook data. Just compare the image here (http://www.vbaexpress.com/forum/showthread.php?t=23544) with the image you have just posted.

Maybe someone at MrExcel or ExcelForum will sort you out.

Edit: just noticed that they advocate formulae just as I did.


Make your own judgment, i dont care.I did, and I don't either.

[Hunden]

Yet coincidentally, you show pictures of identical workbooks/workbook data. Just compare the image here (http://www.vbaexpress.com/forum/showthread.php?t=23544) with the image you have just posted.

Maybe someone at MrExcel or ExcelForum will sort you out.

Edit: just noticed that they advocate formulae just as I did.

I did, and I don't either.

Ehh?


Okay, so I admit high court, I borrowed his pictures? Sorry. Idiot.

[rbrhodes]

Curiouser and Curiouser!

I just did this very same thing for gacid (He PM'd me and I took it off the board)

Go figure...

As for:


Is this very complex and should I hire pros to help me`?

I do a lot of what _could_ be considered 'Free consulting' on the Boards. There is a very fine line between helping people learn or overcome an obstacle to actually _working_ for them.

I try to avoid taking work away from 'pros' but that requires me to decide where the line is and how not to cross it. I also don't advertise this as the boards are meant to be free and 'Ad free' and I support that concept too.

However, sometimes a project crosses the line and becomes work so 'off the board' it goes. I don't contact people about their projects I let them decide to contact me or someone else, but I don't provide 'free consulting' per se on the boards if I feel it's a job. I don't do homework either.

Having said that I have a web page you're welcome to check out...

[Bob Phillips]

Ehh?


Okay, so I admit high court, I borrowed his pictures? Sorry. Idiot.

And you also borrowed his subject and his thread text http://www.mrexcel.com/forum/showthread.php?t=354339, which bears a remarkable resemblance to gacid's post her http://www.vbaexpress.com/forum/showthread.php?t=23649.

So, who is the idiot?

You are just a time-waster. Even wasted my time with a PM.

[lucas]

I'm looking into this Bob and rbrhodes

[lucas]

gacid and hunden are the same ip address-banned.

Multiple post in this thread also using different usernames:

http://vbaexpress.com/forum/showthread.php?t=23544