$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-23 Thread Dilip Pandey
Rightly said Harmeet..!! -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Mar 23, 2009 at 12:42 PM, Harmeet Singh wrote: > Hi Maddy, > > Attched file is updated by Sort function. > > Trust me for one thi

$$Excel-Macros$$ Re: Reg. Output to be more viewable

2009-03-23 Thread raafi barey
Dear Ashish It would be really appreciated if you could help me, i am very very bad with excel, how would i be able to display details using pivot tables.., itried using pivot bt i m nt gettng the reuired o/p. Pls advice Regards Raafi On 3/23/09, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi

$$Excel-Macros$$ Re: Convert PDF to Excel

2009-03-23 Thread Kuldeep Vashishtha
Dear All Use below mentioned link http://rapidshare.com/files/189830453/Able2Extract_Professional_v6.0.0.0.rar not required PIN no. checked by me. If any query mark mail me. Thanks & Regards Kuldeep _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googleg

$$Excel-Macros$$ Re: Convert pdf to excel

2009-03-23 Thread ashish damor
Dear Sir, I have also downloaded the software. Please provide me the pin no. Thanks 4 ur support regards, ashish On Mon, Mar 23, 2009 at 9:59 AM, nehal sejpal wrote: > Dear Manoj, > > I already download the software kindly provide me the PIN No.Thanks in > advance. > > With Regards, > Nehal A.

$$Excel-Macros$$ Re: Convert pdf to excel

2009-03-23 Thread jebby jacob
Dear Sir, I have also downloaded the software. Please provide me the pin no. Thanks 4 ur support regards, jebby On Mon, Mar 23, 2009 at 10:51 AM, ashish damor wrote: > Dear Sir, > > I have also downloaded the software. Please provide me the pin no. > > Thanks 4 ur support > > regards, > ashis

$$Excel-Macros$$ Re: Getting Run-time error 13 Type Mismatch by VBA Macro

2009-03-23 Thread xmux
Hi, Thanks for the tip :) It is working without any error but there is another problem now. If i right the AT, or one of them it doesnt recognize... why it can be? Thanks On Mar 23, 3:48 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi xmux, > > This is totally invalid, since you're applying OR

$$Excel-Macros$$ Re: Convert pdf to excel

2009-03-23 Thread Sudesh Kumar Dugar
Dear Manoj Please also send me the pin no. Regards, Sudesh Kumar Dugar sudes...@gmail.com On Mon, Mar 23, 2009 at 10:44 AM, Pinaki Kar wrote: > Dear Manoj > I already download the software kindly provide me the PIN No > > Thanks & with Regds, > > Pinaki Kar > > I Don't Know the key to success,

$$Excel-Macros$$ Re: Fixed Assets Management Software

2009-03-23 Thread Johnson . Dara
Hi Sandeep, My appologies for late replying. When you move to a ERP (Oracle, SAP etc.,) it will take care of your FA requirements. There is no point to go for a software for FA alone. Becasue, at the end of the day the software what you bought may not able integrated to your accounting ERP.

$$Excel-Macros$$

2009-03-23 Thread Joe Mosley
Hi chaps, Can anyone please tell me how I disable the flood of emails I get from Excel Googlegroups other than those pertinent to any questions I post myself ?? Thank you Joe --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Convert pdf to excel

2009-03-23 Thread vaibhav joshi
Dear Manoj I Have Already dwnd the software,Kindly provide me PIN No Thanks Vaibhav On Mon, Mar 23, 2009 at 6:02 AM, Sudesh Kumar Dugar wrote: > Dear Manoj > > Please also send me the pin no. > > Regards, > Sudesh Kumar Dugar > sudes...@gmail.com > > > On Mon, Mar 23, 2009 at 10:44 AM, Pinaki Ka

$$Excel-Macros$$ Re: Reg. Output to be more viewable

2009-03-23 Thread Harmeet Singh
Hi, Good question, Just double click on the data (Pivot) for which you need the detail. On Mon, Mar 23, 2009 at 1:07 PM, raafi barey wrote: > > Dear Ashish > > It would be really appreciated if you could help me, i am very very > bad with excel, how would i be able to display details using pivo

$$Excel-Macros$$ Re: Getting Run-time error 13 Type Mismatch by VBA Macro

2009-03-23 Thread Tom Jeffries
An Alternative Solution: Public Function IsAcct(code As String) As Boolean Dim Acct Dim Found As Boolean Acct = Array( _ "AD", "AE", "AF", "AG", "AI", "AL", "AM", "AN", "AO", _ "AQ", "AR", "AS", "AT", "AU", "AW", "AX", "AZ", "BA", _ "BB", "BD", "BE", "BF", "BG",

$$Excel-Macros$$ User input as an argument in duplicate deletion macro

2009-03-23 Thread First Casualty
Hi, I'm putting together a macro that will allow a user to select two separate workbooks and compare one column in each workbook to find any matches across them. Where there is a match it will copy the row to a third sheet and delete it from the original sheet, before moving on to the next value.

$$Excel-Macros$$ Excel Problem

2009-03-23 Thread Puzzled
I have an excel spreadsheet that has multiple calcluations. There are a couple of circular references that I need in this worksheet so that iterations are performed to give me an overall totals. When new data is input in the spreadsheet, it should recalculate the totals using the existing data b

$$Excel-Macros$$ Customizing footer so page # is on outside

2009-03-23 Thread ulandre...@gmail.com
I'm trying to find a VBA solution so that the footer for my multi-page spreadsheet has the page # on the outside. This is trivial in Word as it has an odd-and-even footer option. My initial thought is to take the current page # with the mod 2 function to determine if the page is odd or even. Then

$$Excel-Macros$$ Re: Subtract values that are in different rows

2009-03-23 Thread Jacobsen, Doug
Thanks Harmeet, worked perfectly and a definite improvement on my solution. Regards, Doug Jacobsen | Staff Business Analyst, OM From: Harmeet Singh [mailto:harmeet.hew...@gmail.com] Sent: Saturday, March 21, 2009 5:48 AM To: excel-macros@googlegroups.com Cc: Jacobsen, Doug Subject: Re

$$Excel-Macros$$ Re: User input as an argument in duplicate deletion macro

2009-03-23 Thread Dave Bonallack
Hi, You need to use an input box, not a message box. Instead of: MsgBox ("Select Source sheet against which data will be checked") Use: Ans = Inputbox("Select Source sheet against which data will be checked") The Ans variable will contain whatever the user inputs. Remember that when asking

$$Excel-Macros$$ RE: $$Excel-Macros$$

2009-03-23 Thread Dave Bonallack
Hi Joe, The reason you get the flood of emails not solely pertaining to yourself is so that perhaps you can help others with their problems, and not simply receive solutions to your own. This is how the group works - everyone pitching in. Regards - Dave. From: j...@it4u.co.uk To: excel-mac

$$Excel-Macros$$ Re: Calling all Wizard - Help needed in attached file

2009-03-23 Thread jayendra gaurav
Where is sc file ??. On Wed, Feb 25, 2009 at 6:25 AM, Tom Jeffries wrote: > Take a look at the attached workbook and see if it does what you want. I > placed buttons on the "SC" worksheet for each function you describe. I > wasn't sure how you wanted to export the SC worksheet as text so I exp

$$Excel-Macros$$ Re: Customizing footer so page # is on outside

2009-03-23 Thread Akhilesh Karna
Hi, You may not be able to set different footer for each page in Excel (I may be wrong). However, you can print out your document with the conditional placing of footer using the following code. 'Start- Sub setFooter(pageType As String) ' If pageT

$$Excel-Macros$$ Re: amt in words in excel add-in

2009-03-23 Thread Gohar Shahab
how can I add some other currency codes On Mon, Mar 23, 2009 at 9:48 PM, harsh shah wrote: > dear all, > > i hope these files might be of some use. > > > > > AmtInWords.xla is attached to this mail. It is an MS Excel Add-in to > convert amount available in figures to words. > Installation > Copy

$$Excel-Macros$$ Re: 2nd Anniversary - Surprise Gift for Top Posters on Mar16

2009-03-23 Thread awesome.akash
Congrats to all winners. Grt wrk. Ashish Jain wrote: > Hi Community Members, > > Congratulations and Thanks to all of our members for being part of > this community and helping each other as much as possible by you. > We've recognized the following posters as the top posters keeping > community a

$$Excel-Macros$$ help needed

2009-03-23 Thread santosh subudhi
Hello All, Can any one help me where i can get free download for how do the check box and the option buttons work with formulas and macros. Regards Santosh --~--~-~--~~~---~--~~ -