Repeating or Recurring Entries

MinniMaz

New Member
Joined
Jul 31, 2017
Messages
1
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 :)
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,808
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top