Auto populate row data with some new values VBA code require

[N Prakash]

Hi,

After a gap of few years, I have become active in a new job. I have lost touch to some extent that is the reason I need help from some experts.

I am entering a data in a row having column labels SL No., date, Text, Instrument number, amount. In another cell I mention the counter 1 to 90 and frequency ‘ daily, weekly, monthly, etc.

Depending on the counter the data should get populated with incrementing the Sl. No, and date should get incremented by frequency. The text will be same and Instrument number should get incremented by 1. And amount will be the same.

Can any one help me in giving a VBA code. I searched the forum for the same and I could not place my hand on any similar requirement.

 

[N Prakash]

Test POSTDATED.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Customer No	xxxx													Daily
2	Customer Name	xxxx		I will give a button by clicking on that 20 rows should get populated											Weekly
3	Number of Checks	20				Sl No should increment by 1									Monthly
4	Total amount of Payment					date should increment as per frequency									Half Yearly
5	Frequency Quarterly once in 3 months	Weekly				Name is constant									Yearly
6						Ch No increments by 1
7						Amount is constant
8
9
10		Sl No	Date	Name	Ch No	Amount	Status
11		1	12/9/2022	ABCD	98765	10000
12
Test

Cells with Data Validation
Cell	Allow	Criteria
B5	List	=$O$1:$O$5