Looking for Resources/Examples of Data Input using VBA

[willcormier]

Hi Guys,

I'm looking for resources and examples to learn how to import data from another excel workbook, take out useless information, and put it into my sheet.

Can someone give me some links to examples please, I cant seem to search for the right thing on google.


Thank you,

Will

 

[ravishankar]

Hi
Can you give more details on what info you want to get and what you want to avoid and from how many files?
Ravi

 

[willcormier]

There are about 5 files, and in the files, there are 3-4 separate columns that I need to get. Also, a couple rows within the columns contain incomplete data so I would just need to trash those columns. Unfortunately the rows are not static either.