|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA
Hi
I need the macro to copy specific ranges of column data to as row data from one worksheet to another using excel VBA. When moving the data from sheet2 to sheet1 then get cleared that moved data in sheet2 automatically. I have highlighted the cells for reference. Is there any possibility to convert this? I have attached the samples. Thanks Ganesan. G |
#2
|
|||
|
|||
What you're looking to do is transpose an array.
Google is your friend, doing a search for "vba to transpose an array" gave me this as the first result returned VBA Arrays - Transposing Have a look at the CopyAndPasteSpecial macro. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Transfer data to another book based on the active cell - Specific ranges only | ganesang | Excel Programming | 6 | 03-27-2020 05:28 PM |
importing specific data from another worksheet | wendell45 | Excel | 2 | 12-28-2019 11:26 AM |
Copy Data from different areas in a worksheet into a Table | Josh1012 | Excel Programming | 2 | 09-20-2018 01:51 AM |
Putting data in ranges within cell MS Excel 2007 | fdirosa | Excel | 3 | 12-15-2017 03:33 PM |
Appending unique data from one worksheet to existing data on another worksheet | EdStockton | Excel | 1 | 08-06-2014 11:00 PM |