Copying Data To Another Worksheet [Solved/Closed]

Report
Posts
17
Registration date
Thursday March 3, 2011
Status
Member
Last seen
July 20, 2011
-
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
-
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 reply

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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