Macro to copy paste in excel
Closed
ujo
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
-
Jul 22, 2009 at 11:32 PM
Trowa - Jul 24, 2009 at 08:54 AM
Trowa - Jul 24, 2009 at 08:54 AM
Related:
- Macro to copy paste in excel
- Excel online macros - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel run macro on open - Guide
- Number to words in excel - Guide
- How to copy paste youtube link on android - Guide
1 response
Hi Ujo,
Let's say your data has the range A1:C3.
Now create a new sheet and type in the following:
=Sheet1!A1--------ID--------Role
=Sheet1!A2 =Sheet1!B2 =Sheet1!B1
=Sheet1!A2 =Sheet1!C2 =Sheet1!C1
=Sheet1!A3 =Sheet1!B3 =Sheet1!B1
=Sheet1!A3 =Sheet1!C3 =Sheet1!C1
Hope this helps you.
Best regards,
Trowa
Let's say your data has the range A1:C3.
Now create a new sheet and type in the following:
=Sheet1!A1--------ID--------Role
=Sheet1!A2 =Sheet1!B2 =Sheet1!B1
=Sheet1!A2 =Sheet1!C2 =Sheet1!C1
=Sheet1!A3 =Sheet1!B3 =Sheet1!B1
=Sheet1!A3 =Sheet1!C3 =Sheet1!C1
Hope this helps you.
Best regards,
Trowa
