Re: $$Excel-Macros$$ Valiation Query - urgent

thanks priyanka but i need another way when i type manually on particular cell , auto pickup related that value. (e.g. if i type *choc *and click on drop down arrow it will display the related name of* choc.* On Tue, Jan 24, 2012 at 12:40 PM, PrIyAnKa wrote: > Dear Dhartikumar > > Kindly see i

Re: $$Excel-Macros$$ Valiation Query - urgent

Dear Dhartikumar Kindly see if below example solves your quarry *xample: Creating a drop down list with data on a different worksheet* For help with this example, see the image above. 1. Enter the following data into the correct cells on*Sheet 1* or a worksheet: *E1* - The Cookie Sho

$$Excel-Macros$$ Valiation Query - urgent

Hi Experts I have a data of 1000 names in Sheet2, required dropdown validation in sheet1, cell A1 query: if i type some name on cell A1 then it display only the related on that name. it's an urgent -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capit

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

I pasted this line in macro last portion as mentioned below:- Sheets(“sheet1”).UsedRange.Value = Sheets(“sheet1”).UsedRange.Value Sheets("Sheet1").Copy End Sub I am getting message Complie Error: Variable not defined with yellow selection at Sheet1. Please help in this matter. Thanks Regrads, Za

RE: $$Excel-Macros$$ Re: To List some Values

Try this : =OFFSET(INDEX($F$6:$F$80,MATCH(E5,F6:F80,0),1),,2,COUNTIF(F:F,E5)) with CSE Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Mon/2012 12:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ R

Re: $$Excel-Macros$$ saving in different placements of an excelsheet

And for printing Private Sub CommandButton2_Click() Worksheets("Page1").PrintOut Worksheets("Page2").PrintOut End Sub Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 6:44 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > use below code format for your query.. > > Private Sub cmdsave_Cl

Re: $$Excel-Macros$$ Dept wise Add New GL Code

hi Noorain here with attached Excel sheet more informattive Regards chandru On Mon, Jan 23, 2012 at 6:46 PM, NOORAIN ANSARI wrote: > Dear Chandra, > > Please explain more > > > On Mon, Jan 23, 2012 at 1:48 PM, chandra sekaran > wrote: > >> Dear Excel-Macro Family >> >> I have T

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Oops. I also should have added this to change formulas to values before copy sheets(“sheet1”).usedrange.value=sheets(“sheet1”).usedrange.value Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Monday, January 23, 2012 9:21 AM To: excel-macros@googlegroups.com Su

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Thanks, Sam. That is correct. I USUALLY do use option explicit. Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Monday, January 23, 2012 9:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently) >F

Re: $$Excel-Macros$$ Solution required. (the required through Coding)

Thank you soo much (Noorain & Sam) On Jan 23, 6:44 am, NOORAIN ANSARI wrote: > Excellent Solution SAM > > On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko wrote: > > > > > > > > > > > Here's how you do it with code > > > Regards, > > Sam Mathai Chacko > > > On Mon, Jan 23,

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

>From what Don intended, I believe it is Dim i as long, lr as long, lc as long, mf as range Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 8:47 PM, Zafar Iqbal wrote: > Sir, Thanks for it. Just please guide me about i, lr, lc and mf. I > think that first three are to be defined as int

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Sir, Thanks for it. Just please guide me about i, lr, lc and mf. I think that first three are to be defined as integer. What will be mf? macro will run when we define these items. Regards, Zafar Iqbal On Jan 23, 6:07 pm, Sam Mathai Chacko wrote: > Zafar, your numbers are all coming correct. For t

Re: $$Excel-Macros$$ Converting pdf to excel?

Hi Sam, In your email there is no attachment or print screen. can you please let me know which window you are getting? Regards, Kaushik -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ Converting pdf to excel?

Hi Sam, I have Acrobat 9 installed in my system. Pls suggest. Regards, Kaushik Savla -- 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

Re: $$Excel-Macros$$ Converting pdf to excel?

Which means you do not have Acrobat 9 installed. The code will not work without that. Sam Mathai Chacko On Mon, Jan 23, 2012 at 8:27 PM, KAUSHIK SAVLA wrote: > Hi Noorain, > > Unable to find anything as reference in tools option in Acrobat 9. > > Please suggest. > > Regards, > Kaushik > > -- > F

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Zafar, your numbers are all coming correct. For the date format, all you need to do is format the series to "d-mmm" Why do you need a macro for that? Keep the custom format, and it will always remain. Sam Mathai Chacko On Mon, Jan 23, 2012 at 8:15 PM, Zafar Iqbal wrote: > We have to define i,

Re: $$Excel-Macros$$ Converting pdf to excel?

Hi Noorain, Unable to find anything as reference in tools option in Acrobat 9. Please suggest. Regards, Kaushik -- 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 Pr

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

We have to define i, lr, lc and mf. I tried with Dim i as integer, Dim lr as Inetger, Dim lc as Integer. But what is mf? I do not know. Please help. Thanks On Jan 23, 5:26 pm, "dguillett1" wrote: > Finds last row and last column and formats range and copies sheet1 to new > book without formulas.

Re: $$Excel-Macros$$ Solution required. (the required through Coding)

Excellent Solution SAM On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko wrote: > Here's how you do it with code > > Regards, > Sam Mathai Chacko > > On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI > wrote: > > PFA > > > > > > On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI < > noor

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Finds last row and last column and formats range and copies sheet1 to new book without formulas. Sub CopyShtwithTWOdecimals() For i = 1 To Sheets.Count With Sheets(i) lr = .Cells.Find("*", Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row lc = .Cells.Find("*", Cells(Rows.Count, C

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Sir, Now, graph table is more correct. Last thing remaining is date format in graph. Right now, In graph table, date format (23-Jan) is converted to number format (40931). I need 23-Jan instead of 40931. Regards, Zafar Iqbal On Jan 23, 4:57 pm, Sam Mathai Chacko wrote: > Well, this should round

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Dear Mr. *Sam Mathai Chacko,* Your macro works fine in parent file. When I copy Sheet1 only to new file, data in graph table needs a little attention. Dates are converted to numbers (23-Jan-2012 becomes 40931 and so on). Macro converted grapgh data to 2 decimals in parent file. However, in copied n

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Well, this should round it. Replace it in the file I sent earlier. Sub FormatNumbersTo2Decimals() Dim wks As Worksheet Dim rng As Range For Each wks In ThisWorkbook.Worksheets For Each rng In wks.Cells.SpecialCells(2, 1) If IsNumeric(rng.Text) Then rng.N

Re: $$Excel-Macros$$ Proportionate calculation

You will have to enter 01-05-2012, or you will have to enter 05-Jan-2012 Otherwise, everything works fine. By the way, what's with all days having 30 days? Jan has 31, Feb never has 30.. If you really are worried about the 30, use Private Sub CommandButton1_Click() Dim lngDays As Long, ln

Re: $$Excel-Macros$$ Solution required. (the required through Coding)

Here's how you do it with code Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI wrote: > PFA > > > On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI > wrote: >> >> Dear Prince, >> >> Please select filtered data, press alt+; then copy and paste >> >> or >> >> Select Data

Re: $$Excel-Macros$$ Proportionate calculation

Without looking too close, try /30 Don Guillett SalesAid Software dguille...@gmail.com From: Shankar Bheema Sent: Monday, January 23, 2012 4:06 AM To: excel-macros@googlegroups.com ; Sam Mathai Chacko Subject: Re: $$Excel-Macros$$ Proportionate calculation Dear sir, I attached the excel file

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Dear Sir, I have already tried it. Yet, as per your instructions, I did the same again. There are two problems. First is that decimals in print view are surely two only but in actual it may remains more than two in background. If we increase decimals places it will be viewable, again. I need result

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Here's the macro. File attached too. Sub FormatNumbersTo2Decimals() Dim wks As Worksheet Dim rng As Range For Each wks In ThisWorkbook.Worksheets For Each rng In wks.Cells.SpecialCells(2, 1) If IsNumeric(rng.Text) Then rng.NumberFormat = "0.00"

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Maybe?? Sub twodecimalscopy() Sheets("Sheet2").Cells.Style = "Comma" Sheets("Sheet1").Cells.Style = "Comma" Sheets("Sheet1").Copy End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Zafar Iqbal Sent: Monday, January 23, 2012 2:58 AM To: excel-macros@googlegroups.com Subject: $$Ex

Re: $$Excel-Macros$$ Solution required. (the required through Coding)

Dear Prince, Please select filtered data, press alt+; then copy and paste or Select Data and press ctrl+g and click on Visible cells only then copy and paste Hope it will help to you. On Mon, Jan 23, 2012 at 5:05 PM, prince sethi wrote: > Dear Excel Guru !!! > > I need the solution for a quer

$$Excel-Macros$$ Solution required. (the required through Coding)

Dear Excel Guru !!! I need the solution for a query. Suppose i am having below data. I am having start date, & End Date. I want data should be filtered & copy to another location. I am able to do so by applying fileter but facing its taking all the record while i want visible records only.. Da

$$Excel-Macros$$ JOB

The sender of this email is registered with Naukri.com as Trigent Software Limited (Staffing Division) *Experience required for the Job:* 3 - 10 years *Job Location:* Gurgaon Apply Now

Re: $$Excel-Macros$$ Dept wise Add New GL Code

Dear Chandra, Please explain more On Mon, Jan 23, 2012 at 1:48 PM, chandra sekaran wrote: > Dear Excel-Macro Family > > I have Two sheet Like Data & Deptwise , Data Sheet Data are comes > from our ERP Software , Deptwise Sheet having Deptemnt wise expenses > consoliated >

Re: $$Excel-Macros$$ saving in different placements of an excelsheet

Dear Bheema, use below code format for your query.. Private Sub cmdsave_Click() With Sheet1 with Userform1 .Range("F3")=.Name .Range("F4")=.Design .Range("F6")=.Dob .Range("F7")=.Doj .Range("F8")=.DOR .Range("F11")=.DOR .Range("E11")=.DOJ .Range("D29")=.Pay .Range("H29")=.GP .Range("B40")=.Pay .

Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Dear Zafar, First copy and value paste in New Sheet.. Again copy and Select data of new sheet and Format paste . Hope it will help to you. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ queary about translate

Hi Friends, I have a excel file which have data in hindi, I have to translate in english, there is any softwear or way to solve my problem plz tell me. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Why my Excel procedure disappears?

Mr NOORAIN ANSARI Congratulations. It works very well. See alternative solution at Sam Mathai Chacko reply. Thanks a lot. On 22 jan, 14:20, NOORAIN ANSARI wrote: > Dear Nathan, > > Problem #1 is that your MainProcedure has strLeter as the parameter name, > but you test for strLetra.  strLetra

Re: $$Excel-Macros$$ Why my Excel procedure disappears?

Dear Sam Mathai Chacko On target! It worked very well. The quotes rules is a little confuse and I never read anything about it in Excel books. Thanks a lot. Nathan On 22 jan, 17:16, Sam Mathai Chacko wrote: > Nathan, > > The REAL problem is as I mentioned in using the quotes. And if the > int

Re: $$Excel-Macros$$ Re: To List some Values

Dear Excel_Lover, See attached sheet. Actually used formula is an array function, which take little time comparison to Normal Function. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Re: To List some Values

Dear Noorain, Can we use any other formula which will work little fast, as it takes little more time while I applied in my original data. On Mon, Jan 23, 2012 at 10:11 AM, NOORAIN ANSARI wrote: > Dear Excel Lover, > > Please check and change value of Cell E1. > > > > Thanks & regards, > Noorain

$$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)

Dear Experts, Attached is an Sample file Excel-2003 with 03 Sheets linked with each others. Sheet1 is linked with data from Sheet2 by Hlookup / index formulas and it has Data Validation at Cell H1, too. Chart in this Sheet1 is also linked with Data at Sheet2. Sheet3 will get data by Paste Special

$$Excel-Macros$$ Dept wise Add New GL Code

Dear Excel-Macro Family I have Two sheet Like Data & Deptwise , Data Sheet Data are comes from our ERP Software , Deptwise Sheet having Deptemnt wise expenses consoliated i have GL Code in my Data sheet but i donot have Deptwise sheet this gl code automatically add to my Deptwise

$$Excel-Macros$$ auto change of the combobox data

Dear Experts In an excel book, each sheet is named with the designation of the employee and that particular sheet contains the names of that particular designation. I placed two combo boxes on the userform, how to link the corresponding data into the comboboxes with an option that choosing a desi