i have 4 different excel files of different names.
each excel file has 8 columns and 15 sheets.
All excel files has same columns and same number of sheets (same sheet names and column names)...
i have to merge these 4 files into one.
that file must be identical to the individual files.i.e same column names,and same number of sheets.
please do help me with that please.am a begginer in programming.
thanks in advance.
hope i can get the solution here...
please note am using excel 2003...:P