Re: $$Excel-Macros$$ Re: Report Generation

2011-09-11 Thread Shankar Bheema 
pls do reply experts

On Sat, Sep 10, 2011 at 9:55 AM, Shankar Bheema wrote:

> I am attaching excel which is having VBA code for Userform.  Pls press
> Alt+F11 after opening the excelsheet.
>
> I also attached a word document which contains the REPORT which i need to
> design in excel VBA.  Kindly provide your assistance and suggestions.
>
> On Fri, Sep 9, 2011 at 11:45 AM, Kishan Reddy, K <
> kishanreddy.kethire...@gmail.com> wrote:
>
>> Try Ms-Access.
>> Put your data in a table and try the report wizard, which will guide
>> you.
>>
>> If you still want the report in excel itself, it can be done using VBA
>> coding.
>>
>> Send a sample file so that best approach can be decided based upon the
>> quantity of data and compelxity of the report.
>>
>>
>> Regards,
>> Kishan Reddy, K
>>
>>
>> On Sep 8, 9:37 am, Shankar Bheema  wrote:
>> > What is the procedure to develop reports basing on the excel database
>> > through UserForm.
>> >
>> > Report generation in the sense, not in column and rows.
>> >
>> > It would be look like a form in word document.
>>
>> --
>>
>> --
>> 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

Re: $$Excel-Macros$$ Re: Report Generation

2011-09-09 Thread Shankar Bheema 
If crystal reports can be used for excel vba, which version is compatible ?

On Sat, Sep 10, 2011 at 9:55 AM, Shankar Bheema wrote:

> I am attaching excel which is having VBA code for Userform.  Pls press
> Alt+F11 after opening the excelsheet.
>
> I also attached a word document which contains the REPORT which i need to
> design in excel VBA.  Kindly provide your assistance and suggestions.
>
> On Fri, Sep 9, 2011 at 11:45 AM, Kishan Reddy, K <
> kishanreddy.kethire...@gmail.com> wrote:
>
>> Try Ms-Access.
>> Put your data in a table and try the report wizard, which will guide
>> you.
>>
>> If you still want the report in excel itself, it can be done using VBA
>> coding.
>>
>> Send a sample file so that best approach can be decided based upon the
>> quantity of data and compelxity of the report.
>>
>>
>> Regards,
>> Kishan Reddy, K
>>
>>
>> On Sep 8, 9:37 am, Shankar Bheema  wrote:
>> > What is the procedure to develop reports basing on the excel database
>> > through UserForm.
>> >
>> > Report generation in the sense, not in column and rows.
>> >
>> > It would be look like a form in word document.
>>
>> --
>>
>> --
>> 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

Re: $$Excel-Macros$$ Re: Report Generation

2011-09-09 Thread Venkat CV 
Hi ,

See Below links if Helps...

http://databases.about.com/od/tutorials/l/aareports1.htm
http://office.microsoft.com/en-us/access-help/create-a-simple-report-HA001230739.aspx
http://www.databasedev.co.uk/reports.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*

On Fri, Sep 9, 2011 at 11:45 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:

> Try Ms-Access.
> Put your data in a table and try the report wizard, which will guide
> you.
>
> If you still want the report in excel itself, it can be done using VBA
> coding.
>
> Send a sample file so that best approach can be decided based upon the
> quantity of data and compelxity of the report.
>
>
> Regards,
> Kishan Reddy, K
>
>
> On Sep 8, 9:37 am, Shankar Bheema  wrote:
> > What is the procedure to develop reports basing on the excel database
> > through UserForm.
> >
> > Report generation in the sense, not in column and rows.
> >
> > It would be look like a form in word document.
>
> --
>
> --
> 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

$$Excel-Macros$$ Re: Report Generation

2011-09-08 Thread Kishan Reddy, K 
Try Ms-Access.
Put your data in a table and try the report wizard, which will guide
you.

If you still want the report in excel itself, it can be done using VBA
coding.

Send a sample file so that best approach can be decided based upon the
quantity of data and compelxity of the report.


Regards,
Kishan Reddy, K


On Sep 8, 9:37 am, Shankar Bheema  wrote:
> What is the procedure to develop reports basing on the excel database
> through UserForm.
>
> Report generation in the sense, not in column and rows.
>
> It would be look like a form in word document.

-- 
--
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