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

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

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) >

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 schreiner_p...@att.net: 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?)

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 swch...@gmail.com: 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

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 v...@vabs.in: Glad this helped you. Cheers!! On Dec 23, 2014 9:10 PM, bobengler bobeng...@bellsouth.net wrote: Thank you for your time and expertise. It's good to know there is good support

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

You refer to File. 2014-12-19 23:32 GMT+07:00 ashakal...@gmail.com: 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

$$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’s

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 ganesh.theva...@gmail.com:

Re: $$Excel-Macros$$ Filter

Panaji vasco INDIA Gujarat Gandhinagar Ahmedabad INDIA Gujarat Gandhinagar Vadodara On 30 August 2014 20:41, Bé Trần Văn betnmtdongna...@gmail.com wrote: 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

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 princedaya2...@gmail.com: Hi Friends, I need help regarding filter data form with 3 combo box label 1st combo i select INDIA next if i select

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 eugene.bern...@gmail.com: Mr Basole, Thanks for the attachements, I am getting an error msg as in the attachment, even after adding Ms-ado object library.

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 schreiner_p...@att.net: 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,

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

A, in column B I have entered Y as working days and N as not working days. ...more http://groups.google.com/group/excel-macros/msg/277f1fe8b3fcb9df Back to top #147a04e7a3293047_1479e4062d51fdb3_digest_top Bé Trần Văn betnmtdongna...@gmail.com Aug 04 12:55AM +0700 In Cell

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 rajeevk...@gmail.com: 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

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

-07-01 12:40 GMT+07:00 amar takale amartak...@gmail.com: 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 each time then work done in some time. Can we give as header

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

:17 AM, amar takale amartak...@gmail.com wrote: Dear Bé Trần Văn Thanks very much sir. but i ask you small issue can we use one code to all filed like lalit mohanji code.I use this code but erroe show object does not support this property or method Thanks once again

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

excluding OFF... On 29-Jun-2014 12:18 PM, Ganesh N ganeshg...@gmail.com 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 Ganesh N On Sat, Jun 28, 2014 at 6:17 PM, Bé Trần Văn

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 abhishek@gmail.com: 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

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 shrinivas...@gmail.com: Very very thanks On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi v...@vabs.in wrote: Hi Yes you

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 piyaa...@gmail.com: Hi I need to create a userform that selects data from one worksheet(sales) and then create

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 21:30

Re: $$Excel-Macros$$ Request help on conditional formatting

Choose E7: E20, Condition 1: Cell Value Is selected, the right pane is used Formula function: = F7: F20 50 Click the Format button to select the color 2014-02-09 22:45 GMT+07:00 Ganesh N ganeshg...@gmail.com: Hi team, Any one can help me to know how to highlight the name based on other

Re: $$Excel-Macros$$ Matching Total of pair

Not understanding the You see the File 2014-02-09 13:18 GMT+07:00 kartikey patel kartikeypatel8...@gmail.com: Dear, I want a2 colom amount match c2 : c7 total See this attached file to i want it. Thanks Kartik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Macro question

You upload files. 2014/1/21 Dennis Dieterle ddie...@gmail.com First of all, thanks for your time. I have a scheduling project with a 4 page spreadsheet (quarterly) of names and avail timescan I create a Macro to schedule 14 weeks (different ID's) IF their name=Y then PRINT name on

Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Your request should be File, it is best to have one sheet to copy. 2013/9/10 Chih Hung Choo choochihh...@gmail.com Hi, I'm hoping to get some help here to automate the work that I have to do every 2 weeks. The work is repetitive and hopefully a VBA script will help shorten sometimes a

Re: $$Excel-Macros$$ Keep Excel in Full Screen

You to use the codes in ThisWorkbook. Private Sub Workbook_Open() ActiveWorkbook.Sheets(Nhap lieu).Activate With UserForm1 UserForm1.Show UserForm1.Top = 0 UserForm1.Left = 0 End With End Sub Note: (Nhap lieu) the sheet name to the UserForm 2013/9/1 Excel_Lover

Re: $$Excel-Macros$$ listbox issue

*Please Upload the file. * 2013/8/25 xlstime xlst...@gmail.com can u please share the example workbooks for better understanding . Enjoy Team XLS On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski lupins...@yahoo.comwrote: Hi All, I have quite serious

Re: $$Excel-Macros$$ CALL Userfom Another Workbook

You should specify the problem more. 2013/8/24 xlstime xlst...@gmail.com what we can do?...both workbooks VBA coding is password protected . Enjoy Team XLS On Fri, Aug 23, 2013 at 7:33 PM, Sanjay Mandal sanjaykumarmanda...@gmail.com wrote: Dear all MIS

Re: $$Excel-Macros$$ how i can heading text in a list box

. On Wed, Aug 14, 2013 at 9:57 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Select the data and put it to one name, such as *DataList*, Copy * DataList* name in the Properties window and paste it into the RowSource. 2013/8/14 Divaker Pandey divake...@gmail.com hi expert, please help me

Re: $$Excel-Macros$$ how i can heading text in a list box

Select the data and put it to one name, such as *DataList*, Copy *DataList* name in the Properties window and paste it into the RowSource. 2013/8/14 Divaker Pandey divake...@gmail.com hi expert, please help me to add heading text in a list box. Thanks Regards, Divaker -- Are you

Re: $$Excel-Macros$$ check date on open file

Try code in ThisWorkbook Private Sub Workbook_Open() If Now() #8/14/2013# Then End If MsgBox HELLO NEW DAY End Sub 2013/8/14 pawel lupinski lupins...@yahoo.com thanks Mate working great. regards, Pawel *From:* De Premor d...@premor.net *To:* excel-macros@googlegroups.com *Sent:*

Re: $$Excel-Macros$$ Re: how to insert Excel File in powerpoint presentation...

Thank you Deepak Singh. 2013/7/15 Deepak Singh dpk85si...@gmail.com *Hi Dhananjay, Do not use it as hyperlink..better go to insert click on object..then create from file..browse your file and then click on display as icon..click ok.. Hope this will help you out.. * -- Are you

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

Open powerpoint 2003, Click to add title frames delete, click on Click to add text box and type the first letter dot to remove Click to add text (if not included in the table to the words it still can not be deleted). From the Insert menu choose Object, warm Insert Object window appears, check

Re: $$Excel-Macros$$ Different Validateion

In Datavalidation window, you select the error alert Tab, uncheck the Show Error Alert after invalid data is entered, then press OK, now you will not be data entry errors. 2013/7/15 Manoj Kumar manoj.11...@gmail.com Dear Expert, In validation we select a range and put the text but i want a

Re: $$Excel-Macros$$ pulling data from a validation list

Vang File attachments and you need to specify the contents to be 2013/7/12 ravinder negi ravi_colw...@yahoo.com please elaborate your query with attachment and examples On Fri, 7/12/13, vba v...@vabs.in wrote: Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Sumproduct using VBA

With VBA require you to download the file 2013/7/12 Chandra Shekar chandrashekarb@gmail.com Hi, Could you please let me know how to use sumproduct using VBA? Where range is date values.

Re: $$Excel-Macros$$ Formula require

Use the Function and PivotTable =IF($B6;SUMPRODUCT(($C$6:$C$14=H$6)*($B$6:$B$14=$G7)*($D$6:$D$14));) Attachment. 2013/7/6 Anil Kumar kumarmaury...@yahoo.com -- *From:* Prabhakar S H prabakar.k...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday,

Re: $$Excel-Macros$$ Question about function

Thanks for the reply. 2013/7/3 Waseem Saifi waseemsa...@gmail.com Dear Van, I have placed a formula in first sheet in K column. it might help you. On Mon, Jul 1, 2013 at 12:47 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column numbered F

Re: $$Excel-Macros$$ Question about function

, the following formula should work in cell E2 and copy down. =SUMPRODUCT(--($C$2:C2=C2)). (TEXT(B2,dd/mm/)) - D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column numbered F. Question 2: In column J, How to connect

Re: $$Excel-Macros$$ List in Userform

You use a label for each name. 2013/6/7 Chandra Shekar chandrashekarb@gmail.com Hi, How to get List as attached in the userform Regards, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

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

Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR On Tue, Jun 4, 2013 at

Re: $$Excel-Macros$$ Re: Macro Help

You upload 1 Workbook, which contains 20 Worksheets with Data and Worksheets requirements. 2013/6/1 Bv Dileep bvdil...@gmail.com On Sunday, May 26, 2013 8:50:22 PM UTC-5, Bv Dileep wrote: Hello, ** ** Please find attached the sheet. ** ** Macro Requirement : I will receive

Re: $$Excel-Macros$$ Macro Help

Cell D3:D9 and :D24 to enter data. Input data in is complete, Click Button Enter data into the sheet Format, See Attachment. 2013/5/27 David Grugeon da...@grugeon.com.au Bulloo Shire Council in Thargomindah Queensland Australia. Regards David Grugeon On 27 May 2013 16:13, VBA VABZ

Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

Please attach File, I know how to handle new look. 2013/5/27 KAUSHIK SAVLA savla.kaus...@gmail.com Hi All, Need your help in pivot table drill down. I am having huge excel database around 15 rows having whole data of different accounts. I want to create a pivot on it on basis of

Re: $$Excel-Macros$$ Import Data From large size text file to Excel using VBA

2 Form to use as input Sheet. Done by: Choose Valiedation in Cell D3 of sheet NhapLieu, it will retrieve the data from sheet DataList. Click on the button Enter data into the sheet Theodoi, to enter data into the next row of sheet Theodoi. 2013/5/23 vincentmca vincent...@gmail.com Hi, i

Re: $$Excel-Macros$$ Problem in file..?

Maybe because your spreadsheet data using multiple functions, or select and delete the blank column on the right, select and delete the blank line underneath the sheet containing the data, if not all slow sluggish, the ultimate solution is a new file, open 1, copy each sheet and select Paste

Re: $$Excel-Macros$$ Data transform

I do not know what you do, the help you, if not pleasant, then continue. See Attachment. https://www.box.com/s/4th7oom4zutre0d5f25z 2013/5/20 Chaya chayamon...@gmail.com Dear Experts, I am trying to make a pivot table from the attached file data sheet but while trying to drag the

Re: $$Excel-Macros$$ Data transform

Do you wonder how? should specify the problem. 2013/5/20 Chaya chayamon...@gmail.com Dear sir, Thanks for the revert. but i not getting you what exactly you mean. please elaborate sir. Regards, Chaya The excel learner :-) On Mon, May 20, 2013 at 6:09 PM, Bé Trần Văn

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

- If you use Excel 2003: Open Excel, press Alt + F11 (open the Visual Basic Edition), click on Help and knocked me nu need to learn the content. - Google, Search basic guidelines VBA 2013/5/15 xlstime xlst...@gmail.com try to record macro and readits a best way to learn macro or

Re: $$Excel-Macros$$ Create Sheets by given name.........

1/ Create one sheet Sub CreateSheet() Worksheets.Add End Sub 2/ Remove 1 sheet named THANH, and create a new one sheet called TRUNG Sub CreateSheet() On Error Resume Next Application.DisplayAlerts = False Sheets(THANH).Delete On Error GoTo 0 Worksheets.Add

Re: $$Excel-Macros$$ power pivot data copy

Want to copy the data in the PivotTable table, the first headline Copy ( select Cell outside), followed by Copy the contains header data below. To export data, click to select any Cell that contains the data, followed by double-click on it one more time. 2013/4/2 danial mansoor

Re: $$Excel-Macros$$ Vba Code to extract Data from one sheet to another *

Place the code in Module1 Sheet Module which contain data Sheet Output is Paste Data Code: Sub Extractdata() Sheets(Module).Select Range(A2:P66).Select Selection.Copy Sheets(Output).Select Range(A2).Select ActiveSheet.Paste Range(A1).Select End Sub 2013/3/28 Hilary

Re: $$Excel-Macros$$ Data Validation to force users to enter a particular date format

Select the column, from the menu on the Format Cell, appear Format Cells window select the Number tab, for Category select Custom, in the Type in dd- mmm-yy and press the OK button. 2013/3/12 Hilary Lomotey resp...@gmail.com Hello Gurus, kindly help on the subject above. i need the users to

Re: $$Excel-Macros$$ hyperlink issue

Learn test. 2013/2/28 The Viper viper@gmail.com can't get throuh formula? pfa On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey divake...@gmail.comwrote: solved . On Thu, Feb 28, 2013 at 3:41 PM, amar takale amartak...@gmail.comwrote: Dear All, I have facing some hyperlink

Re: $$Excel-Macros$$ Macro to create muliple sheets from excel

Data S*heet1 *stars not agree with the title of the sheet *Data*, you should give a better idea. 2013/2/26 अनिल नारायण गवली gawlianil8...@gmail.com Dear Deepak, Pl elaborate some more . unable to understand your required query. Warm Regards, Gawli Anil. On Tue, Feb 26, 2013 at 11:27

Re: $$Excel-Macros$$ DATA LINKAGE PROBLEM

Menu Toosl Macro Macro and click Run to view the results 2013/2/23 Nitin Gupta nitin...@gmail.com Hi I want to link multiple data in row to column, but when you use transpose function the links are not working need to past special in value term Sample Sheet attached Please advice -- Are

Re: $$Excel-Macros$$ work book and sheets linking

You must have File new guidelines 2013/2/21 Ankit jain jainankit...@gmail.com Dear Expert Please tell me how can i link 3-4 workbooks and spreadsheets Thanks Regards ANKIT JAIN -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

Re: $$Excel-Macros$$ sheets linking

You must have File new guidelines 2013/2/21 Ankit jain jainankit...@gmail.com Hello Please tell me how can i linking of sheets and different workbooks. There is any method that i link different workbooks and extract all data in a single workbook. Thanks Ankit Jain -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Re: Macro - To split each spreadsheets as a new workbook

Thank you Shekhar. Macro works well. 2013/2/2, Shekhar shekhar.rai...@gmail.com: Hi Santhosh, Please find attached workbook and let me know if it works. Thanks and regards, Shekhar On Friday, 1 February 2013 23:14:56 UTC+5:30, mks...@gmail.com wrote: Hi Friends, Need a macros to

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

Prince is great, congratulations received honorary awards. I really appreciate your knowledge, you have voluntarily help enthusiasts excel good deal of work. Thanks for your generous contribution. 2013/2/2, Kuldeep Singh naukrikuld...@gmail.com: Cong8...Prince. Regards, Kuldeep Singh Back

Re: $$Excel-Macros$$ Re: Macro require

Another way that can help you Sub Statistics_sheetname() Dim i As Integer For i = 1 To ActiveWorkbook.Sheets.Count ActiveSheet.Range(a i).Value = Sheets(i).Name Range(a i).Select Next i End Sub 2013/1/30, Prince prince141...@gmail.com: Hi Amir, hope this can be help full for you. Sub

Re: $$Excel-Macros$$ Selecting all values

How to quickly select all the values of a column, including the last Cell of the column is blank: Click to select the final Cell and press Ctrl + Shift + up arrow and press 2 times. 2013/1/26, Sadia Khalid sadiakhalid...@gmail.com: What is the short cut of select the values of a column if there

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

I ; to ignore the error # N/A if column A MASTER of 2 LIST list and the elements are not the same, you try. 2013/1/25, amar takale amartak...@gmail.com: Dear betnmtdongnai, what is use of (;;) in formula .as like Prince simple vlookup aslo got answer On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần

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

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 jainayus...@gmail.com: Dear members, Prince Kumar has been selected as 'Most Helpful

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

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

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

If End Sub check the attachment see if it helps On Sun, Dec 16, 2012 at 2:41 PM, Prince prince141...@gmail.com wrote: hi be tran van share your file with me. regards prince On Saturday, December 15, 2012 9:58:14 PM UTC+5:30, bé trần văn wrote: Welcome Prince. File TIEN TIM 3 if I

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 prince141...@gmail.com: 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

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 betnmtdongna...@gmail.com: Thanks Prince. Thanks for your quick reply, once again thank you. 2012/12/15, Prince prince141...@gmail.com: 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$$ 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

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$$ 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 betnmtdongna...@gmail.com: 2012/9/8, james D jpadlimi...@gmail.com: Hi David, I already tried that too. Can you tell me, are you on windows 7 with office 2010

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 /

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$$ 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 garwads...@gmail.com I would

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

Re: $$Excel-Macros$$ Vlookup Problem

Do as you like. 2012/7/17 Venkatesh Narla nvenki...@gmail.com 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 mangesh.da...@gmail.com wrote: Hi Friends, Please solve my VLookup Query.

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 jainayus...@gmail.com 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,

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 drdeva...@gmail.com Dear Ashish and Dilip. Sorry for the delay, its a really awesome stage. heartiest congratulate to both and please keep helping to

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 pankaji...@gmail.com Dear Moderator, Please also Ban these kinds of Promotional/Advertisements in this forum. They are not related to Excel Help.

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

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

2012/6/22 ChilExcel chilexcel...@gmail.com /\ \ __ /\_ \ /\_ \ ___ \ \ \___ /\_\\//\ \ __ __ ____ __\//\ \ /'___\\ \ _ `\\/\ \ \ \ \/'__`\/\ \/'\ /'___\ /'__`\\ \ \ /\ \__/ \ \ \ \ \\ \ \ \_\

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

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

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

...@gmail.comwrote: 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 betnmtdongna...@gmail.com wrote: 2012/5/21 Anil Gawli gawlianil8...@gmail.com with data validation i don't think so, i have prepared in combo box control

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

: *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. BUt my tracker is still unsolved. Please see the attached file and click the Tracker button. You will find my query. Thank you

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

2012/5/19 Rajan_Verma rajanverma1...@gmail.com 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:*

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

2012/5/9 Lokesh Loki lokeshsmg2...@gmail.com 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 gawlianil8...@gmail.comwrote: Attached is the workbook and

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

2012/5/7 ╰» ℓαℓιт мσαнη mohan.pande...@gmail.com Dear Sara, PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Sun, May 6, 2012 at 11:35 PM, Sara Lee lee.sar...@gmail.com wrote: hi i would like to have

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

** 2012/5/5 Maries talk2mar...@gmail.com 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 n.karthi...@gmail.com wrote: Hi Friends, How learn the macro's in step by step,kindly

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

2012/5/4 Deba Ranjan drdeva...@gmail.com *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

Re: $$Excel-Macros$$ Help Please

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

Re: $$Excel-Macros$$ VBA Help

2012/3/9 NOORAIN ANSARI noorain.ans...@gmail.com 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

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

2012/2/23 Kris krishnak...@gmail.com 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,

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

2012/2/23 Abhishek Jain abhishek@gmail.com 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.

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

** 2012/2/21 Maries talk2mar...@gmail.com 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 =

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

2012/2/14 PrIyAnKa p.dhamsa...@gmail.com 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

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

** 2012/2/10 rajeyssh aggarwaal rajey...@gmail.com 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

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

2012/2/11 Yahya Muhammad yahya...@gmail.com Please find it attached. On Sat, Feb 11, 2012 at 7:34 AM, chhajersand...@gmail.com 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.

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

2012/2/11 Bé Trần Văn betnmtdongna...@gmail.com 2012/2/11 Yahya Muhammad yahya...@gmail.com Please find it attached. On Sat, Feb 11, 2012 at 7:34 AM, chhajersand...@gmail.com wrote: Dear Excel Expert, I am a ardent follower of this group and I have seen that some one has posted

  1   2   >