|You are right. I will try to be more specific with my question.|
I am attempting to get this data I have showing the revenue source of different offices. The offices going down the rows and the different sources going across so it looks something like this:
CEO Partners Associates GIF
In powerpoint I use a program called thinkcell which is basically a weaker version of excel. It does not allow me to link direct into excel with a similar formula driven from different sheets. Another problem is that I can not link cells that are not in the same range. For example I can not link A1:A7 and then C1:7 if I was trying to get the totals of different regions or something like that. Because of that I need to put everything in the same range in excel.
I have to update this every month and to date I simply do it manually. It is not terrible but it leave room for errors and it annoying when I know there are faster ways of doing this.
The data comes from a report that I run which I then copy into excel. That data has the office names and revenue sources in a format that I can not use on the chart. I used a vlookup to give me the right way I want the office to be name but have not done so for the revenue sources. I am considering doing the same for that but was wondering if there would be another way.
After I do that I need to find a way that take the revenue in ny from GIF from the data ect ect
Is this possible?
I hope that makes some sense. If you have any questions please do not hesitate to ask. I will try my very best to clarify. Any assistance would be greatly appreciated. You guys truly have a gift.
I am only in year 1 of excel and am completely overwhelmed with VBA but I am trying to learn the best I can. If you have any tips or good places to start learning feel free to let me know.