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

2012-04-22 Thread 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

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

2012-04-22 Thread 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 define

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

2012-04-22 Thread 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 = w

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

2012-04-22 Thread 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 >

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

2012-04-22 Thread 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 r

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

2012-04-22 Thread 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 Messag

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

2012-04-22 Thread 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: $$Exc

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

2012-04-22 Thread 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