Heyy, First off sorry is this is in the wrong section i don't know if this is possible with a formula/function.
I have a cell let's say A1 that updates using an api to a game. The api takes the sale value of items from the game. But now I want to keep track of the fluctuations. Is there a way to store the data from Cell A1 to Cell B1, and if it changes again store in B2 and then B3 and so on. So I get a nice list that I then can use for more fun :D.
Thanks in advance
Last edited by rhaxx; 07-07-2015 at 07:57 PM.
Give this a try..
Place it in Sheet1 code window
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thx for the quick reply.
It kinda works but only if I change the cell manually. Right now it is a formula that changes depending of the prices. But the data I want to record is a simple sum of all the total values.
So when I have the cell as a formula it doesn't trigger the macro when I change the cell by hand ( just putting in random numbers) it does work. Any idea how I can fix that?
I was afraid you were going to ask that. I did try using it with a formula in A1, but was unable to get it to work. I got lucky and found the code I posted for you, unfortunately, anything I tried with the formula in A1 did not work. Hopefully someone else will see this and know how to resolve it for you.
Thanks anywayI will wait patiently. And try another google search tomorrow
I may have stumbled onto something here. try this instead
Please Login or Register to view this content.
Awesome! It works. Thanks allot.
No problem, glad it worked for you. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks