Copying Data To Another Worksheet

Solved/Closed
azmiismail Posts 17 Registration date Thursday March 3, 2011 Status Member Last seen July 20, 2011 - May 16, 2011 at 04:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 16, 2011 at 09:17 AM
Hello,
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.

Can somebody help me out please.

Thanks

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 16, 2011 at 09:17 AM
Hi azmiismail,

See if these formula's yield the desired result:

Sheet B2JT
E2: =IF('Auto Entry'!A4=1,'Auto Entry'!A1,"")
E3: =IF('Auto Entry'!A4=1,'Auto Entry'!A2,IF('Auto Entry'!A4=2,'Auto Entry'!A1,""))
E4: =IF('Auto Entry'!A4=1,'Auto Entry'!A3,IF('Auto Entry'!A4=2,'Auto Entry'!A2,IF('Auto Entry'!A4=3,'Auto Entry'!A1,"")))
E5: =IF('Auto Entry'!A4=2,'Auto Entry'!A3,IF('Auto Entry'!A4=3,'Auto Entry'!A2,""))
E6: =IF('Auto Entry'!A4=3,'Auto Entry'!A3,"")

Does this suffice or did you want to insert 3 rows containing the data from "Auto Entry" below either E1, E2 or E3?

Best regards,
Trowa
0