Re: $$Excel-Macros$$ Help With UserForms

2011-01-29 Thread Ashish Pradhan
Hello Hanumant Thanks a lot for the effort at explaining the adding of a drop down list in a combo box. I guess the only way to actually learn is to get basic guidance from experts like you and then to actually try it for oneself. Unless basic users like myself don't try it for ourselves, we

Re: FW: $$Excel-Macros$$ Help Required_pdf file conversion

2011-01-29 Thread Umesh Dev
Hi Vikram, Its working in my sys. if its not working on your sys then let me know where the file is saved and also where your acro-reader is saved. Regards Umesh Dev On Sat, Jan 29, 2011 at 12:50 PM, vikram wrote: > Hi, > > > > Please help regarding below query as I need this on urgent basis

$$Excel-Macros$$ Please help

2011-01-29 Thread sudhir kumar
Dear Experts Please help see my attachement and help me. thanking you -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. Mngr. A/c's P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!

Re: $$Excel-Macros$$ Please help

2011-01-29 Thread ashish koul
use sumif check the attachment On Sat, Jan 29, 2011 at 9:43 PM, sudhir kumar wrote: > Dear Experts > > > Please help see my attachement and help me. > > > thanking you > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > > P think Bef

RE: $$Excel-Macros$$ Please help

2011-01-29 Thread D M Sukumar
Hai groups, Can you tell me what is the use of $ sign excel And can you give some examples please;;; Thank you From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

RE: $$Excel-Macros$$ Subtotal

2011-01-29 Thread D M Sukumar
Hello excel and macros experts; Can you mail some examples of excel and macros with worksheets. Thank you -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Please help

2011-01-29 Thread Paul Schreiner
I'm assuming you mean in a Cell formula. the $ is an "anchor". Let's say you have a column of numbers in column "A" rows 2-10. In row 1 you have different numbers in column "B" through "E" so it looks like: X 1 2 3 1 2 3 Now, in the rest of the rows and columns you want to multiply the value in c

Re: $$Excel-Macros$$ Please help

2011-01-29 Thread hanumant shinde
Hi Sukumar, $ is used for making the range static. i.e making the range fixed and it will not chnage even if you copy paste the same formula in below cells. eg. lets say u have data from Cells A2 to A20 if you write your formula in B2 as =sum(A2:A20) and copy paste the same formula in cell B3 y

Re: $$Excel-Macros$$ Subtotal

2011-01-29 Thread Srinivasan Ethirajalu
chk this one On Sat, Jan 29, 2011 at 11:04 PM, D M Sukumar wrote: > Hello excel and macros experts; > > > > Can you mail some examples of excel and macros with worksheets. > > > > Thank you > > > > > > > > > > > --

Re: $$Excel-Macros$$ query for a solution

2011-01-29 Thread Ms-Exl-Learner .
Hi Thamu, I don't know what is the need for the comparison of 2003 & 2007 excel column versions since the query is not very much related to the 2003 column issue. I agree that the column will be the issue in Excel 2003 when the repetition of UNIQUE IDNO goes beyond 127 times then we could not abl