recurring

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  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. 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...
  13. 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
  14. 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...
  15. 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...
  16. 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...

Some videos you may like

This Week's Hot Topics

Top