old thread - details lost

[gin2334]

Hi All,

A long long time ago I posted a note asking for help with a camera tool which someone helped with and gave great details on how to help, Sadly, my PC is bust and all my Excell queries that you've helped with are gone (and I cant find it on here anymore)

In short, on dynamic Dashboards, there was a cool trick where you could use the camera tool to select and area, then on a new sheet. have a setup where "if the number 1, is put into a cell, a graph appears in a selected area, if you put number 2, it shows a table instead"

I remember it was something to do with naming a range but I cant remeber how the whole process works.

Can anyone help?

Well gutted I lost all my hints and tips

 

[riaz]

Is this it?

http://www.mrexcel.com/forum/showpost.php?p=1423115&postcount=1

You can click on your own name and find all your old posts. That's how I found your camera post.

 

[kgkev]

http://www.mrexcel.com/forum/showthread.php?t=289882

 

[gin2334]

Yeh I found that but the answer I was given wasnt there ? The post that the 1st guy left wasnt the one that solved the problem.

Any ideas how it work?

Giod you guys are quick at responding :O)

 

[kgkev]

http://www.mrexcel.com/forum/search.php?searchid=975981


This shows all the threads you have posted in.

 

[gin2334]

ha, you can tell im a novice on this cant ya!!!!

Bizzare, it isnt there still............ its no biggy guys, just wanted to get it back cos it was cool,

if no-one knows how it works i'll just have to play on the net to find it.

ooh, how the hell did you find all my threads, help an idiot lol

 

[kgkev]

Click search at the top

Advance Search

Then all threads by member.

 

[gin2334]

if anyone is interested I found how to do this on the web at


http://www.exceluser.com/solutions/traffic.htm

works like a treat and looks pretty cool.

Cheers guys