Hi all, I am trying to do something rather easy and was hoping there is a good solution to below. Any thoughts would be greatly appreciated! thanks so much
So basically I have 2 spreadsheets:
Data.csv (my data with 20 header columns)
Summary.xls (I only need 10 columns from data.csv)
I am pulling 10 random columns from data.csv into 10 random columns in Summary.xls
' and so forth for 8 other columns.. however.. when I execute the macro it gets stuck on 2nd column below with comment Run-time error '9' Subsript out of range.
Sheets("data_" & intex_date(PrevBD(Date)) & "_NY").Select
Range("BP3:BP" & LastRow).Select
Bookmarks