Fwd: $$Excel-Macros$$ INCOME TAX SOFTWARE

[ITP Abdulgani Shaikh]

Dear Tarun

I have found this one made by Mr.Pranab, please get is verified before
using it.  I have not made this, but found useful to you.

If you are having large no.of employees for whom you need this, always buy
software or ask professionals to do this job.

Free excel utility will not do much for large requirement.  If you want I
will do it for you.

Regards


On Fri, Apr 20, 2012 at 6:40 PM, Shekhar Sharma wrote:

> For that you have to google the available softwares and their
> functionality.
>
> Regards
> Shekhar Sharma
>
> On Fri, Apr 20, 2012 at 6:23 PM, Tarun Mondal 
> wrote:
>
>> sir, i want a income tax calculating software using excel bywhich i
>> can calculate tax and take return querterly and annualy and the form
>> 16 will be automatically generated and i can take print out of
>> that.please help.
>> --
>> With Regards ..
>>
>>   Tarun Mondal
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Shekhar Sharma
> 9910010060
> "Life consists not in holding good cards but in playing
> those  you hold well"
>  "Before you judge another, think of your own last mistake."
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Shaikh AbdulGani A R
ITP, STP, TRP, STRP



-- 
Shaikh AbdulGani A R
ITP, STP, TRP, STRP



-- 
Shaikh AbdulGani A R
ITP, STP, TRP, STRP

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH

[dguillett1]

Look at the source data of the chart to see that it is hidden under the 
chart




Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Rajesh Janardanan

Sent: Saturday, April 21, 2012 1:37 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH

Hi Ashish,

This is my requirement , please advise which function you have used.

best regards
rajesh
On 4/21/12, ashish koul  wrote:

see if it helps choose the field from drop down in yellow cell


On Sat, Apr 21, 2012 at 6:52 PM, Rajesh Janardanan
wrote:


Hi All,

Need to present a graph tomorrow and I am stuck with it ,its could be
a simple excel graph question.
Attached file has the trend of business performance over a period of
time , I am looking for a graph ( line chart) where revenue over the
period is there in the graph constant always and I need to have a
feature of drop box to select for each element of direct expenses ,
basically I need to show which element of direct exps have gone out of
proportion compared to revenue growth.
Please help.

best regards
rajesh

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE  : Don't ever post personal or confidential data in a workbook. 
Forum

owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com





--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
will

not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com



--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH

[Rajesh Janardanan]

Thanks , I have understood this.

best regards
rajesh


On Sun, Apr 22, 2012 at 4:28 PM, dguillett1  wrote:

> Look at the source data of the chart to see that it is hidden under the
> chart
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Rajesh Janardanan
> Sent: Saturday, April 21, 2012 1:37 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ AN URGENT HELP ON GRAPH
>
>
> Hi Ashish,
>
> This is my requirement , please advise which function you have used.
>
> best regards
> rajesh
> On 4/21/12, ashish koul  wrote:
>
>> see if it helps choose the field from drop down in yellow cell
>>
>>
>> On Sat, Apr 21, 2012 at 6:52 PM, Rajesh Janardanan
>> wrote:
>>
>>  Hi All,
>>>
>>> Need to present a graph tomorrow and I am stuck with it ,its could be
>>> a simple excel graph question.
>>> Attached file has the trend of business performance over a period of
>>> time , I am looking for a graph ( line chart) where revenue over the
>>> period is there in the graph constant always and I need to have a
>>> feature of drop box to select for each element of direct expenses ,
>>> basically I need to show which element of direct exps have gone out of
>>> proportion compared to revenue growth.
>>> Please help.
>>>
>>> best regards
>>> rajesh
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum
>>> owners and members are not responsible for any loss.
>>>
>>>
>>> --**--**
>>> --**
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.**com/* 
>> *http://www.accessvbamacros.**com/*  <
>> http://www.accessvbamacros.**com/ >
>>
>>
>> P Before printing, think about the environment.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>> --**--**
>> --**
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this for

RE: $$Excel-Macros$$ Re: EXTRACTING DATA BASE ON MATCHING VALUE

[Siraj Momin (BTG)]

Hi Pascal,

 

Thank you very much this is what I required, once again thank you very
much..

For your information Row 7 is my header row in "REPORT-INDEX" and row 1
in "PROGRESS TRACKING-DATA" which is like a matching field, 

 

One Small query is it possible to clear the previous data from row 8 to
row 100 because after row 100 I have some data which I am using
for drop down selections...

 

Thank you very much

 

Siraj

 

 

From: Pascal Baro [mailto:bpascal...@gmail.com] 
Sent: Saturday, April 21, 2012 8:05 PM
To: Siraj Momin (BTG)
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: EXTRACTING DATA BASE ON MATCHING VALUE

 

Hi Siraj,

 

You mean row 8 or row 7. Row 7 would include row headers...

Before running the code, if you clear-content Report Index from row 8 to
anywhere, the code will place your data there. If you don't clear it, it
will place it from bottom. You should tell if you want to clear the
previous data, without knowing, I assume you don't want to and I just
append the data to the previous one.

...

In the main sub if you change wsB.Cells(cnt + i, j + 1).Value =
TabFin(i, j) to wsB.Cells(8 + i, j + 1).Value = TabFin(i, j) it will
place your data from row 8 until there is something HOWEVER, if you
haven't cleared it first, if you have less data than the previous time
you run the code, there might still be some data in the bottom.

 

Pascal

On Sat, Apr 21, 2012 at 3:24 PM, Siraj Momin (BTG) 
wrote:

Dear Pascal

 

Sorry for the delayed reply, I was testing the macro on my actual data
your macro is working fine on file which I send before but on actual
data some problem may be I did not able to explain you properly before,
actually I just want to match the value of sheet "REPORT-INDEX" column
I1 which will be always changing value with the value in "PROGRESS
TRACKING-DATA" column P(NAMED col16) and return the values of matching
heading in PROGRESS TRACKING-DATA(row 1) with REPORT-INDEX (row7), may
be you can change the code attached is the latest file

 

I am using drop down in (F1,F2,F3,F5) in sheet REPORT-INDEX  and I am
using concatenate  formula in Column I1 which combines (F1,F2,F3,F5) in
sheet REPORT-INDEX, so we need to match only on one column I1 with value
in "PROGRESS TRACKING-DATA" column P(NAMED col16) and return the value.

 

Hope I am able to explain you better now. Still I am not able to send
you complete data in PROGRESS TRACKING-DATA because of group size limi

 

 

Thanks for your best efforts..

 

 

Siraj

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: INCOME TAX SOFTWARE

[Rakesh]

Hi,
 
please check 
 
http://ynithya.com/taxcalc/  -- personal tax good one...excellent..
 
 

On Friday, April 20, 2012 6:23:50 PM UTC+5:30, TARUN wrote:

> sir, i want a income tax calculating software using excel bywhich i
> can calculate tax and take return querterly and annualy and the form
> 16 will be automatically generated and i can take print out of
> that.please help.
> -- 
> With Regards .. 
>
>Tarun Mondal
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: EXTRACTING DATA BASE ON MATCHING VALUE

[Pascal Baro]

Hi Sirag, to clear row 8 to row 100, I advise you to create another
button so that you don't mix the cleaning part and the main process. Open
vba ide, in the same module where you have the previous code, write or
create a sub, like sub clearData and between "sub" and "end sub" enter
Set wsB = wb.Worksheets("REPORT-INDEX")
wsB.Range("A8:H100").ClearContents
and link that code to the new button and it should do like you want to.Hope
it helps,
Pascalmultiskills.elementfx.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Can a pointer or similar be set to one array or another depending on condition to reduce tests?

[tangledweb]

If I have 2 identical sized arrays and if a condition is true then I want 
to always get values from one array and if the condition false from the 
other array,
can some pointer be set to handle this using one array name and not test 
for every assignment if true or false?
 
all arrays below defined as variants
 
For example the direct method:
If condition=true then
x=array1(a,b)
else
x=array2(a,b)
end if
 
will this work or some similar concept:
if condition =true then
set usedarray=array1
else
set usedarray=array2
end if
 
then every assignment becomes
 
x=usedarray(a,b)
 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Can a pointer or similar be set to one array or another depending on condition to reduce tests?

[Domain Admin]

Well the pointer idea as described does not work.  I have to have both
array1 and array2 so can not choose to create one or other.
I can create a third usedarray which is a copy of the one specified by
the condition so I trade off a lot of wasted data space (not really
a problem but not elegant) vs a lot of extry code as every assignment
needs a test.

A better approach?

On Sun, Apr 22, 2012 at 10:51 PM, tangledweb  wrote:
> If I have 2 identical sized arrays and if a condition is true then I want to
> always get values from one array and if the condition false from the other
> array,
> can some pointer be set to handle this using one array name and not test for
> every assignment if true or false?
>
> all arrays below defined as variants
>
> For example the direct method:
> If condition=true then
>     x=array1(a,b)
> else
>     x=array2(a,b)
> end if
>
> will this work or some similar concept:
> if condition =true then
>     set usedarray=array1
> else
>     set usedarray=array2
> end if
>
> then every assignment becomes
>
> x=usedarray(a,b)
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com