Forum Discussion
Excel Formula Help
mathetes Hi; Data entry will be manual like adding new addition date; then adding activity end date, which will help to get next activity start date and so on till termination... I would love to sort this by activity date as every month need to generate a month activity report and revenue report out of it... I can add another sheet and can use VLOOKUP to get new addition date into the formula... Rest all data will be here...
You wrote: Data entry will be manual like adding new addition date; then adding activity end date, which will help to get next activity start date and so on till termination...
Which doesn't yet make it clear. Of course you add new data by entering an ID, an activity description, and a date. The question was aimed at how the table is maintained, which wasn't so much what data are entered--that's pretty obvious--but whether or not you enter each transaction at the bottom of the table, regardless of which SAN ID it is, or do you insert a row in the section for the given SAN ID?
Let me take a few minutes to create a mock-up for how transactional databases are generally laid out, with an example of what could then be created as an output report.