$$Excel-Macros$$ Date Interval Test

I have a spreadsheet in which column A and B have date valuesfor instance A1 will have Jan 30, 2005 and B1 will be March 8, 2005. Corresponding to each range of dates in A and B, I have a value, lets say Alpha in Cell C1. These date ranges in A and B columns and code in C repeats for row 1 th

Re: $$Excel-Macros$$ Help: Removing duplicate data

Hello, There are Excel addins for removing Duplicates.You can Download and Install them from www.office-excel.com,www.ablebits.com ... etc.There is also an addin called "Ultimate addin" for Excel which contains a lot of features along with duplicate remover. Regards, VIJAY KUMAR --

Re: $$Excel-Macros$$ Need help list box

Dear Mohammed Idhrees, Please find attach, i hope this is your requirement, i have done only for the 2 rows which are colored in yellow, if you wish you can copy paste and tak the values from the list. If this is not your requirement you can revert to the group for more help. Regards Ahmed Bawaz

Re: $$Excel-Macros$$ Need help list box

Hi, You can use Data Validation for this. Search Google or Excel Help you will get to know about this. Regards, Deepak On Sun, Sep 26, 2010 at 8:49 PM, Idhrees Mohamed wrote: > Dear Team, > > I need help with attached file. In this one column "Relay type", we select > any one item (need list b

$$Excel-Macros$$ problem???

Dear Group, I want to retrive column wise data from diffrerent excel files to a particular format file. I have linked and only a cell is linked. i want all the data of a column automatic retrice in a file. plz give me any ideas. awaiting your replay sajid memon

Re: $$Excel-Macros$$ Help: Removing duplicate data

Thanks for your advice On Thu, Sep 23, 2010 at 3:18 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > if you want to refer more than one column for identifying duplication you > need to concatenate the columns for advance filter... please keep in > mind. > > Thanks > Srini

$$Excel-Macros$$ Need help list box

Dear Team, I need help with attached file. In this one column "Relay type", we select any one item (need list box), its display all the corresponding details with the title. Thanks in Advance. -- Regards, Mohamed Idhrees. S. -- --

$$Excel-Macros$$ want to run a perl script on unix from excel . Possible ?

Hey friends , Do help me find a code which can run scripts in unix terminals, Thanks, S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyt

$$Excel-Macros$$ VBA code required for Copy a specific folder.

Hi Team, Here I have a requirement to copy folder from one location to another location which is contain a specific Name. Ex: I Have a folder AAA AAA has 3 Subfolder as aaa1, aaa2, aaa3. All the above said subfolders contains Each 2 Folders as (aaa1_Input & aaa1_Output, aaa2_Input & aaa2_Outpu

$$Excel-Macros$$ Re: Excel chart plotting, depending on weightage

Where's the weight assigned to each region? Do the numbers below north, south, east and west represent that? In that case what does this table shows? On Sep 25, 4:31 am, startingexcel wrote: >  Excel chart plotting, depending on weightage > Hi experts, > Need help in ideas and plotting a graph to

$$Excel-Macros$$ Re: Remove the Space

Hi, I am not sure if I understood your problem correctly. If you want to clean all the leading and trailing spaces from data in column B and then use them in column C this nested function works perfectly: =TRIM(SUBSTITUTE(B12,CHAR(160),CHAR(32))) Hope that helps. In case you need something else