recurring

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...