This is what i want to do....
1) use excel as a database table with 5 fields of information
2) for the last field or column, when i press enter a new work sheet must be automatically created and populated with information from the previous 4 columns and be ready for data entry. maybe I have not explained it well enough as i am not sure this is even possible.
thx in advance