Re: $$Excel-Macros$$ Appending multiple file results into one table

2012-01-30 Thread Sam Mathai Chacko
Would be better if you post a sample of your master file, and one daily file Sam Mathai Chacko On Tue, Jan 31, 2012 at 1:16 AM, RockyFontane wrote: > Thanks Sam - the data is small (approx 100 rows per day). Can anyone > provide me with a macro that would accomplish that task? I'll change > t

Re: $$Excel-Macros$$ Appending multiple file results into one table

2012-01-30 Thread RockyFontane
Thanks Sam - the data is small (approx 100 rows per day). Can anyone provide me with a macro that would accomplish that task? I'll change the file names of course. Let me know. Thanks! On Jan 30, 2:30 pm, Sam Mathai Chacko wrote: > Depending on the volume of data, you can choose between Excel

Re: $$Excel-Macros$$ Appending multiple file results into one table

2012-01-30 Thread Sam Mathai Chacko
Depending on the volume of data, you can choose between Excel or Access. However, the point is, you'd need a macro loop to run through each of those files and append it to access table, or to Excel sheet. Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 12:20 AM, RockyFontane wrote: > Questio