Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2020, 01:42 AM
ganesang ganesang is offline Need to copy specific ranges column data as row data from one worksheet to another using excel VBA Windows XP Need to copy specific ranges column data as row data from one worksheet to another using excel VBA Office 2016
Competent Performer
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default 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
Attached Files
File Type: xlsx sampledata.xlsx (10.3 KB, 3 views)
Reply With Quote
  #2  
Old 03-26-2020, 06:18 AM
NoSparks NoSparks is offline Need to copy specific ranges column data as row data from one worksheet to another using excel VBA 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: 779
NoSparks has a spectacular aura aboutNoSparks has a spectacular aura aboutNoSparks has a spectacular aura about
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA 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 - Senior Forums

All times are GMT -7. The time now is 10:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft