Scribd
Upload
5 views1 page

Excel VBA Data Transformation Script

The provided VBA macro 'TransformData' copies data from the 'After 6 data' worksheet to 'Sheet1' in a specific format. It retrieves information such as name, email, phone, designation, organization, location, and photo from each row, starting from the second row to skip the header. The data is organized into columns in the target sheet, with each entry spaced by seven columns.

Uploaded by

coolshubupaunikar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views1 page

Excel VBA Data Transformation Script

The provided VBA macro 'TransformData' copies data from the 'After 6 data' worksheet to 'Sheet1' in a specific format. It retrieves information such as name, email, phone, designation, organization, location, and photo from each row, starting from the second row to skip the header. The data is organized into columns in the target sheet, with each entry spaced by seven columns.

Uploaded by

coolshubupaunikar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Sub TransformData()

Dim wsSource As Worksheet


Set wsSource = [Link]("After 6 data")

Dim wsTarget As Worksheet


Set wsTarget = [Link]("Sheet1")

Dim lastRow As Long


lastRow = [Link]([Link], "A").End(xlUp).Row

Dim outputRow As Long


outputRow = 1

Dim startRow As Long


startRow = 2 ' Start from row 2 to skip the header row

Dim col As Long


col = 1

Do While startRow <= lastRow


For i = 0 To 7
Dim name As String
Dim email As String
Dim phone As String
Dim designation As String
Dim organization As String
Dim location As String
Dim photo As String

name = [Link](startRow, 2).Value


email = [Link](startRow, 4).Value
phone = [Link](startRow, 5).Value
designation = [Link](startRow, 6).Value
organization = [Link](startRow, 7).Value
location = [Link](startRow, 8).Value
photo = [Link](startRow, 9).Value

[Link](outputRow, col).Value = name


[Link](outputRow, col + 1).Value = email
[Link](outputRow, col + 2).Value = phone
[Link](outputRow, col + 3).Value = designation
[Link](outputRow, col + 4).Value = organization
[Link](outputRow, col + 5).Value = location
[Link](outputRow, col + 6).Value = photo

col = col + 7
startRow = startRow + 1
Next i

outputRow = outputRow + 1
col = 1
Loop
End Sub

You might also like