A chart that is updated per hour

[Artpop12]

Hello!
I'd be happy if anyone of you could help me!

I would like to make a chart with about 100 or so cells. I want each cell to be updated per hour.
Lets say:

Cells
2
4
6
9

I want every cell's number to grow (+1) per hour.

So it'll look like this after 1 hour.

Cells
3
5
7
10

Is this possible? How can I do it?


Thank you very much for anyone who's willing to help

 

[Artpop12]

Bumping

 

[Artpop12]

I hope it's possible in Excell!

 

[Artpop12]

bumping

 

[Artpop12]

Also, i must add- it doesn't only have to be updated per hour. It can be per 5 minutes, 10 minutes, whatever that fits

 

[Artpop12]

If someone wants to pm me, you're more than welcomed!

 

[Artpop12]

bumping

 

[Fishboy]

Hi artpop, I've just responded to your PM. the long and short of it is yes, this can be done using VBA but you catch me as I left the office for the weekend so I will not probably get a chance to look at this for you until Monday.

just a word of advice, there is a handy thing at the top of the forums called zero reply posts. A lot of the gurus go straight here to try and help people yet to get any responses. But by bumping your thread even once, you no longer show in that section as there is technically a reply to your post. You're much better off just waiting it out til someone replies (especially if it has only been one day, let alone a few minutes!)

 

[Smitty]

Welcome to the Board!

Please don't bump every few minutes. If you don't get a response you might want to consider if you've given enough detail.

 

[kbend3r]

Hi Artpop12,
I am not one of the Excel geniuses. Unfortunately. I wish that I could help you. Good luck in finding your answer.
Kim