auto fill in cell

[ehsas]

Looking to the below excel sheet can I have a macro where can fill the automatically in the empty cells.The macro need to put look at first cell from example E3 and paste same date to E4 and E5 and then stop pasting because there is different date in E6.Here it need to put the E6 date into E7 till E11 and so on.Please if any one could help as I have 1000 of rows which some date are empty and I need to fill them.Regads,

calculation2.xls
	A	B	C	D	E
1		INSTLAMT		3698
2	PAYMENTDATE	XACT	AMOUNT/MONTH	NUMOFPYMT	nextpdate
3	13-Mar-99	PAYMNT	7396	2	25-Apr-99
4	14-Mar-99	return	0	0
5	15-Mar-99	return	0	0
6	29-Apr-99	PAYMNT	3698	1	25-May-99
7	30-Apr-99	return	0	0
8	01-May-99	return	0	0
9	02-May-99	return	0	0
10	03-May-99	return	0	0
11	04-May-99	return	0	0
12	11-Jul-99	PAYMNT	3698	1	25-Jun-99
13	12-Jul-99	return	0	0
14	13-Jul-99	return	0	0
15	14-Jul-99	return	0	0
16	22-Jul-99	PAYMNT	3698	1	25-Jul-99
Sheet2

 

[ehsas]

Could anyone help please.Thanks

 

[ehsas]

Could anyone help please.Thanks

 

[ehsas]

Could anyone help please.Thanks

 

[ehsas]

can anyone tell me i can do this.regards,

 

[PaddyD]

ehsas

a) patience is a virtue.

b) If you have waited a reasonable amount of time for a reply, consider the possibility that your original description of the problem was not clear enough (not the case here, to be fair). I leave it to you to decide what is a reasonable time to wait.

c) I might be more inclined to help if you would do me the courtesy of saying whether the solution I proposed to another of your questions was adequate for your needs:
http://www.mrexcel.com/board/viewtopic.php?topic=22573&forum=2

d) there is a solution to this that requires no macro coding & only a few button clicks...

Paddy

 

[Yogi Anand]

Hi ehsas:

Here is a formula based approach -- you don't need a macro for this .

in the worksheet simulation I show your column E with the already entered date values colored. To fill in the blanks with the date values above, this is what you do:

1. Highlite the range of interest in column E
2. then EDIT|GOTO|blanks
3. then in the active cell enter = ; click on the cell above and then ENTER while holding the CTRL key

all the blanks will be filled in with entry above as reproduced in column G of my simulation

PERSONAL.XLS
	A	B	C	D	E	F	G
1	INSTL	AMT	3698
2	PAYMENT	DATE	XACT	AMOUNT/MONTH	nextPDate		nextPDate
3	13-Mar-99	PAYMNT	7396	2	25-Apr-99		25-Apr-99
4	14-Mar-99	return	0	0			25-Apr-99
5	15-Mar-99	return	0	0			25-Apr-99
6	29-Apr-99	PAYMNT	3698	1	25-May-99		25-May-99
7	30-Apr-99	return	0	0			25-May-99
8	1-May-99	return	0	0			25-May-99
9	2-May-99	return	0	0			25-May-99
10	3-May-99	return	0	0			25-May-99
11	4-May-99	return	0	0			25-May-99
12	11-Jul-99	PAYMNT	3698	1	25-Jun-99		25-Jun-99
13	12-Jul-99	return	0	0			25-Jun-99
14	13-Jul-99	return	0	0			25-Jun-99
15	14-Jul-99	return	0	0			25-Jun-99
16	22-Jul-99	PAYMNT	3698	1	25-Jul-99		25-Jul-99
Sheet5

</SPAN>

Regards!

Yogi

 

[PaddyD]

as Yogi's determined to short-circuit my attempt to get you to answer item (C) in my above post I my as well add that you might consider doing a paste special...values on the results of the operation he described, just in case future actions (e.g. sorting) destroy the relationships set up...

paddy

 

[Yogi Anand]

Hi Paddy:

I am sorry ... I did not mean to short circuit your attempt to have the OP answer some questions. My apologies.

Regards!

Yogi

 

[PaddyD]

very definitely only joking!

post away Yogi!