Hi, I have 3000 Excel files and I need to load groups of text into a specific sheet and column of each one. I want to make this a batch job. Is this reasonable for a novice Excel user?
example:
read the data file,
find the text for file 1,
Open Excel file 1
load it into sheet 2, col A, row 2-n
close file
read data file
find text for file 2
Open file 2
load it into sheet 2 col A, row 2-n
close file

Any help would be greatly appreciated! This is a one-time task and I know very little about using Excel!