Recurring Post Formula

wardy0601

Board Regular
Joined
Sep 24, 2011
Messages
117
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 expenditure to go into the relevant column on the date page

My question is, does anyone know of a formula that will allow me to start at say 15 December and automatically input a recurring wage every 7/14/30 days on the date page (depending on what frequency of payment is selected)? It will also need to stop once it gets to the date stop date on the input page

Thanks in advance.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
INCOMEDate StartDate StopDate StartDate Stop
Gross Annual Income $ 130,000.0030/12/201730/12/2047 $ 40,000.003/01/201830/12/2047
Payment CycleFortnightlyWeekly
Gross Income Per Cycle $ 5,000.0030/12/201730/12/2047 $ 769.233/01/201830/12/2047
Net Income Per Cycle $ 3,612.3130/12/201730/12/2047 $ 681.343/01/201830/12/2047

<tbody>
</tbody>

Here is what the set-up looks like on the input page. I would want the net income per fortnight in example 1 to be posted in the date page under the name of the person for the relevant date

Date page looks like this:

Row NumberDateMortgage RepaymentsPat Muzyk Income
115 Dec 2017 $ - $ -
216 Dec 2017 $ - $ -
317 Dec 2017 $ - $ -
418 Dec 2017 $ - $ -
519 Dec 2017 $ - $ -
620 Dec 2017 $ - $ -
721 Dec 2017 $ - $ -
822 Dec 2017 $ - $ -
923 Dec 2017 $ - $ -
1024 Dec 2017 $ - $ -
1125 Dec 2017 $ - $ -
1226 Dec 2017 $ - $ -
1327 Dec 2017 $ - $ -
1428 Dec 2017 $ - $ -
1529 Dec 2017 $ - $ -
1630 Dec 2017 $ - $ 3,612.31

<tbody>
</tbody>
 
Upvote 0
.
If I understand your need correctly .... this macro method will ask for "Paste the value every X rows" and then ask for the amount to be pasted.
It is hard coded to paste the chosen value in Column C (as per your example). That can be changed if required.

Code:
Option Explicit


Sub PasteEvery()
Dim j As String
Dim x As Integer
Dim i As Integer


x = InputBox("Enter every ? row to paste : " _
                 & Chr(13) & Chr(13) & "e.g: 7 for every 7th row.", "Paste Every ? Row ")


                 
j = InputBox("Enter dollar amount to paste : " _
                 & Chr(13) & Chr(13) & "e.g: $10.75 ", "Enter Dollar Amount ")






For i = 2 To 10951 Step x
     Cells(i, 3).Value = j   ' fill C2 through C10951 with the value of i
Next i
End Sub
 
Upvote 0
Thanks for the reply Logit!

I will need a formula as there are many budget items to go into each row and it will be used by our staff. Having to manually adjust all of these for each item will def result in errors and the macro being ruined.

Thanks just the same.
 
Upvote 0
All good thanks everyone, I have figured it out:

IF(AND($A14>=Inputs!$N$6,$B14<Inputs!$G$5,(MOD(ROWS($A$2:$A14)-Inputs!$N$6,Inputs!$E$3))+1=1),Inputs!$E$8,0)


<inputs!$g$5,(mod(rows($a$2:$a14)-inputs!$n$6,inputs!$e$3))+1=1),inputs!$e$8,0)< html=""></inputs!$g$5,(mod(rows($a$2:$a14)-inputs!$n$6,inputs!$e$3))+1=1),inputs!$e$8,0)<>
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

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