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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 16, 2011 at 09:17 AM
Related:
- Copying Data To Another Worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to automatically transfer data between sheets in Excel - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 16, 2011 at 09:17 AM
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
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