Hi All
I am working with 2 million rows and come across a macro for fast lookup which states about Scripting Dictionary object. As i tried to use it, it worked tremendously fast but the issue is when it matches the value in Col A from sheet 1 and searches in master data in Sheet 2, it gives...
Hi..
I am trying to place data on secondary Y axis but no success. Tried but results are not as per expectation. Attaching herewith the sample data. Kindly help where I am missing
Regards
Hi All
I tried very hard to figure out of fetching multiple match results from different workbooks/ sheets. To brief out, I have named "desired output" having input data in sheet1. There are two different workbooks "Source 1" & Source 2" from which all data to be matched and fetched.
Scenario...
Hi
I was trying to pull data from different columns and paste on another sheet. In my sample data attached, trying to reach a result where Col A & D are non-empty and that data is pasted to another sheet. Now for col B only cases with status "Rejected" to be filtered and pasted with earlier...
Dear All
I am looking forward for a solution wherein the hourly productivity can be calculated on the basis of date and time. Date and time is in column A. Time is in 24 hours format. I tried countifs along with wild character but no luck
Could you please suggest. I am attaching the sample...
Hi
I am dealing in lakhs of rows on daily basis and has to compare sheets with huge data. The Vlookup when applied to such data obviously moves at snails pace. I have come across the double lookup methodology. I want to request you to please tell whether is it safe to use Vlookup with such...
Hii All
I have been looking for the way out wherein attachments can get saved in a folder when the mail is received from a specific sender.
The mail client is outlook 2010
Highly appreciate the help.
Regards
Hii
Please help me out to define the formula to compare the values in three columns with eachother. Sample data looks like as under
Sno A B C Result
1 1000 1000 1000 All values are equal
2 1000 1500 2000 No Values are matching with eachother
3 1000 1000 1500 Value A & B are matching but both...
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...
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...
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
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...
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
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 All
I have a query regarding dividing the total count of an item on the basis of batch size. The original quantity gets divided into different parts and gets renumbered. To describe the query properly I am attaching herewith the file where in input is in col A B C and desired output is in...
Dear All
The problem is that I have data in appx 2000-2500 rows and 20-30 columns. The data is in text format and then seperated by delimiter "|" (pipe)Few cells remain empty on random basis. I want the output where all the blank cells get removed from the data. The sample input and output...
Hello,
I have common data in multiple cells and i am looking any way out to merge all those cells and display that common value once. All other corresponding values in other cels should get diplayed in adjcent cells. I am doing it on large data manually. Attached file will give a clear picture...
Hii all
I am totally new to vba. I am figuring out a solution wherein I have list of text files in excel and all text files with same name are in a folder. There are around 40 files. I just want that int he adjacent two columns count of item in a particular file and the sum of amount which...
Hii All
I have an excel data in data is arranged citywise. City is mentioned in a cell and related data is mentioned underneath it. I just want city name appears in adjacent cell and number of times as data belongs to that city. Input data is in Sheet 1 and desired output is in Sheet2
Can you...
Hii
I am here with a problem of transferring or copying of specific files from source folder & subfolders to destination folder and subfolders. I have one main folder consisting of 200 subfolders named as 1,2,3.....200.
Each folder contains 100 image files. I have a list in excel in which...
Hii
I have a main folder containing thousands of jpeg and tiff images. I have a excel sheet in which on sheet1 all the filenames of these images are mentioned. I want to get images in new folder from main folder for all those file names which are mentioned in sheet 2.
is there any way out...
Hiii All
I have some bills and their status in column A as follows
Bill no1
exception: delayed
Bill No 2
exception: delayed payment
Caution : No lending
Bill No 3
Caution : Discount
I am looking that the exceptions or cautions related to each bill reflects adjacent to it like as under
Bill no...
Hii Gurus
I have query wherein where i have combined volumes in different segment. I have fixed file size of 2500. I want to divide the different segment data on basis of fixed file size
Type Total Number of files
A 5342 3
B 3245 3
C 2000 1
The desired result...