Search results

Hii Regret on being so late..I am attaching the inspect element code for all the tabs and buttons,etc. The goal is to download all these reports one by one and save in a folder. In case reports which are already downloaded then macro should go to next or other reports which are still to be...

Hii All... My query is related to automate a repeated process of downloading files. I have to work on company's intranet software. The application asks for User ID password. Then I have to select "reports" tab which further takes me to a drop down lists containing various types of reports...

Hiii...I am back wit a small query...It's very much working fine but i have to make following changes manually: Firstly, I have to change the font style from Times new roman to Zurich BT manually Secondly, Spacing is created between salutation and paragraph on mail body Thirdly, manually insert...

thankss...It's working on trial...will give a try on original data and get back..thanks Master

Hii I was looking for the expert's opinion on the query. I have a client details in Sheet named "data". In sheet named "Mail" I have email Ids of those clients and my team. I am looking forward for automation of sending the emails to various clients.The Mails id(s) in To: tab is in Column B and...

Sir In column G the unique values are getting reflected and in adjacent cells the matches values are appearing. It is working fine. But in Col G it is the search criterion and i want to search for only few cust IDs from the list appearing in Column A. Regards

Sir output looks like the following Col G CustID Product1 Product2 Product3 002 xyz abc mmm 003 def hhh 005 fff

Thanks for the response.. m using the same index and match combi but being an array formula it becomes very slow. I am working on 90000 rows. So I was looking for the code which could work faster Regards

Hii all Please help in getting the multiple values horizontally which matches a criterion. My data base is Column A and B. The search value if in column G and the search returns multiple results which matches in column A. Sample sheet is attached herewith Appreciate your help Regards

Thanks a lot for the response ... The challenge is I am using Excel 2007 Regards

Hii I have datasets in sheet one and two. I want to extract the differences which are appearing in sheet 1 but not in sheet 2 and vice versa. These differences get extracted and pasted in third sheet. The base to find the differences is combination of Invoice number and the amount. Please...

Excellent ...it worked.....:)

Thanks for the response...I do this But appreciate if it could be done through VbA

Hii Below are the two screenshots one is Input and other is output Input Screen Output Screen Can you please tell me how to extract unique value from column D and sort it and then sumif column B And Column C Regards

Superb Superb Superb!!! I have just started learning VBA and wish I could gain at least 10% of knowledge you have... Amazing

I did the same as under but the blank rows are getting counted Sub test() Dim myPth As String, fn As String, x, e, n As Long, ttl As Double myPth = "C:\Users\AMIT\Desktop\test" & "\" fn = Dir(myPth & "*.txt"): n = 1 Do While fn <> "" x =...

Thanks a lot..it's working A small modification is required...the length of text a single line is 11...so in case any line having length less then 11 or blank or any spl character should be omitted. Is it possible then it would be wonderful.... Kudos to u!!

Hello.. I am looking forward for your support. I have a folder in which there are multiple text files with same format. I would like to have out in excel sheet in the following format: Column A = Text File Name Column B = Count of records for each text file Column C = Total Sum Value of data...

Hii I have a data in excel file which changes on daily Basis. I have to format the same manually. For this I have written a simple code. But my problem is on daily basis i have to open the source file and then copy the data from source to macro enabled sheet and then run the macro and copy the...

Hii By records I mean the number of rows in the text files Regards

Hii There are multiple .TXT files in a folder. I would like to have file name of each file and the number of records in each file. Regards

Thanxxxx...amazing Would try to contribute by providing small solutions and I am sure that would enhance my knowledge

Gr8 Sir Narayan !!! You guyz are awesome....i practice in excel but its my dream I could gain knowledge atleast one percent of you have..Hats off Would you pls advise which books and blogs to follow? REgards

Thanx alot!!!!!.It's working KUDOS!!!! You are a genius Regards

Hii...thanks It is near to the requirement. But the actual output I am looking forward to in the format I have provided that is in Column form. First for a particular item the number of new items generated to be calculated and the count of items For e.g. For Items A , 3 new items will be...