date:20110909

$$Excel-Macros$$ Fwd:Job Process Developer

2011-09-09 Thread Venkat CV

- Original message 
From:""HR Axis India Pvt Ltd.""< quali...@hraxisindia.com >
Date: 9 Sep 11 18:01:48
Subject: A Leading MNC Captive BPO Company is looking for Process Developer
(Billing & Collections - US Healthcare) for Hyderabad Location.
To:

The sender of this email is registered with Naukri.com as HR Axis India Pvt
Ltd. Job Location: Hyderabad
Dear Candidate,Warm Greetings from HR AXIS INDIA PVT LTD!!!

A Leading MNC Captive BPO Company is looking for Process Developer (Billing
& Collections - US Healthcare) for Hyderabad Location.

Detailed Job Description: HR Axis India Pvt Ltd is a leading HR Consultancy
in Hyderabad. We are looking for excellent candidates for the following
position with one of our esteemed clients.

About Company: It is a Global Leader in Business Process and Technology
Management. Its entire organization of over 43,300 employees is focused on
process and engaged in improving client processes and driving business
impact. They look at process as a science and their proprietary Smart
Enterprise Process (SEP) employs a scientific, highly granular approach to
managing business process

Services are seamlessly delivered from a global network of centers in 13
countries to meet a clientâ€™s business objectives, cultural and language
needs, and cost reduction strategy. The company became independent in
January 2005, bringing process strength to companies, and was successfully
listed on the NYSE in August 2007. Today the company manages over 3,000
processes for more than 400 clients worldwide.

Job Profile:

Position: Process Developer

Process: Billing & Collections (US Healthcare)

Location: Hyderabad

Skill Set:

ïƒ˜Any Graduate (Non tech graduate)

ïƒ˜Experience of RCM in US health care industry

ïƒ˜ Good verbal and written communication skills

ïƒ˜Understanding of US healthcare billing forms & procedures

ïƒ˜Responsible for communciating with the business (email/call); B2B
collections

ïƒ˜Understanding of Explanation of Benefits

ïƒ˜Good excel & MS Word skills/knowledge / Open to change, new ideas, etc

ïƒ˜Experience of denials managemnet in heathcare RCM

Note: If you are a B.Tech Graduate,then please Ignore this mail.

If you are looking for an excellent change to a world class organization
please send your updated CV to quali...@hraxisindia.com [quality1 at
hraxisindia.com] along with Current CTC, Expected CTC and Notice Period.

-- 

Thanks & Regards

I.Swathi

HR-Executive

Hexa Resource Axis India Pvt Ltd

102, My Home Lakshmi Nivas

Opp Hotel Green Park

Ameerpet,Hyderabad- 500016

Tel: 040-30166019

(M):7396463215

E mail: quali...@hraxisindia.com

URL: www.hraxisindia.com

Note: We do not charge anything from the candidate.Is this job relevant to
you? Yes No Your feedback would help us in sending you the most relevant job
opportunities Disclaimer: The sender of this email is registered with
naukri.com as HR Axis India Pvt Ltd. (sudar...@hraxisindia.com, 102,My Home
Laxmi Nivas, Opp. Hotel Green Park Hotel, Ameerpet, HYDERABAD, Andhra
Pradesh - 500016) using Naukri.com services. The responsibility of checking
the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

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

-- 
--
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$$ calculating age with months

2011-09-09 Thread Venkat CV

Hi Sunny,


What ..Result not.

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

On Fri, Sep 9, 2011 at 9:54 PM, XLS S  wrote:

> Great!!! But Result not.
>
>
> On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV  wrote:
>
>> Hi Varun,
>>
>> See if Helps Attached...
>>
>> *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *My Linked in profile
>> *
>>
>>
>>
>> On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote:
>>
>>>
>>>
>>> Can any body guide me the formula to calculate the Age in excel with
>>> months and days.
>>>
>>> Regards
>>>
>>> Varun Chawla
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> .
>
>
>  --
>
> --
> 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$$ Moving Sheets

2011-09-09 Thread dguillett1

IF??? I understand just copy>paste values>copy .

-Original Message- 
From: bom

Sent: Friday, September 09, 2011 2:24 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Moving Sheets

I would like to know whether its possible to move sheets from one
workbook to another without the formulas on the sheets moved being
changed?
For example I want to move two sheets from one workbook to another.
One of those sheets populates info from the other sheet that is being
moved with it. when I moved them to the other workbook, I don't wanna
have any info of the previous workbook in the formula bar.
Hope you understand what I am trying to say.
Regards.

--
--
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$$ Moving Sheets

2011-09-09 Thread bom

I would like to know whether its possible to move sheets from one
workbook to another without the formulas on the sheets moved being
changed?
For example I want to move two sheets from one workbook to another.
One of those sheets populates info from the other sheet that is being
moved with it. when I moved them to the other workbook, I don't wanna
have any info of the previous workbook in the formula bar.
Hope you understand what I am trying to say.
Regards.

-- 
--
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$$ Date from textbox reversed.

2011-09-09 Thread Paul Schreiner

How is the date entered into the textbox?

perhaps Excel isn't recognizing the value as an actual "date"...

Try this:]
if (isdate(frmApplications.TextBox1.Value)) then
    ActiveCell.Value = Format(frmApplications.TextBox1.Value)) , "dd/mm/")
end if
 
I'm suspecting that the value in the textbox is being entered as a "string"
that Excel isn't recognizing as a date, so it enters it as Text.

also..
You don't really have to do all of the "selects"...
   ActiveCell.Value = Date
   ActiveCell.Offset(0, 1).Value = FrmApplications.TextBox1.Value

should work just as well.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Brian 
To: MS EXCEL AND VBA MACROS 
Sent: Fri, September 9, 2011 12:56:17 PM
Subject: $$Excel-Macros$$ Date from textbox reversed.

I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet.  This is my code
    ActiveCell.Value = Date
    ActiveCell.Offset(0, 1).Select
    ActiveCell.Value = FrmApplications.TextBox1.Value
    ActiveCell.Offset(0, 1).Select

Activecell.Value = Date works perfectly as it places the date in
column A correctly in the format set for my computer dd/mm/
In textbox 1 I am entering a date in the form but when this is pulled
into the cell in column B it reverses the date to mm/dd/ although
my windows setting has been set to the format that appears in colmn A


How do I correct this?


I am using Excel 2007

-- 
--

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$$ Date from textbox reversed.

2011-09-09 Thread Mahesh parab

Hi

Try

ActiveCell.Value = Format(FrmApplications.TextBox1.Value,"dd/mm/")


Thanks
Mahesh



On Fri, Sep 9, 2011 at 10:26 PM, Brian  wrote:

> I am using a form to enter data and then from the textbox complete
> data in an excel spreadsheet.  This is my code
>ActiveCell.Value = Date
>ActiveCell.Offset(0, 1).Select
>ActiveCell.Value = FrmApplications.TextBox1.Value
>ActiveCell.Offset(0, 1).Select
>
> Activecell.Value = Date works perfectly as it places the date in
> column A correctly in the format set for my computer dd/mm/
> In textbox 1 I am entering a date in the form but when this is pulled
> into the cell in column B it reverses the date to mm/dd/ although
> my windows setting has been set to the format that appears in colmn A
>
>
> How do I correct this?
>
>
> I am using Excel 2007
>
> --
>
> --
> 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$$ Date from textbox reversed.

2011-09-09 Thread Brian

I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet.  This is my code
ActiveCell.Value = Date
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = FrmApplications.TextBox1.Value
ActiveCell.Offset(0, 1).Select

Activecell.Value = Date works perfectly as it places the date in
column A correctly in the format set for my computer dd/mm/
In textbox 1 I am entering a date in the form but when this is pulled
into the cell in column B it reverses the date to mm/dd/ although
my windows setting has been set to the format that appears in colmn A


How do I correct this?


I am using Excel 2007

-- 
--
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$$ Loop Practice in VBA

2011-09-09 Thread XLS S

Venkat Ji...

Google Baba Ki Jai

http://msdn.microsoft.com/en-us/library/ezk76t25%28v=vs.71%29.aspx



On Fri, Sep 9, 2011 at 10:47 AM, Venkat CV  wrote:

> Dear All,
>
> Find attached some Examples With Loops...in VBA it will useful
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
>
> On Fri, Sep 9, 2011 at 8:17 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Group,
>>
>> Please find attached sheet, it is very usefull to understand Loop in VBA
>>
>>
>>
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>>  --
>>
>> --
>> 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
>



-- 
.

-- 
--
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$$ calculating age with months

2011-09-09 Thread XLS S

Great!!! But Result not.

On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV  wrote:

> Hi Varun,
>
> See if Helps Attached...
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
>
>
>
> On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote:
>
>>
>>
>> Can any body guide me the formula to calculate the Age in excel with
>> months and days.
>>
>> Regards
>>
>> Varun Chawla
>>
>> --
>>
>> --
>> 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
>



-- 
.

-- 
--
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$$ vba help

2011-09-09 Thread Paul Schreiner

If you do it that way, you're going to skip some rows:

first loop:
i = 1, selects 1 to 200
  i = i + 200 = 201
second loop: INCREMENTS i
i = 201, for loop increments to 202, selects 202 to 401
  i = i + 200 = 402
loop increments 402 to 403,
  selects 403-602

what you SHOULD use for the loop is:

For I = 1 to 2000 step 200

that way, the loop is:
I = 1
I = 201
I = 401
I = 601
etc.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: ashish koul 
To: excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 11:40:55 AM
Subject: Re: $$Excel-Macros$$ vba help



Sub breaksheet_data()

For i = 1 To 2000
Sheets(1).Rows(i & ":" & i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200

Next

End Sub


On Fri, Sep 9, 2011 at 12:47 PM, naresh v  wrote:

Hi Group,
>
>       I have one excel sheet with 2000 records. i want to split those records.
>
>those 2000 records should copy into moresheets
>
>for ex:
>main sheet -- 2000 records;
>sheet1 -- 1 to 200
>sheet2 -- 201 to 400
>sheet3 -- 401 to 600
>.
>.
>.
>sheet10 -- 1801 to 2000
>
>thanks in advance
>
>
>regards,
>naresh v
>
>--
>--
>
>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
>


-- 

Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/

akoul.wordpress.com
My Linkedin Profile
 
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

Re: $$Excel-Macros$$ vba help

2011-09-09 Thread ashish koul

Sub breaksheet_data()

For i = 1 To 2000
Sheets(1).Rows(i & ":" & i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200

Next

End Sub


On Fri, Sep 9, 2011 at 12:47 PM, naresh v wrote:

> Hi Group,
>
>I have one excel sheet with 2000 records. i want to split those
> records.
>
> those 2000 records should copy into moresheets
>
> for ex:
> main sheet -- 2000 records;
> sheet1 -- 1 to 200
> sheet2 -- 201 to 400
> sheet3 -- 401 to 600
> .
> .
> .
> sheet10 -- 1801 to 2000
>
> thanks in advance
>
>
> regards,
> naresh v
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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

$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

2011-09-09 Thread Stuart Redmann



On 7 Sep.,  ShayneH wrote:
> Is there a way to expose an array that is enclosed by a variant?
> Basically I have one function that returns a variant type which needs
> to be passed to another procedure that requires the parameter to be
> typed as a byte array.
>
> eg:
> Function UsuallyReturnsAnArray() As Variant
>
> the result, after testing to be an array is passed to:
>
> Sub ConsumesByteArray(ByRef ByteArray() As Byte)
>
> I need to find a way to coerce the variant that contains a byte array
> returned from the first function to a byte array.
> Copying each element to a dimensioned array is a possible solution,
> but it seems to me there must be a way to reference the array that is
> contained inside the variant type.

I don't see your problem:

Function getArray() As Variant
  Dim h(5) As Double
  getArray = h
End Function

Sub test()
  Dim v As Variant
  v = getArray
  Dim h() As Double
  h = v
End Sub

Regards,
Stuart

-- 
--
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$$ Manipulating data in rows into Columns

2011-09-09 Thread ashish koul

Hi Andy

change For k = 3 To 7 if u have more than 7 cols in ur data


try the below code




Sub tests()
Dim i As Long
j = 1
For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row

For k = 3 To 7

Sheets(2).Cells(j, 1).Value = Sheets(1).Cells(i, 1).Value
Sheets(2).Cells(j, 2).Value = Sheets(1).Cells(i, 2).Value
Sheets(2).Cells(j, 3).Value = Sheets(1).Cells(i, k).Value


j = j + 1

Next k



Next i




End Sub


On Fri, Sep 9, 2011 at 2:19 PM, Andy McGooner wrote:

> Hi All,
>
> I have a spreadsheet that contains some test results that go across
> multiple columns on each row. Now these results are unique to a serial
> number, however can be tested on multiple dates i.e. after software
> updates etc. Therefore need to be on seperate rows. See example below:
>
>  Ser No   DateCol 1Col 2 Col 3Col 4
> Col 5
>  01   11/01/11 16.5  9.510
> 1112
>  02   12/01/11 14.5  7.511
> 11
>  03   15/01/11 12.5  7.5
> 1112
>  01   21/02/11 16.5  9.5
> 1112
>
> The problem here is twofold in that i need to manipulate the data into
> another sheet into 3 columns with each result having its own row but
> retaining its original date and serial number. There is also the
> problem that there may be blanks in some of the columns associated
> with the ser no as shown above. Anyway can anyone help me get my data
> from the condition shown above into the condition below:
>
> Ser NoDate   Result
>  01  11/01/11 16.5
>  01  11/01/11  9.5
>  01  11/01/11 10
>  01  11/01/11 11
>  01  11/01/11 12
>
> And so on
>
> Anyway any help would be greatly appreciated
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-09 Thread Venkat CV

Hi  Jose,

Just go to your Gmail and Compose Mail and send it to *
excel-macros@googlegroups.com * and it will Automatically Reach Group.. You
can attach your file in Gmail itself..



On Fri, Sep 9, 2011 at 6:15 PM, Jose Costa  wrote:

> Hi Venkat,
>
> Thanks for your quick reply.
>
> I'm new to the group and couldn't find any option to attach files.
>
> Jose
>
>
> On Sep 9, 3:15 am, Venkat CV  wrote:
> > *Hi,*
> > *
> > *
> > *Please attach some Data in Excel...*
> > *
> > *
> > *Best Regards,*
> > *Venkat *
> > *Chennai*
> > *My Linked in profile <
> http://in.linkedin.com/pub/venkatesan-c/21/492/a71>*
> >
> >
> >
> >
> >
> > On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa  wrote:
> > > Hi all,
> >
> > > I'm trying to build an Excel solution that would do the following:
> >
> > > - User select a given spreadsheet/worksheet/column(sample below),
> > > where file location may vary and exchange rate column will vary (based
> > > on Month)
> >
> > > - Allows target selection:
> > >   User selects target spreadsheet(s) and worksheet(s) within
> > > spreadsheet(s)
> > >   User selects currency and amount columns for each worksheet/
> > > spreadsheet
> > >   User defines target rates (CAD and USD) into target columns
> > > (e.g. CAD @ G, USD @ I)
> >
> > > Logic converts values and writes to target columns
> >
> > > Currency Name   Currency Code   Base Rate   Nov10   Dec10   Jan11
> > > UNITED STATES DOLLARS   USD CAD 1.0261150.997437
> > >  1.001006
> > > ALGERIA DINARS  DZD CAD 0.0137640.013383
>  0.013726
> > > ALGERIA DINARS  DZD USD 0.0134140.013417
>  0.013712
> > > ARGENTINA PESOS ARS CAD 0.2579470.251244
>  0.249783
> > > ARGENTINA PESOS ARS USD 0.2513830.251889
>  0.249532
> > > ARUBA GUILDERS  AWG CAD 0.5732490.557227
>  0.559221
> > > ARUBA GUILDERS  AWG USD 0.5586590.558659
>  0.558659
> > > AUSTRALIA DOLLARS   AUD CAD 0.9844331.019336
> > >  0.997949
> > > AUSTRALIA DOLLARS   AUD USD 0.9593791.021956
> > >  0.996946
> > > BAHAMAS DOLLARS BSD CAD 1.0261150.997437
>  1.001006
> > > BAHAMAS DOLLARS BSD USD 1.001.00
>  1.00
> > > BAHRAIN DINARS  BHD CAD 2.7214652.645160
>  2.655154
> > > BAHRAIN DINARS  BHD USD 2.6522032.651957
>  2.652485
> > > BANGLADESH TAKA BDT CAD 0.0145860.014118
>  0.014139
> >
> > > Can you help?
> >
> > > Thanks in advance!
> >
> > > JC
> >
> > > --
> >
> > >
> ------
> > > 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
> >
> > --
> > *
> > *
> > *
> > *
> > *
> > *- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> 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
>



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

-- 
--
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$$ Msg Box

2011-09-09 Thread dguillett1

In the vba help type in 
msgbox

From: Mr Excellent 
Sent: Friday, September 09, 2011 6:13 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Msg Box

Hi Group,

I have a form which has a Close button and a Code assgined to it as below: 

Private Sub cmdClose_Click()
MsgBox "Do you want to Save the details", vbYesNoCancel
Unload Me
End Sub

But What i need is when i Click on "OK" button on the form should close or if i 
click on "No" the Form should not close and If i click on Cancel then the Msg 
box shud be disappeared.

Attached is the sheet 

Please help

Thanks
Prasad.
-- 
--
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$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-09 Thread Jose Costa

Hi Venkat,

Thanks for your quick reply.

I'm new to the group and couldn't find any option to attach files.

Jose


On Sep 9, 3:15 am, Venkat CV  wrote:
> *Hi,*
> *
> *
> *Please attach some Data in Excel...*
> *
> *
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile *
>
>
>
>
>
> On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa  wrote:
> > Hi all,
>
> > I'm trying to build an Excel solution that would do the following:
>
> > - User select a given spreadsheet/worksheet/column(sample below),
> > where file location may vary and exchange rate column will vary (based
> > on Month)
>
> > - Allows target selection:
> >           User selects target spreadsheet(s) and worksheet(s) within
> > spreadsheet(s)
> >           User selects currency and amount columns for each worksheet/
> > spreadsheet
> >           User defines target rates (CAD and USD) into target columns
> > (e.g. CAD @ G, USD @ I)
>
> > Logic converts values and writes to target columns
>
> > Currency Name   Currency Code   Base Rate       Nov10   Dec10   Jan11
> > UNITED STATES DOLLARS   USD     CAD     1.026115        0.997437
> >  1.001006
> > ALGERIA DINARS  DZD     CAD     0.013764        0.013383        0.013726
> > ALGERIA DINARS  DZD     USD     0.013414        0.013417        0.013712
> > ARGENTINA PESOS ARS     CAD     0.257947        0.251244        0.249783
> > ARGENTINA PESOS ARS     USD     0.251383        0.251889        0.249532
> > ARUBA GUILDERS  AWG     CAD     0.573249        0.557227        0.559221
> > ARUBA GUILDERS  AWG     USD     0.558659        0.558659        0.558659
> > AUSTRALIA DOLLARS       AUD     CAD     0.984433        1.019336
> >  0.997949
> > AUSTRALIA DOLLARS       AUD     USD     0.959379        1.021956
> >  0.996946
> > BAHAMAS DOLLARS BSD     CAD     1.026115        0.997437        1.001006
> > BAHAMAS DOLLARS BSD     USD     1.00        1.00        1.00
> > BAHRAIN DINARS  BHD     CAD     2.721465        2.645160        2.655154
> > BAHRAIN DINARS  BHD     USD     2.652203        2.651957        2.652485
> > BANGLADESH TAKA BDT     CAD     0.014586        0.014118        0.014139
>
> > Can you help?
>
> > Thanks in advance!
>
> > JC
>
> > --
>
> > ------
> > 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
>
> --
> *
> *
> *
> *
> *
> *- Hide quoted text -
>
> - Show quoted text -

-- 
--
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$$ Msg Box

2011-09-09 Thread NOORAIN ANSARI

Dear Surya,

use simple...for excel sheet..
**
*Private Sub cmdClose_Click()
ActiveWorkbook.Close True*
*End Sub*

for userform..

*Private *Sub* CommandButton1_Click()
If MsgBox("Do you want to Save the details", vbQuestion + vbOKCancel) =
vbYes Then
End If
Unload Me
End Sub*

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 


On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent wrote:

> Hi Group,
>
> I have a form which has a Close button and a Code assgined to it as below:
>
> Private Sub cmdClose_Click()
> MsgBox "Do you want to Save the details", vbYesNoCancel
> Unload Me
> End Sub
>
> But What i need is when i Click on "OK" button on the form should close or
> if i click on "No" the Form should not close and If i click on Cancel then
> the Msg box shud be disappeared.
>
> Attached is the sheet
>
> Please help
>
> Thanks
> Prasad.
>
> --
>
> --
> 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$$ Msg Box

2011-09-09 Thread Paul Schreiner

You should use:

Dim Result
Result = MsgBox("Do you want to Save the Details",vbYesNoCancel)
if (Result = vbYes) then Unload Me


or you could use something like:

select case Result
    case vbYes
        ' Enter code to process when option is to Save Details
case vbNo
    ' Enter code to process when option is to NOT save details
    case vbCancel
    ' Enter code to process if "Cancel" is selected (or msgbox is aborted)
End Select
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Mr Excellent 
To: excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 7:13:06 AM
Subject: $$Excel-Macros$$ Msg Box


Hi Group,

I have a form which has a Close button and a Code assgined to it as below: 

Private Sub cmdClose_Click()
MsgBox "Do you want to Save the details", vbYesNoCancel
Unload Me
End Sub

But What i need is when i Click on "OK" button on the form should close or if i 
click on "No" the Form should not close and If i click on Cancel then the Msg 
box shud be disappeared.

Attached is the sheet 

Please help

Thanks
Prasad.-- 
--

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$$ Msg Box

2011-09-09 Thread Venkat CV

Hi,

Look Attached...

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

On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent wrote:

> Hi Group,
>
> I have a form which has a Close button and a Code assgined to it as below:
>
> Private Sub cmdClose_Click()
> MsgBox "Do you want to Save the details", vbYesNoCancel
> Unload Me
> End Sub
>
> But What i need is when i Click on "OK" button on the form should close or
> if i click on "No" the Form should not close and If i click on Cancel then
> the Msg box shud be disappeared.
>
> Attached is the sheet
>
> Please help
>
> Thanks
> Prasad.
>
> --
>
> --
> 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


Close.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Msg Box

2011-09-09 Thread Mr Excellent

Hi Group,

I have a form which has a Close button and a Code assgined to it as below:

Private Sub cmdClose_Click()
MsgBox "Do you want to Save the details", vbYesNoCancel
Unload Me
End Sub

But What i need is when i Click on "OK" button on the form should close or
if i click on "No" the Form should not close and If i click on Cancel then
the Msg box shud be disappeared.

Attached is the sheet

Please help

Thanks
Prasad.

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


Close.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help required offset command

2011-09-09 Thread Kal xcel

Thank you Daniel

On Fri, Sep 9, 2011 at 2:56 PM, Daniel  wrote:

>  Hi,
>
> ** **
>
> See  attached file.
>
> ** **
>
> Regards.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Kal xcel
> *Envoyé :* vendredi 9 septembre 2011 09:44
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Help required offset command
>
> ** **
>
> Dear Expert, 
>
>  
>
> I need a urgent help on offset formula. Please see the attachment.
>
>  
>
> Thanks in advance
>
> -- 
>
> *Kalyan Chattopadhyay*
>
>  
>
> *Executive Sales Coordinator*
>
> *R. S. H. Pvt. Ltd.*
>
> ** **
>
> --
>
> --
> 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
>



-- 
*Kalyan Chattopadhyay*

*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*

-- 
--
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$$ Fwd: Urgent Opening for SQL developer

2011-09-09 Thread Venkat CV

 Original message 
From:"Magna Infotech Pvt Ltd"< afr...@magna.in >
Date: 9 Sep 11 14:07:27
Subject: Urgent Opening for SQL developer

The sender of this email is registered with Naukri.com as Magna Infotech Pvt
Ltd Dear Candidate,This is in reference to your profile in my database; I am
Afreen from Magna Info Tech Pvt ltd. Hyderabad. We have an urgent
requirement for our company.

ABOUT MAGNA INFO TECH

Magna Info Tech is an ISO.9001:2008 Certified Company that offers unique
solutions to build, integrate and manage all the IT systems across a broad
spectrum of Manufacturing, IT, Telecom, Infrastructure, Health, Finance,
Banking, etc., we at Magna are 5000 employees scattered in 7 locations of
India with 149 Clients all together. We are the Primary SSP (Software
Service Provider) to our Clients like IBM, JPMC, Amdocs, Symantec, EDS, CSC,
Patni, and Oracle Corporation. We have a 120 core revenue worldwide

REQUIREMENT SPECIFICATION:

POSIITON: : SQL Developer

JOB LOCATION: Chennai

Experience: 1-4 years

JOB DESCRIPTION:

Skills required: Good Analytical Skills

SQL Developer

Please revert with the following details

1.Your updated CV in word format:

2.Your Name as per your Pass Port:

3.Your current company and your Role / Designation:

4.Your current CTC:

5.Your expected CTC:

6.Your Notice Period / Time Required to Join: Expecting with in 15 days time

7.Your Contact Number:

8.Your E-Mail ID:

9.Your Official E-Mail ID

10. Your location preference (if any):

11.Your Alternative Contact Number:

12.Your Passport No:

Please pass on the requirement to all your friends and fraternity who would
be interested in this requirement

Thanks & Regards

AFREEN AZIZ

IT Recruiter

Magna Infotech Pvt Ltd

Desk No: 040-39179104

EMail ID: afr...@magna.in

URL: www.magna.in, www.magnai.netIs this job relevant to you? Yes No Your
feedback would help us in sending you the most relevant job opportunities
Disclaimer: The sender of this email is registered with naukri.com as Magna
Infotech Pvt Ltd (ssari...@magna.in, 6-2-47, 2nd Foor, Yeturi Towers
Advocate Colony,, A.C.Gaurds Hyderabad - 54, HYDERABAD, Andhra Pradesh -
54) using Naukri.com services. The responsibility of checking the
authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

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

-- 
--
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$$ Crystal Reports for vba excel

2011-09-09 Thread Shankar Bheema

hello venkat ji,

the links which you have provided are seems very useful for me.  but the
forums are closed registrations and replies for queries.  If possible, is
there any other forum which provide sample examples with crystal reports
with VBA Excel

On Fri, Sep 9, 2011 at 10:54 AM, Venkat CV  wrote:

> Hi ,
>
> See below links if Helps
>
> http://forums.esri.com/Thread.asp?c=93&f=992&t=67019
> http://www.codeguru.com/forum/showthread.php?t=356836
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
> *
> *
> On Fri, Sep 9, 2011 at 10:42 AM, Shankar Bheema wrote:
>
>> Good morning to all,
>>
>> Is the crystal report software which will use for report generation in
>> Visual Basic 6 will work with VBA Excel ?  If so, I request to you all,
>> provide me sample project to understand.
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ Change excel file logo separate for single files

2011-09-09 Thread learner

Hi!

I keep four excel workbooks in a folder and need to change logo of
each file separately to distinguish them by logo. The logo change in
Excel applies to all files. I need to have each file a different logo.

Please guide how to pick up logos?

Mahess

-- 
--
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$$ Code to control the database not to accept repeated number

2011-09-09 Thread Shankar Bheema

thank you all very muchh
On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV  wrote:

> Hi Bheema,
>
> See below image and Try Data Validation and use custom and formula as *
> =COUNTIF(C:C,C1)=1*
>
> [image: image.png]
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
> *
> *
>
> On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote:
>
>> I made a userform. linked it with the datasheet.  the filenumber acts
>> as a bridge between userform and datasheet.  I have to make the file
>> number unique in excel. Because the duplicate numbers also accepting
>> by the datasheet.  If it happened so, my intention will not fulfill.
>> So kindly provide solution to make the filenumber column of the
>> datasheet as unique.
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ Manipulating data in rows into Columns

2011-09-09 Thread Andy McGooner

Hi All,

I have a spreadsheet that contains some test results that go across
multiple columns on each row. Now these results are unique to a serial
number, however can be tested on multiple dates i.e. after software
updates etc. Therefore need to be on seperate rows. See example below:

  Ser No   DateCol 1Col 2 Col 3Col 4
Col 5
  01   11/01/11 16.5  9.510
1112
  02   12/01/11 14.5  7.511
11
  03   15/01/11 12.5  7.5
1112
  01   21/02/11 16.5  9.5
1112

The problem here is twofold in that i need to manipulate the data into
another sheet into 3 columns with each result having its own row but
retaining its original date and serial number. There is also the
problem that there may be blanks in some of the columns associated
with the ser no as shown above. Anyway can anyone help me get my data
from the condition shown above into the condition below:

Ser NoDate   Result
  01  11/01/11 16.5
  01  11/01/11  9.5
  01  11/01/11 10
  01  11/01/11 11
  01  11/01/11 12

And so on

Anyway any help would be greatly appreciated

-- 
--
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$$ vba help

2011-09-09 Thread naresh v

Hi Group,

I have one excel sheet with 2000 records. i want to split those records.

those 2000 records should copy into moresheets

for ex:
main sheet -- 2000 records;
sheet1 -- 1 to 200
sheet2 -- 201 to 400
sheet3 -- 401 to 600
.
.
.
sheet10 -- 1801 to 2000

thanks in advance


regards,
naresh v

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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-09 Thread Venkat CV

*Hi,*
*
*
*Please attach some Data in Excel...*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa  wrote:

> Hi all,
>
> I'm trying to build an Excel solution that would do the following:
>
> - User select a given spreadsheet/worksheet/column(sample below),
> where file location may vary and exchange rate column will vary (based
> on Month)
>
> - Allows target selection:
>   User selects target spreadsheet(s) and worksheet(s) within
> spreadsheet(s)
>   User selects currency and amount columns for each worksheet/
> spreadsheet
>   User defines target rates (CAD and USD) into target columns
> (e.g. CAD @ G, USD @ I)
>
> Logic converts values and writes to target columns
>
>
> Currency Name   Currency Code   Base Rate   Nov10   Dec10   Jan11
> UNITED STATES DOLLARS   USD CAD 1.0261150.997437
>  1.001006
> ALGERIA DINARS  DZD CAD 0.0137640.0133830.013726
> ALGERIA DINARS  DZD USD 0.0134140.0134170.013712
> ARGENTINA PESOS ARS CAD 0.2579470.2512440.249783
> ARGENTINA PESOS ARS USD 0.2513830.2518890.249532
> ARUBA GUILDERS  AWG CAD 0.5732490.5572270.559221
> ARUBA GUILDERS  AWG USD 0.5586590.5586590.558659
> AUSTRALIA DOLLARS   AUD CAD 0.9844331.019336
>  0.997949
> AUSTRALIA DOLLARS   AUD USD 0.9593791.021956
>  0.996946
> BAHAMAS DOLLARS BSD CAD 1.0261150.9974371.001006
> BAHAMAS DOLLARS BSD USD 1.001.001.00
> BAHRAIN DINARS  BHD CAD 2.7214652.6451602.655154
> BAHRAIN DINARS  BHD USD 2.6522032.6519572.652485
> BANGLADESH TAKA BDT CAD 0.0145860.0141180.014139
>
>
> Can you help?
>
> Thanks in advance!
>
> JC
>
> --
>
> --
> 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$$ Fwd:Job Process Developer

Re: $$Excel-Macros$$ calculating age with months

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

Re: $$Excel-Macros$$ Moving Sheets

$$Excel-Macros$$ Moving Sheets

Re: $$Excel-Macros$$ Date from textbox reversed.

Re: $$Excel-Macros$$ Date from textbox reversed.

$$Excel-Macros$$ Date from textbox reversed.

Re: $$Excel-Macros$$ Loop Practice in VBA

Re: $$Excel-Macros$$ calculating age with months

Re: $$Excel-Macros$$ vba help

Re: $$Excel-Macros$$ vba help

$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

Re: $$Excel-Macros$$ Manipulating data in rows into Columns

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Re: $$Excel-Macros$$ Msg Box

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Re: $$Excel-Macros$$ Msg Box

Re: $$Excel-Macros$$ Msg Box

Re: $$Excel-Macros$$ Msg Box

$$Excel-Macros$$ Msg Box

Re: $$Excel-Macros$$ Help required offset command

$$Excel-Macros$$ Fwd: Urgent Opening for SQL developer

Re: $$Excel-Macros$$ Crystal Reports for vba excel

$$Excel-Macros$$ Change excel file logo separate for single files

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

$$Excel-Macros$$ Manipulating data in rows into Columns

$$Excel-Macros$$ vba help

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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

30 matches

Site Navigation

Mail list logo

Footer information