I'm working on a excel program that will allow my Construction business to electronically database our bid system. My idea is to have a main page in excel that will have columns labeled Date, Due Date, and Job Name. Every time a job is going to be bid we add it to this sheet.
From here I need to have the JOB NAME entered manually to be automatically copied(by code or if/than) to another sheet Alphabetically(Other sheets will be A,B,C,D,E,F,G all the way to Z.
Therefore if I enter Trump tower on the Main page it will copy it over to the "T" page automatically.
If I enter Airport on the Main page it will copy it over to the "A" page automatically
If there is a way to do this let me know.
2007-11-28
14:38:14
·
3 answers
·
asked by
tfoster1107
2