troubleshooting Question

vba to flip column

Avatar of vijay vj
vijay vjFlag for India asked on
VBAMicrosoft ExcelMicrosoft Office
14 Comments1 Solution824 ViewsLast Modified:
Dear sir , i have vba where its downloads data from web and copy data to another sheet , but i need data to be flipped in reverse order. (i.e) column A has values of 1 ,2 ,3 ,4 and need column A values to be flipped as 4,3,2,1 and so on.
 here is my vba code

Sub Go()
'
' Go Macro
' Macro recorded 29/03/2007 by pjPonzo

Dim i As Integer, N As Integer, j As Integer, sym As String

N = Range("A2")
j = 3
Clear
' get data for each symbol
For i = 1 To N
    sym = Cells(1, 2 + i)
'    sym = sym + "&selected=" + sym
    Cells(3, j) = sym
    Sheets("Webpage").Select
    Range("A2") = sym
    GetData
    Range("B8:J60").Select
    Selection.Copy
    Sheets("Data").Select
    Cells(5, j).Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    j = j + 10
Next i

Range("B1").Select

End Sub

i have attached my excel sheet image

here webpage is the data download from web and data sheet where it copy that data from webpage to data sheet , i have attached code for copy data sheet.
2.jpg
1.jpg
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros