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
- Spell number in excel without macro - Guide
- Macros in excel download - Download - Spreadsheets
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- How to change author in excel - 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
