recurring

  1. R

    Recurring Monthly Expenses

    Hello, Issue - Currently my issue is we have recurring expenses that appear every month on the same day of every month. Since we will be processing all payments on Friday we want expenses to recur every month but if the day falls on any weekday besides Friday, I want expenses to occur to next...
  2. U

    Recurring Tasks Calendar

    Hello you all! I've been looking for a way to automate a calendar that I use and as of today I fill it manually. It is a calendar of recurring tasks but they change through the weeks of the year. For example I have tasks that are on mondays every 3 weeks. Others that are monday, wednesday and...
  3. S

    Percentages not showing correctly

    Hi, First post so apologies if this has been answered before, I have a margin calculator at take into account a yearly or monthly cost, a possible install and then a sell cost, this then works out a yearly percentage of margin, for 3 years. However the percentages are incorrect and I cant find...
  4. C

    Recurring Events on Excel Calendar

    I was wondering what the easiest way to set up a recurring event on an excel calendar would be? For example I have one month on each tab. On every 2nd Saturday, I want the calendar to say Board Meeting and the cell to be filled with a purple color to stand out. Can someone help with this? And I...
  5. W

    Creat Recurring dates

    Hi, I need to automate the creation of recurring dates from the days of the indicated week, as it happens in several systems of web calendars (as is the case of google calendar) where we indicate the start date, the start time and the days of the week in which it is repeated. Do you have a...
  6. M

    Recurring expenses and using Excel for full-on accounting ledger

    Hi guys, Starting to use Office 2019 to track profit and loss (please don't digress on using accounting software). Is there any template I can use to make it easier for me? E.g. to handle different currencies, taxes, and insertion of recurring fixed expenses? Thank you.
  7. D

    Insert string based on column criteria

    r = ActiveSheet.Cells(Rows.Count, "G").End(xlUp).Row For n = 1 To r Dim s As String Select Case Range("H",”I” & n).Text Case "<>", "<>": s = "Open New" End Select If s <> "" Then Range("J" & n) = s Next Every row in Column G has a sequential valued that recurs. Sometimes the same row in...
  8. M

    Use VBA Excel userform to create an annual recurring appointment in Microsoft outlook

    TRying to make a simple Appointment that is recurring annually in outlook. Need the code to include Subject - userform (clientname) Location - userform (Address) all day event mark as unbusy Body - Multiple userform entry (Phone number-email-description) categorize orange Name of it is "Annual...
  9. ryansapp

    Weighted Avg formula issue.

    A - Client numbers (duplicates when applicable along different lines of business) K - fixed monthly number count per line of business The CAPS sheet is our monthly recurring revenue. I'm aiming to distribute that recurring monthly revenue across the (K) column IF A=duplicate paths. Having...
  10. W

    Recurring Post Formula

    Hi All, Hope everyone has had a nice Christmas and all the best for the new year! I have sheet I have built where the date and row number appears for every day for a 30 year period. There is an input page separate to the date page for all inputs to be made with results for earning and...
  11. H

    Listing recurring values in a column alphabetically and automatically AND counting the occurrence of each value

    Is there a non-array formula and not using VBA script that would automatically pick recurring values in Column A, list them alphabetically (or alphanumerically) in Column B, and count how many times these recurring values appeared in Column A and list these counts in Column C? Thanks...
  12. H

    Listing recurring values in a column alphabetically and automatically AND counting the occurrence of each value

    Is there a non-array formula and not using VBA script that would automatically pick recurring values in Column A, list them alphabetically (or alphanumerically) in Column B, and count how many times these recurring values appeared in Column A and list these counts in Column C? Thanks...
  13. S

    Removing duplicates keep the first value and the blank cells

    Hi guys! I am new to this forum. I'm having a bit of problem. I am trying to remove duplicates but i need to keep the blanks and the top values. This is the tricky part, the values recurring in a group and im trying to keep the top values on that group For example: initial...
  14. M

    Recurring Transaction for Cash Flow

    Hi i have a cash flow workbook shows weekly cashflow, i want to set up a sheet that recuring transactions can be entered into and the values returned back to corasponding fridays on our cashflow sheet, i have no idea where to start. Can anybody help? thanks
  15. K

    Creating a recurring financial transaction (e.g. monthly rent)

    SET UP: I've created a user form where a person can enter information such as the date, explanation of transaction, amount, recurrence pattern (weekly, bi-weekly, or monthly), and number of recurrences. That information is then transferred to the worksheet, changing the date by the...
  16. J

    Macro on different cells

    Hey guys, I want to run a macro that fetches data from internet pages. The URLs for these pages are located in cells, and I want to be able to run the same macro for each of these cells. I posted the code itself right now - could anyone give me suggestions on how to modify this to run down a...
  17. 4

    MS Outlook Question

    I am wondering if anyone knows how to set up a recurring email message to be automatically sent, for example: I have several employees that collect data for me on a monthly basis. This would be forgotten by some if I did not send them an email to remind them to do this each month. What I would...

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
Back
Top