Need to copy specific ranges column data as row data from one worksheet to another using excel VBA

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA

FAQ

Thread Tools

Display Modes

03-26-2020, 06:18 AM

NoSparks

Windows 10 Need to copy specific ranges column data as row data from one worksheet to another using excel VBA

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 AM.