Hi there. Can anyone help me in creating a VB code in excel Module that
imports data like file name;direct cost; and year from several xls
spreadsheets [reports_1, reports_2, ...] (from different sheets and cells)
into one spreadsheet [summary] into the following columns accordingly:
(column 1 [file name]: file name; column 2 [direct cost]: dollar amounts,
column 3 [year]: year)? i already have the code that pulls file names from
the folder directory and pastes the data into column 1 [file name]. may be it
will be easier to have the code refer to that column 1. Please note that the
Reports_1, Report_2, etc spreadsheets maintain the same formats and the data
is ocated in the same cells (the same coordinates) and the same sheets with
the same names. thanks in advance.