$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

Dear Friends... I am novice in excel but I think the list function can help us out. It can be used in the following manner : 1. DATA - LIST - CREATE LIST Define range and tick on - My list as headers than u can use filters on both the data attaching for your reference how

$$Excel-Macros$$ When some data is filtered how to find unique values in excel

Dear All, Need a small help. Is there a way to find unique values in excel when some data is filtered. Eg: There are 1-100 rows in a particular sheet If the filter contains some 20 odd rows based on certain selection criteria, is it possible to find unique values in those filtered cells (20 ro

$$Excel-Macros$$ Re: vba password

Just send to me that vba file From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of shefali singh Sent: Saturday, September 26, 2009 7:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vba password hello excel experts i want a software t

$$Excel-Macros$$ Converting data into date

Hi there, Fairly new to VBA. I am trying to convert a column (header is date) into dates. For some reason using the below does not seem to work: Selection.NumberFormat = "/mm/dd" Any idea? Thanks. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Vlookup

Hi Thank you so much thats exactly i wanted Regards Ruchi On Mon, Sep 28, 2009 at 5:32 PM, Abhishek Jain wrote: > Please see the attached file. > > All I did is change the format of destination cell to "General" > > Rgrds > > On Mon, Sep 28, 2009 at 12:04 AM, god is gr8 i love u > wrote: >>

$$Excel-Macros$$ Re: Access To Excel

Please check on ur system after uninstalling ms access. I would have checked, but using MSaccess for some urgent deliverable. :) Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 28, 2009 at 7:26 PM, Jack wrote: > Thanks Harmeet > > But will the end user be able to re

$$Excel-Macros$$ Re: Access To Excel

*attached file would help u** *Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 28, 2009 at 5:29 PM, Jack wrote: > > How can I create an import from ms access to excel where a user does > not have access application ?? > spent ages trying to work it out ? > Anyon

$$Excel-Macros$$ Access To Excel

How can I create an import from ms access to excel where a user does not have access application ?? spent ages trying to work it out ? Anyone have an idea ? --~--~-~--~~~---~--~~ -- S

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

What I understand is that you want multiple filters on single worksheet...say, one from row 1 to 16 and other from row 17 to 30 and so onif i got your query right i am afraid it is not possible (as far as i know). Let's see if any of the geniuses of the can tell a work around. Rgrds On Sat, S

$$Excel-Macros$$ Re: Date Format

Easy and simple - Select your column and press Ctrl+H (replace) put *.* in find what and put * /* in replace with...click replace all. you're done. On Mon, Sep 28, 2009 at 1:27 PM, Kaustubh K wrote: > > Hi, > > I have around 500 entries which have format of date dd.mm.yy say > 21.05.08 ( And t

$$Excel-Macros$$ Re: Date Format

since the values are always 2 characters, you could add a column and use: =DATEVALUE(MID(A2,4,2)&"/"&LEFT(A2,2)&"/"&RIGHT(A2,2)) hope this helps Paul From: Kaustubh K To: MS EXCEL AND VBA MACROS Sent: Monday, September 28, 2009 3:57:05 AM Subject: $$Excel-M

$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET

Hi, Filters can be applied in columns not in rows. This is what I can say as per my knowledge. But, yes you can filter - out rows by applying filters in columns. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Date Format

Hi, I have around 500 entries which have format of date dd.mm.yy say 21.05.08 ( And the difficulty is that they are not in date format but text format) I wish to convert them to mm/dd/ date format. Is there any trick to do so fast. Regards Kaustubh --~--~-~--~~~

$$Excel-Macros$$ Re: how to change decimal ccoordinates into DDMMSS fromat

Dear Mahesh Try to use the attached program. Yahya On Fri, Sep 25, 2009 at 2:02 PM, Mahesh wrote: > Dear friends, > > Need your help. > > i want to convert decimal coordinates into DDMMSS. > > 9.73877= 09 44 20 > > -- > With Love, > Mahesh Bisht > > > > --~--~-~--~

$$Excel-Macros$$ Re: Forgotten Password

Dear Ramkrishna Serial to register passware-kit-enterprise is : FPVYK-EVHVF-WR7H4-H4EXE-ZAJB5U N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Loop to lookup variables and copy row to new sheet

Hi Tyson, Sub kTest() Dim ws As Worksheet, unqUnits, r As Range, i As Long Set ws = Sheets("Input") unqUnits = UNIQUE(ws.Range("b2", ws.Range("b" & Rows.Count).End (xlUp)).Value) With ws.Range("a1:z" & ws.UsedRange.Rows.Count) For i = 0 To UBound(unqUnits) .AutoFilter field:=2, Criter

$$Excel-Macros$$ Re: Extracting a range from multiple files from a folder - Help!

Try this. Again untested Sub kTest() Dim n As Long, fn As String, a, b, wb As Workbook, aWB As Workbook, i As Long Const MyFolder As String = "F:\DISAUG\" 'adjust to suit fn = Dir(MyFolder & "*.xls") Set aWB = ActiveWorkbook With Application .ScreenUpdating = 0 .DisplayAlerts = 0 .E

$$Excel-Macros$$ Re: Splitting a text file

Hi Saurabh, Please change the name of the file to "data.csv", or "data.txt" before importing. This is something I have already replied to you Sep 25, 2009. The crux here is to check the data file name for spaces. Thanks. Best regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91