Finding/lookingup and copying a column from one sheet to another

[ErinRV]

I am importing a spreadsheet that has multiple columns (# of columns changes every time i import it). I would like to find a specific title i.e. 'Item Total" within row A and have this entire column transferred into a different sheet. I've played with Exact,Match and lookup... but just can't seem to get anything to work. Please help!!

 

[mumps]

Try:

Sub CopyCol()
    Application.ScreenUpdating = False
    Dim LastRow As Long
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    Dim ColName As Range
    Set ColName = ActiveSheet.Rows(1).Find("Item Total", LookIn:=xlValues, lookat:=xlWhole)
    If Not ColName Is Nothing Then
        ColName.EntireColumn.Copy Sheets("Sheet2").Cells(1, 1)
    End If
    Application.ScreenUpdating = True
End Sub

 

[JainAbraham]

Hi ErinRV,

I am not able to understand what exactly do you want. Could you please be a bit more elaborate.

 

[ErinRV]

Thanks so much and I'm sure this would work... but I'm using Google spreadsheet and I don't believe it supports VBA code, at least not that i know...

 

[mumps]

Unfortunately, I'm not familiar with Google spreadsheet.

 

[ErinRV]

I have a spread sheet that changes weekly. I import this spreadsheet into a sheet titled RawData. Row A in this sheet has titles of all sorts, these titles change depending upon which data is provided/exported (I can't control this). One of the columns is titled "Item Total", but I never know which column it will be in. How can I create a formula that will find this column and transfer it into a new sheet? I am using Google Spreadsheets...