VV-BadSoden
New Member
- Joined
- Nov 22, 2010
- Messages
- 1
Hi,
I now looked throughout the net for days and haven't found a sloution for my problem. Here a short explanation.
What I want:
To show my coworkers and colleagues a graph of development of the actual sales on the actual day to see were are we going.
What do I have:
I have a Excel file which is connected to another Database gets an updated Sales Figure every two minutes and this Data for example is written in cell A1 in worksheet turnover. And it will always overwrite the old Data in Cell A1
What could be the solution:
I think there are two ways how to solve it.
The first way could be a formula or VBA that takes the actual sales into a graph before overwriting the old one.
The second could be the solution how I tell excel to write the first received figure in A1 and after that continue to the next cell (A2,A3,A4.....) both would be a great help for me.
If somebody has an Idea how to solve it with VBA, I would need the complete code, I am quite good in Excel but haven"t done so much VBA programming so far so just a part of the code or the command do not really help me
Thanks a lot in advance for helping
BR from Moscow
Volker
I now looked throughout the net for days and haven't found a sloution for my problem. Here a short explanation.
What I want:
To show my coworkers and colleagues a graph of development of the actual sales on the actual day to see were are we going.
What do I have:
I have a Excel file which is connected to another Database gets an updated Sales Figure every two minutes and this Data for example is written in cell A1 in worksheet turnover. And it will always overwrite the old Data in Cell A1
What could be the solution:
I think there are two ways how to solve it.
The first way could be a formula or VBA that takes the actual sales into a graph before overwriting the old one.
The second could be the solution how I tell excel to write the first received figure in A1 and after that continue to the next cell (A2,A3,A4.....) both would be a great help for me.
If somebody has an Idea how to solve it with VBA, I would need the complete code, I am quite good in Excel but haven"t done so much VBA programming so far so just a part of the code or the command do not really help me
Thanks a lot in advance for helping
BR from Moscow
Volker
