Best way to link/mirror data between sheets while using Application.OnTime

[fepiz]

Hi everyone!
Using Excel 2010,
Im looking for the best way to present data from e.g. sheets 1-6 on sheet "main", one sheet at a time with a time range in between
using Application.OnTime. Right now im just using copying and pasting ranges using VBA in between the time ranges.

(I dont have any documents with me right now, can paste it later though)
E.g.: On a range starting on A1 on sheet "main", the macro starts by pasting a range from sheet 1, 30 seconds later it copies another range from sheet 2
and paste it on the same place, A1 on sheet "main", on so forth... until getting to the last sheet and starts from the beginning.

Something tells me there should be a another way.

How would you solve this matter, is there a "better" way?

Thank you in advance,
Regards

Felipe

 

[pgc01]

Hi Felipe

Can you give some more information, namely

- does the data that you show on Main fit in 1 page?
- is the data you show on Main always the same size (same rowsXcolumns)?
- do you work on the data shown, or the data is just to be looked at?

I'm asking these questions because a very simple solution would be to display the image of the data with a picture.

 

[fepiz]

I've playing around with that option and its pretty useful. I have six images of six different tables (one has to fill with colours to cover transparency) on top of eachother covering the same amount of cells and I bring them forward or front with VBA after a time cycle (Application.OnTime).
The only thing left is that the quality of the image seems a bit low, even though I've changed the option in the settings...
1. Yes, fits page.
2. Always the same size (rowsXcolumns), just different data on each sheet
3. I plan to have work on the data shown (on each sheet)

This option works much better than the one I used before. Because I adapt size of cells much easier independently of other content on sheet "main"

Great!

Thanks alot!

Regards
Felipe

 

[pgc01]

Hi Felipe

I'm glad it helps, but ... that's not what I was going for .

I was thinking of just having 1 picture in the Main sheet and simple change its formula.

Try this simple test

- Insert a picture (any picture) in Main

- select the picture and in the formula bar write
=Sheet1!A1:D15

Resize it if you want.

You'll see that now the picture displays what's on Sheet1!A1:D15. If you change the formula to =Sheet2!A1:D15, you'll now see what's on sheet2.
This means that you just need 1 picture in Main and the only thing you have to change with the OnTime() is the picture formula.

Remark: the picture will always reflect the value in the source. If you change a value in the source range the picture updates automatically.

 

[fepiz]

I was a little bit too hasty there and didn't pay enough attention to what was going on with the functionality! It was what I really needed!
Second time around; Thanks alot!

Regards
Felipe

 

[pgc01]

You're welcome. Thanks for the feedback.