I did some searching and couldn't find an answer to this(leading me to believe it can't be done) but figured I'd put the question out just in case.
I'm working on a spreadsheet that contains anywhere up to 5000 rows of data. The User will input an item they wish to see into the front end and it displays the most important facts about it(via vlookup from the data tab). Easy enough.
What I'd like to do is have a blank column in the data tab that the user can put notes into. This is where it gets tricky!
I'm composing the file in 2000 but it's intended use is a PDA (for quick reference when on the floor, and the ability to take notes so they can be review in detail when returning to the desk) so it need to work on Pocket Excel which lacks many many features which would make this easy.
Given the lack of screen "real estate" displaying the actual data table is not an option. So I need to have a reference cell on the front end that ties to the user entry column and can be typed into. It need to associate itself to the user selected item.
Macro's/VBA doesn't function in pocket excel.
Yes, I know it's a tough one and I'm expecting "Sorry, can't be done" but thanks for your time and hopefully there is a creative solution!
I'm working on a spreadsheet that contains anywhere up to 5000 rows of data. The User will input an item they wish to see into the front end and it displays the most important facts about it(via vlookup from the data tab). Easy enough.
What I'd like to do is have a blank column in the data tab that the user can put notes into. This is where it gets tricky!
I'm composing the file in 2000 but it's intended use is a PDA (for quick reference when on the floor, and the ability to take notes so they can be review in detail when returning to the desk) so it need to work on Pocket Excel which lacks many many features which would make this easy.
Given the lack of screen "real estate" displaying the actual data table is not an option. So I need to have a reference cell on the front end that ties to the user entry column and can be typed into. It need to associate itself to the user selected item.
Macro's/VBA doesn't function in pocket excel.
Yes, I know it's a tough one and I'm expecting "Sorry, can't be done" but thanks for your time and hopefully there is a creative solution!