So my solution, which I will give in the next post will solve this problem, which is your problem shortened.
_____ Workbook: Autofill.xlsx ( Using Excel 2007 32 bit )
Worksheet: Sheet1
Row\Col B C D E F G 2 S. No. Alpha Code Sex Category Area 3 1 4 2 5 3
Case1
If I paste or enter A in cell C3, then, automatically put the value…
BOY in cell D3, GEN in cell E3 and URBAN in cell F3
Similarly,
If I paste or enter B in cell C3, then, automatically put the value…
BOY in cell D3, OBC in cell E3 and URBAN in cell F3
Similarly,
As shown in REFERENCE CHART)
the corresponding value should filled in the corresponding cells automatically
Now,
Similarly,
same condition is applied to cell C4, C5, C6 and so on
that is,
If I paste or enter A in cell C4, then, automatically put the value…
BOY in cell D4, GEN in cell E4 and URBAN in cell F4
_____ Workbook: Autofill.xlsx ( Using Excel 2007 32 bit )
Worksheet: Sheet1
Row\Col R S T U V W 1 REFERENCE CHART 2 S. No. Alpha Code Sex Category Area 3 1 A BOY GEN URBAN 4 2 B BOY OBC URBAN 5 3 C BOY SC URBAN 6 4 D BOY ST URBAN 7 5 E GIRL GEN URBAN
Case2
If I paste or enter BOY in cell D3, GEN in cell E3 and URBAN in cell F3
then, automatically put the value A in cell C3
Similarly,
If I paste or enter BOY in cell D3, OBC in cell E3 and URBAN in cell F3
then, automatically put the value B in cell C3
Bookmarks