CODEWITHSUNDEEP
excelvba
PowerToYou
PowerToYou

Reputation: 23

Merge-Center align different rows and extract data from various columns

I have excel tables that look like this:

enter image description here

I want to develop a macro that would help me achieve an output that would look something like this:

enter image description here

I am new to VBA and have tried changing column names using some code snippets available online. It worked, and this is what I used:

Sub namefixer()
    s = Array("Response", "Factor", "Scaled Estimate")
    Range("A1:C1") = s
End Sub

However, I have no idea how I can pull data from other columns and display them as I like in a new excel sheet. Any help will be highly appreciated.

Upvotes: 0

Views: 38

Answers (1)

C. van Dorsten
C. van Dorsten

Reputation: 152

Since you are new to VBA I suggest you use the macro recorder on 1 group of rows you want to change into the desired view. It records every step you are doing when manually creating the desired result. Then study that and create your final macro based on the recorded macro. That is the best way and fastest way in my honest opinion to get into VBA quickly.

Upvotes: 0

Related Questions