I have the following data in worksheet named "Auto Entry"
Cell A1= X
Cell A2 =Y
Cell A3 =Z
Cell A4=Input Value(1,2,or 3)
In Cell A4 is my input value(either 1,2 or 3).All the above data including my input value are based on excel formula(Vlookup).In another worksheet named "B2JT" I,ve set a table,Cell E1 is 1,Cell E2 is 2 and Cell E3 is 3.I would like to have that when I enter "1" in A4,"Auto Entry" ws , all the data in Cell A1,A2 and A3 will automatically being transfer and arranged accordingly by column below Cell E1 (which is "1")in "B2JT" ws , when I enter "3" in A4 than all the data will go to cells immediately below E3 and when I input "2" in A4 than all data in Cell A1,A2 and A3 will be below Cell E2.
All the data which was transfered to "B2JT" ws must be in value value only without the formula from the original source.
To summarize my objective,
If A4("Auto Entry")=either E1,E2 or E3( "B2JT") insert X,Y and Z below, otherwise don't change any data which already exist below the column.