Search results

Need to populate the data as per the sheet3 from sheet 2. need to macro to separate block wise data into separate sheeet No of customers is from account no column Collected is amount column due is the blank cells in amount column please heelp

Can you do it for me

Dear Sirs, I Need some inputs for the file attached to create a dash board Please help me in making it with ur ideas Guide me Mohandas

I mean to say i need text in the cell G3 if it is red colour as "Overdue",Green as OK and amber as "Due"

Can the have text basis the colour in the G columns instead the numbers

I need conditional formatting in f column basis g column if it is less than or equal to g column value it is green more the 5 in g colums value it is amber more than 10 it is red Please help

All INV columns containss formula it needs to be pasted as value

I Have a format which gets data by vlookup formula after getting the formula i need to get data copied and pasted with values in the same place, But that format also contains other formula which has to be as formulas. As solution for this Regards Mohandas

Cab any one help me

Dear friend. the data in the column a-l is month wise targets of the region it has to divided to the concerned parties based on the percentages for idea i have given 2 parties as example is there any short cut for this problem because i have 87 parties , Please help me in this matter

Dear All, I have one problem to look up I want to get data based on code and and cd code and closing as it is closing sheet I have given exam for one row Can you help Mohandas

Than

I need to get data from data sheet for all the other sheets based on region and sku as criteria There is any formula to get it Thanks

I have sheets around 50 which has differnent names like kovvuru ,rajunmundry so on I want to get the data from all the sheets of old file to the new one based on the sheet name ,brand name and channel name

I want the data of old to new format .i.e chemists of lactogen1 is 14 i want to get the 14 in the new format like wise for all the brands and channel

Dear Sir, There are 2 work books of same data with some changes it was about 70 work sheets with names i ha given one example kovvuru i named it as old and new. i have brand name as column heading and chaneell names as row heading i need to get the data by sheet name ,brand name and channel...

Please help brothers am waiting

I have 2 works books where sheets names are same . i want to get data from one work to another .there are 50 sheets in both of the files i have attached both same sheets in the excel work as i cannot attahced the file more than 1 mb

Dear Sir, what formula can be used to get the week number for a given date in a month for example 15.05.2016 is week 3 Regards Mohandas

I want to organise the as in the depivot file can you help me Mohandas

If i want for chemists what change i have to make

Dear Sir, data need to get from channel sheet w7 and brand product x438 to book1 example i have geven from swathi agencies Please help Regards Mohandas