Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

great thnx once again But still not clear On Wed, Jul 27, 2011 at 12:16 PM, ashish koul wrote: > * > http://ashish-msaccess.blogspot.com/p/excel.html > > > > Excel to Access Macros* > > http://akoul.blogspot.com/2011/06/edit-records-of-access-table-in-excel.html > > http://akoul.blogspot.com/2

Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

* http://ashish-msaccess.blogspot.com/p/excel.html Excel to Access Macros* http://akoul.blogspot.com/2011/06/edit-records-of-access-table-in-excel.html http://akoul.blogspot.com/2011/06/update-access-table-from-excel-update.html http://akoul.blogspot.com/2011/06/add-data-to-access-table-from-us

Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

Hey Ashis Sir, can provide the example please... On Wed, Jul 27, 2011 at 11:25 AM, ashish koul wrote: > Hi > > its better you use access for working on shared files rather than excel. > you can create a form in excel or save data from access file also > > > > > > On Wed, Jul 27, 2011 at 10

RE: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

If the workbook has shared structure , it will be available for Writing for all Users, You can share your workbook By Tools->Share Workbook(2003) , Review->ShareWorkbook (2007) Visit this Page for More Information about share Workbook Structure.. http://msdn.microsoft.com/en-us/library/dd91

RE: $$Excel-Macros$$ Reverse Sorting Of Rows

Try this.. Sub Reverse() Dim fRng As Range Dim Couter As Integer Dim cell As Range Set fRng = Application.InputBox("Please Choose A Range", , , , , , , 8) Set cell = Application.InputBox("Please Choose a Cell for Output", , , , , , , 8) cell.Activate For coun

RE: $$Excel-Macros$$ Re: Reverse Sorting Of Rows

See the attached File From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of XLS S Sent: Wednesday, July 27, 2011 9:46 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Reverse Sorting Of Rows Hey, not working On Wed, Jul 27, 2

Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

Hi its better you use access for working on shared files rather than excel. you can create a form in excel or save data from access file also On Wed, Jul 27, 2011 at 10:22 AM, XLS S wrote: > There are a few possibilities. If it's a shared file, it could be that > someone else has it open.

Re: $$Excel-Macros$$ Interesting Question

try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=454 On Wed, Jul 27, 2011 at 10:55 AM, Dilip Pandey wrote: > Ok... do you need solution in VBA or Function. > Also it would be great if you can share a sample workbook. > > Regards, > DILIPandey > > On 7/27/11, XLS S wrote: > > Hello

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S

Re: $$Excel-Macros$$ Interesting Question

Ok... do you need solution in VBA or Function. Also it would be great if you can share a sample workbook. Regards, DILIPandey On 7/27/11, XLS S wrote: > Hello Friend, > > > Suppose that, i have one excel sheet their is more then 50 columns and 100 > rows, i want extract data 20 rows and 41 colum

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

Hi, You can refer to following link by Microsoft - http://support.microsoft.com/kb/324991 Regards, DILIPandey On 7/27/11, XLS S wrote: > Dilip sir, > > i want to learn offset function, please provide the basic tips and example > > On Wed, Jul 27, 2011 at 9:59 AM, Dilip Pandey wrote: > >> Hi,

RE: $$Excel-Macros$$ Excel Problem

Also Read this Page, http://support.microsoft.com/kb/180162 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday, July 27, 2011 10:37 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Problem Dear S

$$Excel-Macros$$ Interesting Question

Hello Friend, Suppose that, i have one excel sheet their is more then 50 columns and 100 rows, i want extract data 20 rows and 41 columns (Different - 2 location), how to extract data Condition:- Don't use Copy and paste -- . -- -

Re: $$Excel-Macros$$ Excel Problem

Dear Santosh/XLS, In this sheet, 1904 date system has already checked.. *Excel Option->Advance->When Calculating this workbook->Use 1904 Date system * Please uncheck *Use 1904 Date system , *then copy and paste normal. You out put will as you want. -- Thanks & regard

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you Very much. On Wed, Jul 27, 2011 at 9:41 AM, XLS S wrote: > Hey > > Please find below link > > http://en.wikipedia.org/wiki/Management_information_system > > On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina > wrote: > >> Hi Group, >> >> My Name is krishna, Working as a Data Analyst f

RE: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

Is Your Workbook shared, see the below link http://ezinearticles.com/?Sharing-An-Excel-2003-Workbook&id=1201442 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of JingleRock Sent: Wednesday, July 27, 2011 1:46 AM To: MS EXCEL AND V

Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

There are a few possibilities. If it's a shared file, it could be that someone else has it open. In this case, anyone else can only open a read only version until the first person closes theirs. On Wed, Jul 27, 2011 at 1:46 AM, JingleRock wrote: > I have seven users accessing the Subject file

Re: $$Excel-Macros$$ Excel Problem

Hey Noorain, Can you tell me please, what this the problem in this sheet? On Wed, Jul 27, 2011 at 9:15 AM, NOORAIN ANSARI wrote: > Dear Santosh, > > Copy your date and Paste it in Notpad then again copy and paste it in > another workbook..where you want.. > Your problem will be solv

Fwd: $$Excel-Macros$$ Reverse Sorting Of Rows

try it Sub reverse_order() Dim i, j As Integer j = Application.WorksheetFunction.CountA(Sheet1.Range("A:A")) For i = 1 To j Sheet1.Cells(i, 2).Value = Sheet1.Cells((j + 1) - i, 1) Next i End Sub -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

Dilip sir, i want to learn offset function, please provide the basic tips and example On Wed, Jul 27, 2011 at 9:59 AM, Dilip Pandey wrote: > Hi, > > You can use following formula in the next column and drag it down till > you have data. > > =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0) > > Sample file is

$$Excel-Macros$$ Job

Dear All, We have an excellent Opportunity for VBA , Excel, Developer,,and following is the JD, Request you to forward your word format resume along with following information tracker. Resume's without following information in tracker will not be processed. Information is mandatory. Candidate Na

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

Try this Sub FlipRows() Dim vTop As Variant Dim vEnd As Variant Dim iStart As Integer Dim iEnd As Integer Application.ScreenUpdating = False iStart = 1 iEnd = Selection.Rows.Count Do While iStart < iEnd vTop = Selection.Rows(iStart)

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

Hi, You can use following formula in the next column and drag it down till you have data. =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0) Sample file is also attached. Regards, DILIPandey On 7/27/11, qcan wrote: > Hi, > > A little different request here. I am looking for a way to reverse > sort rows: > >

Re: $$Excel-Macros$$ Hi Everybody

yes Dilip sir, its really very good sit for all type hr related document... On Wed, Jul 27, 2011 at 9:46 AM, Dilip Pandey wrote: > Nice portal and it is offering more solutions related to HR, not just > MIS reports.. > > Thanks, > DILIPandey > > On 7/27/11, XLS S wrote: > > He

Re: $$Excel-Macros$$ Hi Everybody

Nice portal and it is offering more solutions related to HR, not just MIS reports.. Thanks, DILIPandey On 7/27/11, XLS S wrote: > Hey, > > Please register and download any HR related MIS report > > http://www.citehr.com/ > > On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya > wrote: > >> Hi >> >> A

Re: $$Excel-Macros$$ Re: Reverse Sorting Of Rows

Hey, not working On Wed, Jul 27, 2011 at 8:01 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Assume you need the entries, Last in First, First in Last. Let's say the > entries are in A2:A10. > > Try this in B2, copy down. > > =INDEX(A$2:A$10,ROWS(A2:A$10)) > > HTH > Haseeb > > For

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hey Please find below link http://en.wikipedia.org/wiki/Management_information_system On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina wrote: > Hi Group, > > My Name is krishna, Working as a Data Analyst from the last 3 years. My > daily work includes working with excel, Creating General Repor

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

Hi Venkat, Check following links:- www.cpearson.com/excel/array.htm www.ozgrid.com/Excel/arrays.htm Regards, DILIPandey On 7/26/11, Venkat CV wrote: > Dear All, > > any one Explain Difference between Array formula and Normal Formula... > > With Examples..&Use of Array formulas ... > > *Best Re

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

*An array formula can perform multiple calculations and then return either a single result or multiple results. Array formulas act on two or more sets of values known as array arguments and An normal formula can perform signal calculation and then return either a single result * On Tue, Jul

Re: $$Excel-Macros$$ Hi Everybody

Hey, Please register and download any HR related MIS report http://www.citehr.com/ On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya wrote: > Hi > > All friends if u have these type others MIS Report file for Sales > Department and Finance Department Please forward me. > > -- > ***Thanks > Sanjay

Re: $$Excel-Macros$$ use of indirect function

Hey, please find the below mention link http://www.jkp-ads.com/articles/ShowPicture00.asp On Tue, Jul 26, 2011 at 5:32 PM, ICWAI Help wrote: > Hi How the 3rd example sheet works or photo example sheet workds please > explain clearly..:) > > > On Tue, Jul 26, 2011 at 11:16 AM, sandeep ch

Re: $$Excel-Macros$$ Excel Problem

Dear Santosh, Copy your date and Paste it in Notpad then again copy and paste it in another workbook..where you want.. Your problem will be solve -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 27, 20

Re: $$Excel-Macros$$ Excel Formula Required - Sum data for every month for respective year.

Thanks All. It works excellent. Regards, Kaushik On Wed, Jul 27, 2011 at 1:18 PM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > If you need a formula use SUMPRODUCT or SUMIF > > See the attached. > > > HTH > Haseeb > > For Tips visit; > http://www.excelfox.com/forum/forum.php > > -- >

RE: $$Excel-Macros$$ I'm in budget vlookup hell. Please help

I like all those charts and pivot tables ... I agree that the way he has it layed out is not very functional... too scattered. Should maybe Adam try PowerPivot??-- at least he could pull all the data into a more organized structure and then create more efficient and logical looking charts. http:/

$$Excel-Macros$$ Excel Problem

Hi Guys Please find the attached file in this file on column (A) i have date field when i copy this data to another workbook date getting change Can anyone tell me why it happening its going back about 5 years Thanks Regards Santosh Bahuguna --

$$Excel-Macros$$ Re: Reverse Sorting Of Rows

Assume you need the entries, Last in First, First in Last. Let's say the entries are in A2:A10. Try this in B2, copy down. =INDEX(A$2:A$10,ROWS(A2:A$10)) HTH Haseeb For Tips visit; http://www.excelfox.com/forum/forum.php --

$$Excel-Macros$$ Reverse Sorting Of Rows

Hi, A little different request here. I am looking for a way to reverse sort rows: Example: ABC123 ABC493 ABC961 Would become sorted in decending order as: ABC961 ABC123 ABC493 Thanks. -- -- Some important links

$$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

I have seven users accessing the Subject file stored on a shared network drive. This file has been edited by EXCEL 2003 users (four of the seven in my group) for several months. Yesterday, I made some edits in this file when I opened it; I then saved it successfully with a .xls extension. One of th

Re: $$Excel-Macros$$ Date Formula

Dear Haseeb Thanks For Excellent Logic.. Your logic is difference from Daniel. Can you tell why you are not using DATEDIF formula ? Your answer is also right.. Nikhil On Wed, Jul 27, 2011 at 12:13 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Nikhil, > > See the attach

Re: RE: $$Excel-Macros$$ Please help

Hello Anil, Also, If you have other text or charracters other than #n/a and just need to count the numbers only, use this, =COUNT(INDEX(MID(C2,ROW(INDEX(C:C,1):INDEX(C:C,LEN(C2))),1)+0,0)) Copy down HTH Haseeb For tips visit; http://www.excelfox.com/forum/forum.php -- -

Re: RE: $$Excel-Macros$$ help required

Hello Vijay, See the attached. HTH Haseeb For tips visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much sir, Really very detailed explanation. Once again Thank you very much. On Tue, Jul 26, 2011 at 4:28 PM, anandydr wrote: > Hi, > > In case of MIS Executives the kind of the data sets is very rigid. The > data is always in the same format. Mostly the amount of data would > als

RE: $$Excel-Macros$$ Need Help for Sumif

Attached a sheet with data . its not clear data as pasted in Mail -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkatesh Narla Sent: Tuesday, July 26, 2011 4:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need

RE: $$Excel-Macros$$ How to exclude a particular character from a series of number - Urgent plz

Try this =TEXT(A1,"-00") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: Tuesday, July 26, 2011 4:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to exclude a particular character from a series of number -

RE: $$Excel-Macros$$ Please help

Try this =LEN(SUBSTITUTE(C3,"#n/a","")) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil panchal Sent: Tuesday, July 26, 2011 6:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help Dear Experts, Please find the

RE: $$Excel-Macros$$ help required

Put this in B Column =TEXT(DATE(LEFT(A4,4),MID(A4,FIND(".",A4,1)-2,2),MID(A4,FIND(".",A4,1)-2,2)) ,"mm/dd/yy") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Tuesday, July 26, 2011 6:17 PM To: excel-macros@googlegroups.com Subject

Re: $$Excel-Macros$$ Need Help for Sumif

can you attach the sample sheet On Tue, Jul 26, 2011 at 4:39 PM, Venkatesh Narla wrote: > Hi All, > Need help for SUMIF Function i am doing time sheet conslidation i am > not able sum up all days for one resource in other TAB > Example: > > > Resource7/1/20117/2/2011

Re: $$Excel-Macros$$ How to exclude a particular character from a series of number - Urgent plz

Oh great, Thank you, Waheed On Tue, Jul 26, 2011 at 7:41 PM, ashish koul wrote: > =SUBSTITUTE(A1,".","") > > > On Tue, Jul 26, 2011 at 4:42 PM, Shaik Waheed wrote: > >> Dear experts, >> >> I want to exclude a particular character from a number. >> For example if the series is like this 01245-13

Re: $$Excel-Macros$$ Please help

=LEN(SUBSTITUTE(a1,"#n/a","")) On Tue, Jul 26, 2011 at 6:05 PM, anil panchal wrote: > Dear Experts, > > Please find the attached file . my questions is i have alphabets & Numbers > both in one cell now i want only count numbers like 123#n/aabcd345677 now i > want 9 > > > > Thanks & Regards > Ani

Re: $$Excel-Macros$$ How to exclude a particular character from a series of number - Urgent plz

=SUBSTITUTE(A1,".","") On Tue, Jul 26, 2011 at 4:42 PM, Shaik Waheed wrote: > Dear experts, > > I want to exclude a particular character from a number. > For example if the series is like this 01245-13. > and suppose I want to exclude "." from the series and want the remaining > number to be as

Re: $$Excel-Macros$$ How to exclude a paritcular character from a series of number

=SUBSTITUTE(A1,".","") On Tue, Jul 26, 2011 at 4:27 PM, Shaik Waheed wrote: > Dear experts, > > I want to exclude a particular character from a number. > For example if the series is like this 01245-13. > and suppose I want to exclude "." from the series and want the remaining > number to be as

$$Excel-Macros$$ Please help

Dear Experts, Please find the attached file . my questions is i have alphabets & Numbers both in one cell now i want only count numbers like 123#n/aabcd345677 now i want 9 Thanks & Regards Anil Kumar 113784 -- ---

$$Excel-Macros$$ How to exclude a paritcular character from a series of number

Dear experts, I want to exclude a particular character from a number. For example if the series is like this 01245-13. and suppose I want to exclude "." from the series and want the remaining number to be as it is. Thanks, Waheed -- --

Re: $$Excel-Macros$$ Date Formula

Hi Daniel Thanks for solving my problem. Nikhil Shah On Tue, Jul 26, 2011 at 5:01 PM, Daniel wrote: > Hello, > > ** ** > > Have a look at the attached workbook. > > ** ** > > Regards. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ How to exclude a particular character from a series of number - Urgent plz

Dear experts, I want to exclude a particular character from a number. For example if the series is like this 01245-13. and suppose I want to exclude "." from the series and want the remaining number to be as it is. Thanks, Waheed -- --

Re: $$Excel-Macros$$ use of indirect function

Hi How the 3rd example sheet works or photo example sheet workds please explain clearly..:) On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer wrote: > Dear Noorain, > > I have gone through your attachment and find it of a graet help. I hope you > wont mind to guide us in a *step by step* *action

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi, In case of MIS Executives the kind of the data sets is very rigid. The data is always in the same format. Mostly the amount of data would also be the same every day/week. The frequency of reports would be also same for them, i.e. the MIS is generated on a weekly, daily or 15 days or quarterly

$$Excel-Macros$$ Need Help for Sumif

Hi All, Need help for SUMIF Function i am doing time sheet conslidation i am not able sum up all days for one resource in other TAB Example: Resource7/1/20117/2/20117/3/2011 7/4/20117/5/20117/6/20117/7/20117/8/2011 7/

Re: $$Excel-Macros$$ Date Formula

for month end date ... =DATE(YEAR(A1),1+MONTH(A1),1)-1 On Tue, Jul 26, 2011 at 12:28 AM, Nikhil Shah wrote: > Dear All Members > > Here I am posting my Question : > > ( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/ > ( 2 ). End Date : 05/05/2016 : Format will be dd/mm/ > > Now

Re: $$Excel-Macros$$ help required

Dear Vijay, Please clear the q4 and q5.. please find the solution. On Tue, Jul 26, 2011 at 6:17 PM, vijayajith VA wrote: > Hi, > > > I have two excel questions.can you help me to solve those questions? > > Thank you > > -- > > -

Re: $$Excel-Macros$$ Two major milestones : 8000 members and 1000+ posts

Great achievement. Best of luck. Regards, DILIPandey On 7/26/11, Ayush wrote: > Dear members, > > I am glad to share that this forum has achieved two major milestones this > month. The number of members have reached 8000 and 1000 posts in a month > which is highest in forum history. > The credi

Re: $$Excel-Macros$$ Two major milestones : 8000 members and 1000+ posts

Hello All, This Group will be my turning point in my lifeWaiting for that Thanks for your help Thank you thank you very much ii Thanks Ayush On Tue, Jul 26, 2011 at 12:18 PM, Venkat CV wrote: > Dear Ayush, > > GreatCongrats... > > *Best Regards,* > *Venkat* > *Chennai

Re: $$Excel-Macros$$ use of indirect function

Hi noorain, Really Wonderful.Thank you very much, On Mon, Jul 25, 2011 at 11:14 PM, NOORAIN ANSARI wrote: > Dear Neil, > > Please see attached sheet with Indirect function example > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

Re: RE: $$Excel-Macros$$ How to prepare your resume...

Dear Bhushan, This is to inform you that as per group policy and rules, any member can not be sent any post which is not related to ms office... check rule number 8 The rules are also available @ this link * please find the below mention lin

$$Excel-Macros$$ help required

Hi, I have two excel questions.can you help me to solve those questions? Thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Thanks all. Formula works but counts one less, so i am adding one manually. Regards, Kaushik ---

RE: $$Excel-Macros$$ Date Formula

Hello, Have a look at the attached workbook. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nikhil Shah Envoyé : lundi 25 juillet 2011 20:58 À : excel-macros@googlegroups.com Cc : Maries waran Objet : $$Excel-Macros$$ Date For

RE: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Hi, =LEN(A1)-LEN(SUBSTITUTE(A1," ","")) Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de KAUSHIK SAVLA Envoyé : mardi 26 juillet 2011 06:07 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Help Required (Excel Function or

Re: $$Excel-Macros$$ Required Latest No. of Drawing - Help

Use maximum formula it will help On Tue, Jul 26, 2011 at 2:22 PM, Rohan Young wrote: > Dear Experts > > I want to make a list drawing in which i required only latest revision > of drawings it can be R3, R5, i need only latest version rest of > previous i do not required in that list please help

Re: $$Excel-Macros$$ Help with find date.

I tested it with dates that exist but still got the same error message. You can try it. Tom On Jul 26, 3:42 pm, "Rajan_Verma" wrote: > If error is coming it means yourdatenot found in that sheet.. > ' On the Top on Module > On Error Goto Err: > > 'Before End sub Statement > Err: > If err.number<

Re: $$Excel-Macros$$ Excel /Adobe

Thanks dear Please let me know how to do it On Tue, Jul 26, 2011 at 1:21 AM, XLS S wrote: > Hey, > > Please find the attachment > > > > > On Mon, Jul 25, 2011 at 2:52 PM, Shrinivas Shevde > wrote: > >> Dear Group >> Please Find attached file . >> Can any one help me to take out adobe fi

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you venkat, Report Generation and Data Management? If you have some examples, can you please provide those? Thanks in advance, Krrish On Tue, Jul 26, 2011 at 11:57 AM, Venkat CV wrote: > Hi Krish, > > MIS Executive Role also Same kind of role as you now doing...Reports > generation & D

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

Hello friends, Please find attachment of array & simple formulae. Thnx Karan www.karanxel.blogspot.com * Kαяαη* On Tue, Jul 26, 2011 at 12:27 PM, Venkat CV wrote: > Dear All, > > any one Explain Difference between Array formula and Normal Formula... > > With Examples..&Use of Array formu