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]

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

When I am doing edit/goto there is no blanks and number 3 is not clear.regards,

 

[PaddyD]

In the sample data you posted, there were blanks in column E. The challenge was to fill them. If you no longer have blanks in col E, what do you have there?

Paddy

 

[ehsas]

Thanks Paddy,I have been able to do same.Is there another way of filling the empty cell.

 

[PaddyD]

There are a number of other ways - but if this one works, why would you want them??

Paddy

 

[ehsas]

In above way I have to highlight all the blank cell and then apply the criteria.I am looking for easiest way.Please help.Regards,

 

[PaddyD]

In terms of keystrokes required, it is the easiest way!!

Paddy

 

[ehsas]

PADDY IS THERE ANY OTHER WAY.PLEASE HELP

 

[PaddyD]

could you give an indication of why this method isn't acceptable?

Paddy

 

[ehsas]

This method is fine but time consuming I have the excel file which has 6000 rows and there is dates in between the rows which i need to manually select the ranges and then do the exercise and if you don't stop between next date then there is chance of errors of copying the last stop points.Please help if you know any other method.Regards,