Thread: Need to copy specific ranges column data as row data from one worksheet to another using excel VBA
View Single Post
 
Old 03-26-2020, 01:42 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
  
Join Date: Jul 2018
Posts: 171
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, 7 views)
Reply With Quote