Macro to copy paste in excel [Closed]

Question

Macro to copy paste in excel [Closed]

Report

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

Dear All

I have a excel sheet in the following style

Project|Lead|manager ---> Header
ABC|XYZ|PQR
DEF|LMN|OPQ

I would like the macro to arrange my data in the following way

Project|ID|Role ---> Header
ABC|XYZ|Lead
ABC|PQR|manager
DEF|LMN|Lead
DEF|OPQ|manager

Your help would really be appreciated

Regards
Ujo

Macro to copy paste in excel
Excel - A macro to copy/paste a selected range - How-To - Excel
Excel macro copy and paste data from one workbook to another - How-To - Excel
Macro to take screenshot and paste in excel - How-To - Excel
Excel macro for copy & paste selected range ✓ - Forum - Programming
Macro to insert picture in excel - How-To - Excel

1 reply

Ask a question

Trowa · Answer 1 · 2009-07-24T08:54:30-0400

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

Macro to copy paste in excel [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!