copy down based on next column value or criteria

[dvsdasari]

Hi,


I have a worksheet containing 1000 columns with lot of data. The data in worksheet as follows..


AB (columns)

(1,2,3,4 is rows)

1 Voucher No Narration

2 001 testing for excel

3

4

5 002 sales in south division

6

7

8

9

10 003 sales in north division

11 004 others


The data final report should be..

AB (columns)(1,2,3,.. is rows)

1 001 testing for excel

2 testing for excel

3 testing for excel

4 002 sales in south division

5 sales in south division

6 sales in south division

7 sales in south division

8 sales in south division

9 003 sales in north division

10 sales in north division

11 sales in north division

12 004 others


Upto next voucher starts in column "C" above narration should copy down,if new voucher no starts it should takes that particluars narration up to next voucher no.


please let me know if you people need more info on this.


Thanks-Sekhar

 

[NARAYANK991]

Hi Sekhar ,


See if the following is of help :


http://www.contextures.com/xlDataEntry02.html


Narayan

 

[Montrey]

Sekhar,


Highlight the column the data is in. Press F5-->Special--->Blanks. Then in the first blank cell, input =ab1, Then Press Ctrl+Enter.