Re: Get Info From LDAP Server
No , I have only AD user Login ID's in my excel sheet from that I need to pull the info from LDAP.
regards
Re: Get Info From LDAP Server
No , I have only AD user Login ID's in my excel sheet from that I need to pull the info from LDAP.
regards
Re: Count Unique Items In Autofilter
Hi Krishna Thanks Very Very much Man. You have been very very helpful even on other post of mine....
Thanks.. it works..I shall get back if something is not...
Hi All
I have a excel sheet with lot of email.id. we need to know the Departments of a all the employess(or email.id) we have an LDAP server can we pull the info based on email ID ??? to this excel sheet and updated the department???
regards
Re: Count Unique Items In Autofilter
Thanks Very much Fin and also to Krishna Kumar .
Fin I have another question to the same thread. How can I count type(field) with the below condition
2. Set Autofilter - > Field 4 ->Custom - Does not Equal to NULL
3. Set Autofilter - > Field 5 ->Custom - Does not Equal to NULL
Attached is a excelsheet.
regards
Re: Collect Data From Different Workbooks
Hi Dave
Thanks But I thnk we Need to Merge your Loop Through a Folder of Excel Workbooks & http://www.ozgrid.com/forum/showthread.php?t=71552
Kindly Help, Help required to merge both the topics into one.
regards
Re: Collect Data From Different Workbooks
Hi Dave
Thanks for the Reply. I have a few questions on the Code,
1. strWb = Choose(lLoop, "Book1.xls", "Book2.xls", _
"Book3.xls", "Book4.xls")
Now there are 2000 such Request FORMS. Now do u want me to create a list of file names???
How can I give a director of all such forms which it must open ?
2. In my Case Book name are different but sheet name remains same ("Request") when you open them they are well organised I mean in this manner
A1 = Blank
A2 = Name/ID
A3 = Book Name
A4 = Author
A5 = Time Duration
Users have to fill related data against A2 in B2 respectively.
When I run a Macro in a new Worksheet I need to get data in Rowise
User/ID Book Name Author Time Duration
How dan I do this???
regards
Hi All
I have so many "LibaryBookRequest.xls" (eg. 200 Forms) Where it contains NameID, BookRequest, TimeDuration etc. At the end of the month I need to accumulate all the Data into one worksheet. How Can I do this?? (by not opening 200 forms to collect data)?? since its a standard format form all cell value in all the work books remains same, ( i mean to say B2 always Contains NameID in all workbooks).
regards
Re: Count Unique Items In Autofilter
Hi Fin Fang
Well I followed the instruction given by you but it only Hows 0 in H:Col. I have attached the excel sheet again.
regards
Re: Count Unique Items In Autofilter
Sorry Forgot to Attach (previous post)
Re: Count Unique Items In Autofilter
Hi
Thanks for reply, I have tried to Apply the formula but I am confused, There is a problem ,
Please consider the Attached. GOTO Modified Sheet. There are 5 Fields
1 . Set Autofilter for Field 2 to "TOM" Count the Items in the Autofilter Field 3
The Count is 4
2. Set Autofilter - > Field 4 ->Custom - Does not Equal to NULL
3. Set Autofilter - > Field 5 ->Custom - Does not Equal to NULL
Now Count Number of Items in Field 2
The Count is 3.
now I need formula where I get count as 3.
regards
Re: Count Unique Items In Autofilter
Hi and Hello
This works very great ...but I have found a problem say supposing if there are null values in Col : A and Col : B using Autofilter->Custom Not eqal = Null I set so that..I don't get items with null values. But the formula will also count number of items which has null values that means it is not counting the number of unique values from filter but from the range what i have defined ?? How can count only items in the auto filter after setting parameter ?? for example select Test10 from autofilter A:col see there count no of items in col:b ??
regards
Re: Count Unique Items In Autofilter
Well I need a function where I can Count Items in the auto filter?? in the example =SUBTOTAL(3,YourRange)
Now YourRange is a very large range.
regards
Re: Merging Pivot Tables With Standard Format
I have revised my Excel sheet as ROYUK has pointed out.. attached is the Excel Sheet on the third Sheet "Combined Sheets" is where my data from two stores A& B need to be merged.
regards
Re: Merging Tables With Standard Format
Thanks for the reply I shall explain. Consider that there are two shops and a customer by name Tom visits both the shops, Each shop gives its data at the end of the day. In different table. Now my task is to merge both data sheets. into one and present it .
regards
Re: Merging Tables With Standard Format
Hello Can u please answer my question pls
regards
Re: Merging Tables With Standard Format
Is my Question Not Clear????
Re: Lookup Data Meeting Criteria`
Hi thanks man!! Krishna
Hi All
I have used Pivot Table to get the desired result from two different worksheets (Table 1 & Table 2) the desired tables need to be merged into another table (Desired Results) According the values specified in the third table. I have attached a excel sheet for the same.
Kindly Note : Even though Column Name and Row Name in Table One and Table Two differes from Each other, I need everything merged in the Third sheet in the order it is given.
Thanks Kindly Help!
Re: Count Unique Items In Autofilter
Thanks Man..
Special Thanks to Krishna
Re: Count Unique Items In Autofilter
Hello Krishna
Thank you very much but the Col: H shows #NAME?
How to overcome ???
regards