Auto updating copy of list

[DaveTurton]

Hi


I have a list 13 columns wide. It is an excel list (blue border type). This list is where the user inputs data. I want to duplicate this list on a calculation sheet which I will use to do all the things I need for the dashboard.


I was wondering what is the best way to do this. I want it so when the user types a new row into the list, the duplicate list on the calculation sheet also adds the new row and data.


Thank you

 

[SirJB7]

Hi, DaveTurton!

What do you mean by "Excel list (blue border type)"? A range of cells, a forms control list box, an ActiveX list box...

Regards!

 

[DaveTurton]

Hi SirJB7


Its where you highlight a range and go to Data - List - Create list

 

[SirJB7]

Hi, DaveTurton!

Embarrasing but I can't find it

You're talking about tables (Insert tab, Tables group, Table icon) or custom lists (File tab, Options entry, Advanced entry, Custom Lists)?

Regards!

PS: Just to synchronize dictionaries, which Excel version are you using?

 

[DaveTurton]

Ah yes - I'm on 2003 so lists but yes, tables