Autofill and Reverse Autofill

[DocAElstein]

Hi
( Probably the word “Autofill” is not so good for this, since it is a bit miss leading: In Excel Auto Fill has a specific meaning) .

The solution I am thinking of for you is quite easy, but needs a bit of typing in of a lot of text.
So I will do the solution to work on just the first 3 rows using the first 5 rows of data in the Reference Chart. See if you can modify the macro to work for all the rows and data. If you have difficulties, let me know, and then I can complete it all for you in a day or so.

It is also a bit easier to explain the solution for others in the forum if I use a smaller data set.

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 )

Row\Col	B	C	D	E	F	G
2	S. No.	Alpha Code	Sex	Category	Area
3	1
4	2
5	3

Worksheet: Sheet1
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, as per the REFERENCE CHART
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 be filled in the corresponding cells automatically
Now, similarly, same condition is applied to cell C4, C5, ….. 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 )

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

Worksheet: Sheet1

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