Re: $$Excel-Macros$$ Re: How to match a combobox result with an textbox

To move to the correct sheet, after each Case " " You need to add the following command: Example Case "material" ActiveWorkbook.Sheets("material").Activate Case "worklabor" ActiveWorkbook.Sheets("worklabor").Activate Case "Equipments" ActiveWorkbook.Sheets("Equipments").Activate 2014-03-29 2

Re: $$Excel-Macros$$ Interaction between worksheet using Userforms

You need to design your bill, File attached, you need to know the data is Cell Ayo bill does? To enter data for faster, you should use Form Sheet. 2014-05-07 20:39 GMT+07:00 Sherin : > Hi I need to create a userform that selects data from one worksheet(sales) > and then create an invoice in an

Re: $$Excel-Macros$$ Macro required

TEAR SHEET: Press the button "Separation sheet and name". ELIMINATION OF SHEET: Press the button "Delete sheet detached". 2014-05-07 14:12 GMT+07:00 Shrinivas Shevde : > Very very thanks > > > On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote: > >> Hi >> >> Yes you can paste data in mast

Re: $$Excel-Macros$$ plz solve my query sorting and unique data

Advanced use fiter to remove duplicates, sort and normal. 2014-06-21 18:12 GMT+07:00 Abhishek Jain : > Not sure if your output has anything to do with sorting. Remove Duplicates > (under Data tab) will give you the same results. > > Regards, Abhishek > > > On Sat, Jun 21, 2014 at 4:11 PM, Soura

Re: $$Excel-Macros$$ Need a help in Pivot

t; On 29-Jun-2014 12:18 PM, "Ganesh N" wrote: > >> Hi, >> >> Thank. But there is any way to get the details without changing the >> structural ? >> >> Because the initial one is the format which use to have. >> >> Thanks >>

Re: $$Excel-Macros$$ Sort VBA Code Modified

ject does not > support this property or method" in excel.Pls give me proper guidance > Regards > Amar > > On Mon, Jun 30, 2014 at 10:17 AM, amar takale > wrote: > > Dear Bé Trần Văn > > > > Thanks very much sir. but i ask you small issue can we us

Re: $$Excel-Macros$$ Sort VBA Code Modified

"H7") Sort column K Range("H7") 2014-07-01 12:40 GMT+07:00 amar takale : > Dear Bé Trần Văn > > Code is good but required data sort each column but code sort data on > basis of D7 cell only ,if i want sort it another column then need to > change cell numbers e

Re: $$Excel-Macros$$ Date addition required

In Cell (C5:Z13) type: NN (Think 1 day), N (Think again day), Y (Dates of Rest) to see results 2014-08-03 14:17 GMT+07:00 Rajeev : > Dear Experts, > > > > I need help that in my worksheet Where I entered dates (Sheet1) in column > A, in column B I have entered “Y” as working days and “N” as no

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 5 updates in 4 topics

p> >> >> Date addition required >> <http://groups.google.com/group/excel-macros/t/375ee1ed1e20342d> >> >>"Rajeev" Aug 03 12:47PM +0530 >> >>Dear Experts, >> >> >> >>I need help that in my worksheet Whe

Re: $$Excel-Macros$$ Filter Issue

At E2 (sheet Advanced Filter), Select >=113 300 or <=10 To get results. 2014-08-14 22:12 GMT+07:00 Paul Schreiner : > I don't believe you can do it with a FORMULA. > But you can do it with a Change Event macro. > > You would create an autoFilter for rows 5-### > Then, record a macro in wh

Re: $$Excel-Macros$$ Filter

B2 select and click the Filter button to filter, Type in C2 or D2 and click the Filter button to filter. 2014-08-30 19:20 GMT+07:00 daya p : > Hi Friends, > > I need help regarding filter data > form with 3 combo box & label > > 1st combo i select INDIA > next if i select State (in2nd combo)

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

At A7 sheet Homepage, select Office. GET FILE button to select the file and get into 2014-08-30 22:10 GMT+07:00 Eugene Bernard : > Mr Basole, > > Thanks for the attachements, > > I am getting an error msg as in the attachment, even after adding Ms-ado > object library. > > [image: Inline image

Re: $$Excel-Macros$$ Filter

DIA Goa Panaji margao INDIA Goa Panaji > vasco INDIA Gujarat Gandhinagar Ahmedabad INDIA Gujarat Gandhinagar > Vadodara > > > On 30 August 2014 20:41, Bé Trần Văn wrote: > >> B2 select and click the Filter button to filter, >> >> Type in C2 or D2 and click the Fil

Re: $$Excel-Macros$$ Need help to create a user form.

Opening a file to show form. To import the data: Typing data into the form and click the Data Entry To edit data:Click listbox to select data, The data will appear on the form, Edit the data needed, and click Edit Data. 2014-11-12 13:34 GMT+07:00 Kamal Ganeshan : > Hi All, > > I want you to

$$Excel-Macros$$ Filtering and data assignments

I have Data Sheet "DS_Capdoi". I need to filter and assign data sheet as "Xong" But Macro in sheet "Ket Qua" is not true desire as sheet "Xong". Please do correct me Maco, or replaced with a new Macro. Sincere thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It

Re: $$Excel-Macros$$ cells.find

You refer to File. 2014-12-19 23:32 GMT+07:00 : > > Hi Ashish, > > Yes, want to fetch a address of a cell containing particular word. > > > On Friday, December 19, 2014 9:00:43 PM UTC+5:30, Ashish Kumar wrote: >> >> Hi ashakala, >> >> you want to find specific word in sheet. >> >> >> >> On 19 Dece

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

Preview File, you change the sheet name is not affected. 2014-12-23 22:44 GMT+07:00 Vaibhav Joshi : > Glad this helped you. > > Cheers!! > On Dec 23, 2014 9:10 PM, "bobengler" wrote: > >> Thank you for your time and expertise. It's good to know there is good >> support out there. >> >> Bob Engle

Re: $$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

Right click on the name sheet, then paste the following code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Target.Interior.ColorIndex = 40 End Sub 2018-02-12 15:02 GMT+07:00 who : > Sorry for the previous post. It works, but also contains so

Re: $$Excel-Macros$$ AssignMacro to Shape - for a Userform

You put the code in the module 2015-01-18 12:28 GMT+07:00 sswcharlie : > Hi > > Trying to get a macro assigned to open a userform. The macro does not > show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the > net) > > Sub... > UserForm1.Show > EndSub > > but userform still does

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

B3 selected in the drop down list, View Results. 2015-07-21 19:08 GMT+07:00 Paul Schreiner : > First: > Your EMP ID field is mixed with "text" and "numbers". > Probably because this list was imported from another source. > (generated a report as a text file and opened it in Excel?) > > then, if y

Re: $$Excel-Macros$$ Assigning names to sheet

View attachments 2015-12-26 23:54 GMT+07:00 Ashish Koul : > Sub loop_shts() > Dim cl As Range > > For Each cl In Sheets("Sheet1").Range("a1:a571") > ThisWorkbook.Sheets.Add > after:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count) > ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count).Name = cl.V

Re: $$Excel-Macros$$ VB Code to open a worksheet based on a list of worksheet names

Click Button to Hyperlink to Worksheets. If more Add Worksheet, then Copy and Paste to Button ABOUT MAIN 2016-01-13 5:19 GMT+07:00 Rob Flott : > I have a workbook with nearly 200 worksheets. Each worksheet is named for > a specific retailer. > Included in this workbook is a sheet listing 75 of

Re: $$Excel-Macros$$ search via macro like excel

> > ** > > 2012/2/21 Maries > Hi Prajakt, > > Please find the attached file.I have used below codes in user form. > > Private Sub CommandButton1_Click() > > Dim rng1 As Range > Dim lll As Integer > > Sheets("Sheet2").Select > Cells.Select > Selection.ClearContents > > lll = Len(Te

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

2012/2/23 Abhishek Jain > Thanks Noorain sir for your kind words but its the original coder who > deserves the applause. > > Veeru, I will have a look in your new requirement after a few hours though > I am sure one of the experts from the group would address this by that > time. > > Thanks > > A

Re: $$Excel-Macros$$ Re: Required Name

2012/2/23 Kris > Hi > > In C16 and copied down, > > =INDEX($A$2:$A$12,MATCH(B16,INDEX($B$2:$F$12,,MATCH(A16,$B$1:$F$1,0)),0)) > > Kris > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need

Re: $$Excel-Macros$$ VBA Help

2012/3/9 NOORAIN ANSARI > Dear pavan, > > Apart of Mahesh code, > You can use also below code to close all excel application even > Thisworkbook also > > Sub Excel_Application_Close() > Dim wb As Workbook > For Each wb In ActiveWorkbook > wb.Close Savechanges:=True > Next > Application.Quit > End

Re: $$Excel-Macros$$ date should be today's date in calendar in user form of excel

2012/3/25 Raj Mahapatra > please find the attached file and click "RUN ENTRY" > Then Click 'Transcation Date" > > Thanks & Regards > > > On Sat, Mar 24, 2012 at 12:30 PM, Asa Rossoff wrote: > >> Hi Raj, >> >> Can you attach a sample file? >> >> ** ** >> >> *From:* excel-macros@googlegro

Re: $$Excel-Macros$$ Help Please

2012/3/31 NOORAIN ANSARI > Very useful link Ashish, Thanks to sharing with group > > > On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > >> http://www.rondebruin.nl/ribbon.htm#Examples >> >> >> >> >> On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: >> >>> >>> >>> On Fri, Mar 30, 2012 at

Re: $$Excel-Macros$$ Multi Combo Box

2012/5/2 Rajan_Verma > Hi Chandru > > Please find the attached sheet, you can use list validation for that.. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012/5/4 Deba Ranjan > *Congrats Rajan Shahab, > >And Thanks every member of Excel forum who have devoted their times in > analytical for solving problem and vice versa. > * > > > Thanks & Regards,* > * > > *Deba Ranjan P*** > > > > On Fri, May 4, 2012 at 2:45 PM, Ankit Agrawal > wrote: > >>

Re: $$Excel-Macros$$ Need macro website

** 2012/5/5 Maries > Hi, > > Check below link, > > http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm > > > Regards, > > MARIES. > > > On Sat, May 5, 2012 at 4:41 AM, karthik N wrote: > >> Hi Friends, >> >> >> How learn the macro's in step by step,kindly provide the any macro >>

Re: $$Excel-Macros$$ match 2 columns

2012/5/7 ╰» ℓαℓιт мσαнη > Dear Sara, > > PFA > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation* > > > > On Sun, May 6, 2012 at 11:35 PM, Sara Lee wrote: > >> hi >> i would like to have wgt column in sheet 1 updated

Re: $$Excel-Macros$$ Fwd: Need help on data

2012/5/9 Lokesh Loki > Hai Anil, > > Thanks for resolving the query and thanks for advising me about the user > form. > > Once again thank a lot experts. > > Regards > Lokesh.M > > On Wed, May 9, 2012 at 2:42 PM, Anil Gawli wrote: > >> Attached is the workbook and go to Calculation worksheet. >>

Re: $$Excel-Macros$$ Form tracker and new base-1

tached File >> On Mon, May 21, 2012 at 10:46 AM, Deba Ranjan wrote: >> >>> *Hi experts, >>> >>> Please find the attached file. There you will find that *Bé Trần Văn >>> sir has done his best to solved my problem. Thank you very much Bé Trần >>> Văn sir

Re: $$Excel-Macros$$ help in matching data in excel sheet

2012/5/19 Rajan_Verma > Sample file?? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cute Awesome > *Sent:* 19 May 2012 6:13 > *To:* excel-macros@go

Re: $$Excel-Macros$$ Drop down list

gt;>> On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote: >>> >>>> your attached file is corrupted and cannot be opned? >>>> Regards >>>> Gawli Anil >>>> >>>> On Tue, May 22, 2012 at 12:20 AM, Bé Trần Văn < >>&g

Re: $$Excel-Macros$$ can we round figer any amount.

2012/5/30 NOORAIN ANSARI > Dear Anil, > > Please try > > *=ROUND(B3,-5)* > > > On Wed, May 30, 2012 at 4:57 PM, anil kumar wrote: > >> Hello everybody, >> >> I have a queary. can we round figer any amount. >> >> exp. >> Amount Round figer >> 975567.65 10.00 >> 732530.60

$$Excel-Macros$$ Programming VBA

Thank excel-macros@googlegroups.com have sent me message, thank you very much. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ How to load data into Combo box in user form

Welcome rajanverma1...@gmail.com, have two ways to set upa List in the Combobox. 01 ways: in the window Propeties Section RowSource you enterthe address of the data you want included in CoboBox. For example, G3: G20 (type a list from G 3 to cell G20) is the listthat appears when you click on CoboB

Re: $$Excel-Macros$$ Reasons for increase in excel file size

2011/9/7 Amit Desai (MERU) > What could be the reason for increase in excel file? I have a file with > size of 4.5 MB, but data contents are not that much. > > ** ** > > You can do the following: > - First you file your virus scanner. > - Then select all the rows and columns and delete it. >

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012/6/22 ChilExcel > /\ \ __ /\_ \ > /\_ \ > ___ \ \ \___ /\_\\//\ \ __ __ ____ > __\//\ \ > /'___\\ \ _ `\\/\ \ \ \ \/'__`\/\ \/'\ /'___\ > /'__`\\ \ \ >/\ \__/ \ \ \ \ \\ \ \ \_\ \_ /\ __/\/>

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Congratulations *Ashish **koul* and *Dilip Pandey*. The help, the second great forum you will make more and better. 2012/7/3 Deba Ranjan > Dear Ashish and Dilip. > > Sorry for the delay, its a really awesome stage. heartiest congratulate > to both and please keep helping to this group. > > > T

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

Congratulations *Ashish koul* and *Dilip Pandey* . 2 you wish to continue to contribute increasingly good forum. 2012/7/3 pankaj gmail account > Dear Moderator, > > Please also Ban these kinds of Promotional/Advertisements in this forum. > > They are not related to Excel Help. > > Please advice

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Show group already have 03 users received decode of the Microsoft, real absolute. I am tham community this because it very useful to add comments expression cho me also like all all user. Sorry, I was busy at the work group, wish all the members of this forum to achieve importan

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

I just want to congratulate Ashish and Dilip. and contributions that you want two more forums. 2012/7/4 Ayush Jain > Pankaj, > > Please let me know which advertisements you are referring to. > > Thanks, > > > On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote: > >> Dear Moderator, >> >> Plea

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Ashish. My name: Trần Văn Bé, of birth 1957, as state employees. Form: Việt Nam I love Excel and a member of the forum, when the new free visit, to exchange knowledge and help other members on the board, I have participated less frequently for free time. 2012/7/16 kumar.ashish861 > Hi All, >

Re: $$Excel-Macros$$ Vlookup Problem

Do as you like. 2012/7/17 Venkatesh Narla > Hi, > Please find the attachment and let me know.. any thing els need.. > > > Thanks, > Venkatesh. > > > On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay > wrote: > > Hi Friends, > > > > Please solve my VLookup Query. > > Description is given in atta

Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007

- Try to select all the blank columns to the right and delete - Select all the blank line below and delete If you delete the space that they try to wait long to wait, when you're done, save and close the file. Now open the file out to see the results. 2012/8/15 > I would suggest u keep ur option

Re: $$Excel-Macros$$ Macro to convert date at the time of entry

Hi Rashid Khan. You try this Macro stars. For column A. Sub Permutation() 'Be Tran Van (be09) Range("A:A").Select Selection.NumberFormat = "/mm/dd" End Sub Want to go back to the original use Macro. Sub Returns() 'Be Tran Van (be09) Range("A:A").Select Selection.NumberFormat

Re: $$Excel-Macros$$ Re: treeview

I mean! How to load the controls on the "Toolbox" when "Additional Controls ..." do not actually be in VBA 2012/9/8, Bé Trần Văn : > 2012/9/8, james D : >> Hi David, >> >> I already tried that too. Can you tell me, are you on windows 7 with >&g

Re: $$Excel-Macros$$ Re: Transpose (Arr) problem with Dates

Month, Day, year format. Select the column to date format (mm / dd / ) then use the macro name is DayMonthYear Code: Sub DayMonthYear() 'Ðinh dang ngày tháng nam 'Day, Month, year format Selection.NumberFormat = "mm/dd/" End Sub Select the column to the month, day, year (dd / mm / yy

$$Excel-Macros$$

Thanks for sending messages to me. These references are very useful. Thank you very much -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyti

Re: $$Excel-Macros$$ Ebooks for Pivot Table and Chart

2011/9/30 NOORAIN ANSARI > Dear Nalini, > > See attached sheet if it help to u. > > On Thu, Sep 29, 2011 at 6:23 PM, N Pradhan > wrote: > >> ** >> Dear Noorain Sir, >> >> I am having some problem in the attached pivot. >> >> I want a calculated field (count of name - count of absent) which is

$$Excel-Macros$$ Connect 2 sheets

Thank excel-macros@googlegroups.com gave me somequestions and answers messages, Thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyt

Re: $$Excel-Macros$$ can I unprotect a sheet

2011/10/7 Dilip Pandey > Hi Anil, > > see the below link. > www.straxx.com/excel/password.html > > Regards, > DILIPandey > On 7 Oct 2011 13:12, "anil kumar" wrote: > >> Hello everybody, >> >> I have a excel file in which i use protect op. but I have forgot password. >> becoz i use this file so

Re: $$Excel-Macros$$ job

2011/10/11 ashish koul > * > ** Email ID -malath...@aarchsol.com* > > *Dear Candidate,* > > Hi, > > We have very good opening with one of our major client., please find the > details. > > Job Location : Bangalore > Experience: 1 - 6yrs > > Description: > Must have experience in MS

Re: $$Excel-Macros$$ Download Word Macro Tutorial

2011/10/24 NOORAIN ANSARI > Dear Pankaj, > > PFA > > On Mon, Oct 24, 2011 at 6:01 AM, pankaj gmail account < > pankaji...@gmail.com> wrote: > >> This link is also not working. >> >> Pankaj >> >> On Sun, Oct 23, 2011 at 8:01 PM, ashish koul wrote: >> >>> http://www.susandoreydesigns.com/softwa

Re: $$Excel-Macros$$ formula for diff. in string

2011/11/3 ashish koul > check the attachment > > > On Thu, Nov 3, 2011 at 6:12 PM, Ankit Agrawal > wrote: > >> HI, >> >> If both string are same then 1 or anything else like true otherwise false >> o anything else/ >> >> Regards, >> Ankit >> >> >> On Thu, Nov 3, 2011 at 5:56 PM, dguillett1 wrot

Re: $$Excel-Macros$$ Excel learning Institute

2011/11/24 Surbhi Agarwal > Hi, > > These files need password. Please tell me the password. > > Thanx > Surbhi > > On Thu, Nov 24, 2011 at 4:18 PM, jmothilal wrote: > >> Herewith i attache 42 excel files. its for beginners. >> >> Thanks with >> >> Mothilal.J >> >> >> On Thu, Nov 24, 2011 at 2:3

Re: $$Excel-Macros$$ Urgent opening for MIS data analytics

2011/11/24 Gyana Ranjan Das > > From: Impetus HR Consultants Private Limited > > > > > The sender of this email is registered with Naukri.com as Impetus HR > Consultants Private Limited > > *Experience required for the Job:* 3 - 6 years > *Job Location:* Delhi/NCR > > *Dear Candidate,* > > De

Re: $$Excel-Macros$$ exls

2011/11/24 jmothilal > Thanks for sending shortcut keys. > > Mothilal > > > On Thu, Nov 24, 2011 at 2:17 PM, mangesh bavalekar > wrote: > >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urg

Re: $$Excel-Macros$$ JOB

2011/11/24 ashish koul > *Recruiter : j...@colosseumconsulting.co.in* > * > * > * > * > *E**xperience required for the Job:* 1 - 5 years > *Annual Salary of the Job:* 3.0 - 5.0 Lacs > *Job Location:* Delhi/NCR > > *Dear Candidate,* > > Dear Candidate, > > Colosseum, an Executive Search & Recrui

Re: $$Excel-Macros$$ Excel learning Institute

2011/11/25 Anupam Konhar > can i please get a copy of the material?? > > Thanks n Regards > > Anupam > > On Fri, Nov 25, 2011 at 4:11 PM, Subhash Yadav wrote: > >> Thank u Noorain... >> >> >> On Fri, Nov 25, 2011 at 11:58 AM, jmothilal wrote: >> >>> THANKS SO MUCH >>> >>> J.MOTHILAL >>> >>> >>

Re: $$Excel-Macros$$ Job

2011/11/25 ashish koul > *Recruiter: *ut...@ecsindia.co.in > > *Dear Candidate,* > > I have your old profile in my Database. Here with this mail, I would like > to inform you that at present we have opening with Top MNCs in Gurgaon (NCR > Delhi) for the position of Assistant Manager and Manager.

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

2011/11/28 Kenil Gala > Rename the file. > 2003 format : .xls > 2007 format : .xlsx > > --- On *Mon, 11/28/11, Sanjib Chatterjee *wrote: > > > From: Sanjib Chatterjee > Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous > version of excel > To: "excel-macros" > Date: Monda

Re: $$Excel-Macros$$ Almost all calculator in one sheet

2011/11/28 vijayajith VA > Thanks ankit. > > On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wrote: > >> Hello All, >> >> In our daily life we calculate so many thing & use different calculator. >> Here is one excel file which contain almost all calculator. >> >>

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011/12/1 dguillett1 > =LARGE($I$3:$I$23,ROW(A1)) > copy down to give 5,4,4,3,3,2 > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Aindril De > *Sent:* Thursday, December 01, 2011 4:21 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ How to Extract

Re: $$Excel-Macros$$ Re: Almost all calculator in one sheet

2011/11/30 Silviu Felician > Hello, > > Your file is awesome, but it would be best if you gave us also the > password, most sheets in this file are locked and I want to be able to play > with the formulas and not just use the file as it is. Thanks! > > -- > FORUM RULES (934+ members already BANNE

Re: $$Excel-Macros$$ update link automatically in excel sheet

2011/12/5 dguillett1 > Haven't followed this but have you tried > edit/replace > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -Original Message- From: debasish > Sent: Sunday, December 04, 2011 11:38 PM > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ updat

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

2011/12/5 > Congrats Sam, Excellent ! > > ** ** > > *Thanks,* > > *Hariharan Tharagan* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain > *Sent:* Friday, December 02, 2011 11:15 AM > *To:* excel-macros > *Subject:* $$

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

2011/12/4 dguillett1 > 1. You give NO example[image: Sleeping half-moon]Perhaps a list and > then “for each item in range(“a2:a11”) > 2. Adaptable to a worksheet_change event > 3. Can be done > > Who are you_,Where are you___Who do you work > forWhat is this for??___

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

2011/12/6 Bé Trần Văn > > > 2011/12/4 dguillett1 > >> 1. You give NO example[image: Sleeping half-moon]Perhaps a list and >> then “for each item in range(“a2:a11”) >> 2. Adaptable to a worksheet_change event >> 3. Can be done >> >> Who are you_

Re: $$Excel-Macros$$ about getpivotdata

2011/12/25 vijayajith VA > Hello sir, > > Please i want to know about getpivotdata . can you give me some examples.? > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ Chuka Lkh wants to chat

2011/12/25 Chuka Lkh > --- > > Chuka Lkh wants to stay in better touch using some of Google's coolest new > products. > > If you already have Gmail or Google Talk, visit: > > http://mail.google.com/mail/b-e958f1a6c3-584ba34c72-4J

Re: $$Excel-Macros$$ Job

2012/1/13 NOORAIN ANSARI > Dear Satvik, > > One of my friend provided me below link to prepare MIS Resume.. > Hope it may help to you.. > > > http://career-resources.dice.com/technical-resume/sample_resumes/vba_developer.shtml > > > > On Fri, Jan 13, 2012 at 10:27 PM, Satvik wrote: > >> ** >> So

Re: $$Excel-Macros$$ Need Application for Invoice Managment Tracker..

2012/1/13 Rajan_Verma > Hi > > Please explain what kind of invoice management application are you looking > for.. what will that do? > > ** ** > > ** ** > > Rajan. > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Amresh Maurya > *Sent

$$Excel-Macros$$ Excel tips

*Hello NOORAIN ANSARI* You send Excel Tips & Tricks Thank you much -- 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 not get quick at

Re: $$Excel-Macros$$ By Default 2003

2012/1/30 > Hi , > please install ms office lower version after higher version this problem > get resolved. > I mean reinstall 2003. Your excel files will be opened in 2003. > -- > Regards, > venkat > Chennai > Sent from my Nokia phone > > --Original message-- > From: SAJID MEMO

Re: $$Excel-Macros$$ learn from basic

2012/1/31 Rajan_Verma > You can visit these sites for advance and Basic VBA.. > > ** ** > > www.ozgrid.com > > www.cpearson.com > > www.akoul.blogspot.com > > www.excelpoweruser.blogspot.com > > www.ozgrid.com > > akoul.posterous.com > > www.mrexcel.com > > www.co

Re: $$Excel-Macros$$ learn from basic

2012/2/1 Bé Trần Văn > > > 2012/1/31 Rajan_Verma > >> You can visit these sites for advance and Basic VBA.. >> >> ** ** >> >> www.ozgrid.com >> >> www.cpearson.com >> >> www.akoul.blogspot.com*

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012/2/2 chandra sekaran > Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are > a player, Each & every one contribution great . > chandru > > On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpfu

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

2012/2/2 Excel_Lover > great, Thanks for sharing.. > > > On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan > wrote: > >> Noorain, >> >> Is there any version for Excel 97 - 2003? >> >> Thanks~ >> >> >> 2012/2/1 NOORAIN ANSARI >> >>> In Excel 2007 Version >>> >>> On Wed, Feb 1, 2012 at 2:21 PM

Re: $$Excel-Macros$$ Category wise Count.

2012/2/2 dguillett1 > You may?? be right and yours is great but did OP say that?? > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sam Mathai Chacko > *Sent:* Thursday, February 02, 2012 9:37 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Cat

Re: $$Excel-Macros$$ Re: VBA Macro development PDF

2012/2/9 Maries > Hi, > ** > *Check this link:* > ** > *http://search.4shared.com/q/CCAD/1/excel+vba* > ** > Regards, > > MARIES > > > > On Thu, Feb 9, 2012 at 2:40 PM, PrIyAnKa wrote: > >> EXCEL 2007 VBA MACRO PROGRAMMING > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1

Re: $$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

** 2012/2/10 rajeyssh aggarwaal > Hello Sir, > Is it possible while we entering the date in the sheet system alert us > that the name or number or text already in the sheet but not limit the > entry of the data, if yes let me know how can we do it and is it possible > to imply the rule in few ro

Re: $$Excel-Macros$$ Add in for compare work sheets

2012/2/11 Yahya Muhammad > > > Please find it attached. > > > > > On Sat, Feb 11, 2012 at 7:34 AM, wrote: > >> Dear Excel Expert, >> >> I am a ardent follower of this group and I have seen that some one has >> posted in this forum a Add in to compare two worksheet. >> >> May I request the expert

Re: $$Excel-Macros$$ Add in for compare work sheets

2012/2/11 Bé Trần Văn > > > 2012/2/11 Yahya Muhammad > >> >> >> Please find it attached. >> >> >> >> >> On Sat, Feb 11, 2012 at 7:34 AM, wrote: >> >>> Dear Excel Expert, >>> >>> I am a ardent follower

Re: $$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

2012/2/11 raghu gr > hi, > its limiting the entry also. > > with regards > raghu > > > On Sat, Feb 11, 2012 at 5:50 PM, Bé Trần Văn wrote: > >> ** >> >> 2012/2/10 rajeyssh aggarwaal >> >>> Hello Sir, >>> Is it possible whil

Re: $$Excel-Macros$$ 1,000 missing survey data points to be fixed by interpolation

2012/2/14 PrIyAnKa > Dear Yogananda > > Instead of sharing such details kindly send a input or output sheet > > As your details are too long to read and understand and then provide u any > answer > > SO kindly share an excel with group > > On Tue, Feb 14, 2012 at 6:40 AM, yogananda muthaiah < > y

Re: $$Excel-Macros$$ REmove duplicate entries

Reply by be09. 1/ Method 1 (will take 5 minutes): To find the duplicate numbers: In D3 you use the formula: =IF(COUNTIF(C3:C37772,C3)>1,"Duplicate"," ") Select cell D3 and Fill down to the final data. Duplication of any cell will display text Duplicate, you used Autofillter select Duplicate and

Re: $$Excel-Macros$$ FW: REmove duplicate entries

You check your data, a number of Cell contains a space in front data leeu. To remove white space you use the TRIM function to, at J3 you use the formula: = TRIM (C3) Complete copy of the column J, dragon to column E you choose Paste Special Value, and click the OK button. 2012/11/23 Manjunath Na

Re: $$Excel-Macros$$ Re: Find and the current data on Form

Thanks Prince. Thanks for your quick reply, once again thank you. 2012/12/15, Prince : > Hi bé trần văn > > your data in column A:A have spaces thats why it is not matching with > current selection of the combo box. but for now i have trim the data in > column A and it is workin

Re: $$Excel-Macros$$ Re: Find and the current data on Form

treatment) used for any format. Thank you. 2012/12/15, Bé Trần Văn : > Thanks Prince. > Thanks for your quick reply, once again thank you. > > 2012/12/15, Prince : >> Hi bé trần văn >> >> your data in column A:A have spaces thats why it is not matching with >> current

Re: $$Excel-Macros$$ Re: Find and the current data on Form

uot;).Range("a" & rw).Offset(0, 4) > tbxNgayKyTTr = Worksheets("ThamDinh").Range("a" & rw).Offset(0, 5) > tbxNguoiXuLy = Worksheets("ThamDinh").Range("a" & rw).Offset(0, 6) > End If > End Sub

Re: $$Excel-Macros$$ Merry Christmas & Happy New Year

Merry Christmas Happy New Year ! May your new year be peaceful 2012/12/25, Dhaval Shah : > *Wishing you all a very Merry Christmas! * > > ** ** > > *And a Happy, Healthy & Eventful 2013 * > > > > * * > > > > > * * > > ** ** > > * > * > *To One and All!!! * > > Merry Christ

Re: $$Excel-Macros$$ Re: Merry Christmas & Happy New Year *

Merry Christmas. Wish you happy new year, happy. 2012/12/25, chhajersand...@gmail.com : > Wish you all Merry Christmas!! > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone > > -Original Message- > From: ashish koul > Sender: excel-macros@googlegroups.com > Date: Tue, 25 Dec 2012

Re: $$Excel-Macros$$ Re: Merry Christmas & Happy New Year

Merry Christmas To All. Wish you happy new year, happy. 2012/12/25, Prince : > * > > Merry Christmas To All* > * > * > *Regards > * > *Prince > *On Tuesday, December 25, 2012 11:25:25 AM UTC+5:30, Dhaval Shah wrote: >> >> >> *Wishing you all a very Merry Christmas! * >> >> ** ** >> >> *And a H

Re: $$Excel-Macros$$ Merry Christmas & Happy New Year

Download Working File/Macro - https://www.box.com/s/02sfon6jloo7lpaj3s6c > > Regards > Ashish Koul > > > On Tue, Dec 25, 2012 at 8:56 PM, Bé Trần Văn > wrote: >> >> Merry Christmas >> >> Happy New Year ! May your new year be peaceful >

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Congratulations Prince Kumar Congratulations on receiving a certificate of honorary awards help to members in the professional forum through excel. I really appreciate your knowledge. 2013/1/11, Ayush Jain : > Dear members, > > Prince Kumar has been selected as 'Most Helpful Member' for the mont

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

You can use the Link worksheets together by: Type the equal sign (=) in the C7 of Consolidate sheet, click the sheet 01 and Click on C2 and then type a plus sign (+), Click on the sheet 02 and Click on C2 and then type a plus sign (+) Click on sheet 05 and click on C2 and press Enter, we ha

  1   2   >