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

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

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

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$$ 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$$ 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$$ 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$$ 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$$ 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$$ 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$$ 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$$ 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$$ 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$$ 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$$ Matching Total of pair

Not understanding the You see the File 2014-02-09 13:18 GMT+07:00 kartikey patel : > 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 be? It's > =TIM

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 : > Hi team, > > Any one can help me to know how to highlight the name based on other > column value (need

Re: $$Excel-Macros$$ Macro question

You upload files. 2014/1/21 Dennis Dieterle > 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 specific location

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 > > > 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 day's work to minutes

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 > Dear All

Re: $$Excel-Macros$$ Re: Copy data to next empty row

To determine the name of each workbook, you must have the workbook name column before combined. 2013/8/30 DanJ > Dear Experts, > > Thank you for your quick replies. > > Sorry, if my question was not clear. > > What I wanted to find is the last row within the range A37:A115 of the > first workb

Re: $$Excel-Macros$$ listbox issue

*Please Upload the file. * 2013/8/25 xlstime > can u please share the example workbooks > > for better understanding > > . > > Enjoy > Team XLS > > > > On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski wrote: > >> Hi All, >> >> I have quite serious problem with the list b

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

You should specify the problem more. 2013/8/24 xlstime > 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 >> >> MI

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

gt; On Wed, Aug 14, 2013 at 9:57 PM, Bé Trần Văn wrote: > >> 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 >> >>> >>> &

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 > thanks Mate working great. > regards, > Pawel > > *From:* De Premor > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, August 14, 2013 11:

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 > > > hi expert, > > please help me to add heading text in a list box. > > Thanks & Regards, > > Divaker > > -- > Are you =EXP(E:RT)

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 > > Dear Expert, > > In validation we select a range and put the text but i want a different > validat

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$$ Re: how to insert Excel File in powerpoint presentation...

Thank you Deepak Singh. 2013/7/15 Deepak Singh > *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 =EXP(E:RT) or =NOT

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

With VBA require you to download the file 2013/7/12 Chandra Shekar > Hi, > > Could you please let me know how to use sumproduct using VBA? Where range > is date values. > > > =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5

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 > please elaborate your query with attachment and examples > > > On Fri, 7/12/13, vba wrote: > > Subject: Re: $$Excel-Macros$$ pulling data from a validation l

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 > > -- > *From:* Prabhakar S H > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, 4 June 2013 4:49 PM > *Subject:* $$E

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

Thanks for the reply. 2013/7/3 Waseem Saifi > 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 wrote: > >> Question 1: I need one function to the column numbered F. >>

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

man Cliff May wrote: > > If the countif function is not available to you, 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, 2

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

You use a label for each name. 2013/6/7 Chandra Shekar > 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 forum @ > https:/

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 > 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 9:22 AM, Haris

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

You upload 1 Workbook, which contains 20 Worksheets with Data and Worksheets requirements. 2013/6/1 Bv Dileep > > 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$$ 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 > 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 Account No. and Amou

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 > Bulloo Shire Council in Thargomindah Queensland Australia. > > Regards > David Grugeon > > > > On 27 May 2013 16:13, VBA VABZ wrote: > >> he

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 Specia

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 > Hi, > > i need to import dat

Re: $$Excel-Macros$$ Data transform

Do you wonder how? should specify the problem. 2013/5/20 Chaya > 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

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 > Dear Experts, > > I am trying to make a pivot table from the attached file "data" sheet > but while trying to drag the Date, it showing t

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 > try to record macro and readits a best way to learn macro > or > you can search

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 > > > dear expe

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/2

Re: $$Excel-Macros$$ Auto-populate a single cell by merging common values from cells within a range.

Using Validation or Combobox. You upload the File to handle for convenience. 2013/3/14 David Grugeon > Use a pivot table. If you need detailed instructions please ask. > > > On Wednesday, 13 March 2013, wrote: > >> >> I'm trying to create an employee expense form. The logic I'm trying to >> sol

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 > Hello Gurus, > > kindly help on the subject above. i need the users to enter dates in

Re: $$Excel-Macros$$ hyperlink issue

Learn test. 2013/2/28 The Viper > can't get throuh formula? > > pfa > > > > On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote: > >> solved . >> >> >> On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote: >> >>> Dear All, >>> >>> I have facing some hyperlink issue in sheet,I attached sheet in d

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 अनिल नारायण गवली > Dear Deepak, > > Pl elaborate some more . unable to understand your required query. > > > Warm Regards, > Gawli Anil. > > On Tue, Feb 26, 2013 at 11:27 AM, Deepak Rawat

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

Menu> Toosl> Macro> Macro and click Run to view the results 2013/2/23 Nitin Gupta > 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 you =E

Re: $$Excel-Macros$$ sheets linking

You must have File new guidelines 2013/2/21 Ankit jain > 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) or =NOT(EXP(

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

You must have File new guidelines 2013/2/21 Ankit jain > 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 official Faceboo

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 : > Cong8...Prince. > > Regards, > Kuldeep Singh > Back Office Executive (M

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

Thank you Shekhar. Macro works well. 2013/2/2, Shekhar : > 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 split each s

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 : > Hi Amir, > hope this can be help full for you. > > Sub test() > Dim

Re: $$Excel-Macros$$ Format changing

You copy the file to the USB and open it, if open, save the file with one name. 2013/1/28, SAJID MEMON : > > Dear Experts, I have made a file in excel 2003, it was working properly > since 3 years, now file format is changed (that's i don't know- how) and > want to open it.When i open that file at

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 : > What is the short cut of select the values of a column if there are missing > > values i

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 : > Dear betnmtdongnai, > what is use of ("";"";) in formula .as like Prince simple vlookup aslo > got answer

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

At D3 of sheet List you can use the formula: =IF(A3="";"";VLOOKUP(A3;MASTER!$A$3:$B$9;2;0)) And Fill down, See Attachment 2013/1/24, Hilary Lomotey : > Hello Experts, > > In the file attached, i have a master list with names and codes(master > sheet), and then another list (list sheet). The code

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

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$$ 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$$ 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$$ 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$$ 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: 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$$ 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

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$$ 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$$ 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: 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

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$$ 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 > I would suggest u keep ur option

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$$ 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$$ 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$$ ****** 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

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$$ 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$$ Re: Introduce Yourself !!

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

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

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

  1   2   >