Hi guys,
Could you please share us the coding especially when helping... it
really help to improve those being helped (especially me) to understand
the vba macro/coding. Sometimes when I try to open the module/code, it's
protected by password :(
Nonetheless, thanks for the help.
On 1/26/2011 10:33 PM, ashish koul wrote:
try this macro see if it helps
On Wed, Jan 26, 2011 at 4:22 PM, Seba <sebastjan.hri...@gmail.com
<mailto:sebastjan.hri...@gmail.com>> wrote:
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
<mailto:koul.ash...@gmail.com>> wrote:
> send us the sample workbook
>
>
>
> On Mon, Jan 17, 2011 at 12:10 AM, Seba
<sebastjan.hri...@gmail.com <mailto: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
<http://www.excel-macros.blogspot.com/>
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
>
> > To post to this group, send email to
excel-macros@googlegroups.com <mailto: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://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
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<mailto: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>
PBefore 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