There are a several ways to accomplish this... Are all of the files in a single folder? Are there other files there? Or...how do you want to identify the files?
We can: A)use a sheet to list all of the files. then, loop through the list and process each workbook. B)Place all of the files in one folder, then process each workbook in the folder. The loops required to copy the data is pretty simple. Let me know what approach you'd like to take and I'd be glad to help put together the macro. Paul ________________________________ From: Seba <sebastjan.hri...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Wed, January 26, 2011 5:52:59 AM Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks Hello, how can I upload the file, as I see in the notification, this is no longer possible. However, if you can imagine my situation: I have data in columns from A to O and in rows from 1 to 100. The data is in the same rows and columns in all workbooks. Now I need the data to be copied from all this workbooks (and all new ones I create) to a new workbook serving as a database. However all columns allways contain some data, whereas the rows may not. It could be the case that only the 1st row contains any data. I hope this helps a bit. Thank you for the help. Best regards, seba On 17 jan., 18:38, ashish koul <koul.ash...@gmail.com> wrote: > send us the sample workbook > > > > On Mon, Jan 17, 2011 at 12:10 AM, Seba <sebastjan.hri...@gmail.com> wrote: > > Hello all, > > > I have a question regarding building a database. I have a workbook for > > each of my projects. I would like to have a macro, which would extract/ > > copy certain data (always in the same rows and columns) to a new > > workbook, which would serve as a database. > > > Could anyone please help? > > > Thank you in advance. > > > Best regards, > > > seba > > > -- > > > >---------------------------------------------------------------------------------- > > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
