Search results

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...

thanx a lot sir

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...

Dear Sir Thanks for response Will it work on office version 2003? Looking forward for some solution through formula or vba Regards

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...May i would be able to explain the same as under I have few text files in a folder which are named as mentioned in above excel screenshot. All text files have same length of data. The number of items in each text files is different. I want that the count of items in a particular file get...

Sir ..thks for the response...but the exact output is like as under The macro should pick the first file""test"and display the count in the file and sum of values from 27 to 39 column then it should go to next file and display the count and sum and so on... Thanks in advance for help Regards

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...

Dear Deepak I am attaching the excel reflecting the result which I want to attain Regards

Dear Deepak the issue is in my source folders there are multiple sub folders. some specific files from each folder to be transferred to destination multiple subfolders.

Hiii...I have created subfolders by creating .bat file with same name as source folders. i now just want to transfer some specific files from source subfolders to destination subfolders Regards

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...

Sir, I have checked the same on original data and it's working superb...Thanks a ton

Sir, would prefer formula?

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...

Sir thanks a ton...it is really amazing.... i really wish to learn the excel magic like you...hats off

Sir number of files I can make out by dividing total with 2500 and using roundup. I want data get split into different files. It will be displayed like A1 as 2500 then A2 2500 and remaining in A3

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...

Hiii..trying to figure out a chart having two value axis and dates of month on X axis. The value on y1 & y2 axis are the time/hours. i am looking that dates are fixed on X axis and chart gets updated dynamically on daily basis Please help Regards

Thanks sir

Hi..I am having simple data to be updated on daily basis. Dates are in column a and the data in column b. I want to keep dates from 1 to 31 fixed on x axis and dynamic dating of data on y axis. Presently if no datais present for forthcoming dates then chart reflects only dates for which data is...

Thanks sir

Hi...I have 100 jpg images with different names. I have 100 rows in excel which contains names of images but these names are partial. Is there any way out to open the images with the use of these partial names using hyperlink Regards