I am looking to see if there is a way to automatically add repeating/recurring entries to a database in Excel. For example, currently we use a calendar (calendarwiz) to enter and track jobs that come in, not time specific, but location/stop sequence order, we select all day (this isn't important as we manage this in a map app), but 90% of our jobs are recurring, either weekly, twice weekly, two weekly, 4 weekly, 3 monthly etc). The calendars can manage this, with the option of altering the repeating series, or the single event without changing the series. but I can not find a database that can do this, so trying to build one in excel, if possible. At the moment each week I import the calendar into excel and manipulate the data into columns, like customer, asset number, completed etc... Trying to eliminate all the multiple data handling.
And to add an extra head ache, I would like to be able to display the database into a calendar format, for the field guys to be able to look at in a glance. I could probably have a hide column that combines multiple columns to populate the calendar with the job details. Is this possible? Pivot table that returns text values would be nice, but from what I can find, it is not possible.
And just to add to the headache, something that can be viewed in mobile app, or Office 365 online.
Hope I'm not asking too much.
Thank you
And to add an extra head ache, I would like to be able to display the database into a calendar format, for the field guys to be able to look at in a glance. I could probably have a hide column that combines multiple columns to populate the calendar with the job details. Is this possible? Pivot table that returns text values would be nice, but from what I can find, it is not possible.
And just to add to the headache, something that can be viewed in mobile app, or Office 365 online.
Hope I'm not asking too much.
Thank you
