I need to design an electronic t-card board for work (for booking in jobs etc.)
We are very limited to the software I can use so it would ideally need to be done in Excel.
I want something that will look something like this:
I will need to be able to enter data manually as well as importing data from csv files.
Also if possible I would like to have cells that expand when you click on them...ie. when looking at the "board" you will see the customer name and a date but when you click on the cell it would expand to show additional data such as addresses and orders etc. (much like a t-card would look if you removed it from the board above).
Ideally I would be able to move a customer card from one column to another as jobs progress.
Is this something that is at all possible to achieve in Excel? And how would I go about it?
I am pretty confident in Excel with formulas and Pivots etc. but I just don't know where to start with this one (or how to get expandable cells)
It would need to work in Excel 2003 btw
Many thanks!!
We are very limited to the software I can use so it would ideally need to be done in Excel.
I want something that will look something like this:
I will need to be able to enter data manually as well as importing data from csv files.
Also if possible I would like to have cells that expand when you click on them...ie. when looking at the "board" you will see the customer name and a date but when you click on the cell it would expand to show additional data such as addresses and orders etc. (much like a t-card would look if you removed it from the board above).
Ideally I would be able to move a customer card from one column to another as jobs progress.
Is this something that is at all possible to achieve in Excel? And how would I go about it?
I am pretty confident in Excel with formulas and Pivots etc. but I just don't know where to start with this one (or how to get expandable cells)
It would need to work in Excel 2003 btw
Many thanks!!
