Search results

Hi, Greetings... I have the following data with me (sample, unfortunately I can't upload) A1- has a list (Fruits, vegetables, animals) a2 - list will be displayed based on selection in A1... for eg if i select Fruit in A1, it will display only apple, orange and so on a3. List should be displayed...

Please help me to create a dashboard based on the below criteria 1. resource name 2. Month 3. Work Order (Project is assigned to resource) 4. Expected work to come 5. Leave records Single resource can work multiple Work Order. And vice versa.

Please help me to create a dashboard based on the below criteria 1. resource name 2. Month 3. Work Order (Project is assigned to resource) 4. Expected work to come 5. Leave records Single resource can work multiple Work Order. And vice versa.

Please help me to create a dashboard based on the below criteria 1. resource name 2. Month 3. Work Order (Project is assigned to resource) 4. Expected work to come 5. Leave records

1. https://rapidshare.com/files/629784523/Sale CounterV00912.xls 2. https://rapidshare.com/files/683782091/LinkV0912.xls 3. https://rapidshare.com/files/735462845/PMCvPAA0912.xls 4. https://rapidshare.com/files/1551893013/LinkMthV0912.xls 5...

We are required a execl sheet in which following should be maintained:- 1. All distribution should be maintained on the basis of advance payment from distributors. So, Distributors Account. 2. Order received by the Distributors. 3. on the basis of adavnce & order received from the...

How to make olympics medal chart with each country ranking

The o/p is not matching with the data which I was getting from 1st formula which I have mentioned in the post

There is no data at all. I was just trying to learn vba on blank page And found system behaving differently when i use rows("4:4") and rows("6:6")

Sub Manish() 'Keyboard Shortcut: Ctrl+m Rows("5.5").Select Selection.AutoFilter End Sub Hi this is very simple macro I have written. Filter is getting displayed in 6th row instead of 5 Where as IF i write Rows("4.4").Filter is displayed in 4th row I am testing the above formula in...

https://rapidshare.com/files/2722280117/Imp Support Report.xlsm The formula is in defect workseet copied in A2

INDEX(CV2:CV21,SUMPRODUCT(COUNTIF(CU2,"*"&$CU$2:$CU$20&"*")*(ROW(CU2:CU20)-ROW(CU19)))) It is throwing error

hI, It went into indefinite loop

Hi, I have two worsheet 1>First worsheet contains all the dates in 1st row. Below each row there are few data 2>In second worsheet , I have only two columns In first row , we have only 2 dates.. one is yesterday's date and the next column is today's date Now I have to copy all the...

IF(ISNUMBER(SEARCH("APOLLO 8",N6)),"Apollo", IF(ISNUMBER(SEARCH("BFUB 1.6.4",N6)),"Apollo", IF(ISNUMBER(SEARCH("Fix Team",AB6)),"Defect fix team", IF(ISNUMBER(SEARCH("IMPL & SUPP",C6)),"Implementation Support", IF(ISNUMBER(SEARCH("BFUB15-MCP-Interface-Testing-Actinver",C6)),"Implementation...

Thanks a lot to everyone..

Is it possible to find the names of all worsheets and store in the first sheet

Hi Sir JB7, This file doesn't solve my problem I will try to explain the complete process what we do daily 1>We have a URL from where we download issue list daily http://alm..com/support/support_reports/ub/ On accessing this url we select the first row which has down arrow at the end...

Hi, I am using excel 2007.. We download a daily report from a particular URL. This report is in csv. To download this file, we go to internet explorer, give the url , for eg:-http://downloadfile , there is an arrow button , on clicking which, option comes to download or open the xls come and...

Its working... Thanks a lot

Hi, Suppose my excel name is saved as tracker.xlsm which consist of recorded workflow which does all my calculation.. Once it displays all data I want it to store in a particular location with name as manish_today's date.xls

SirJB7, I have recorded one macro for the daily report.(I don't know to write macro, So just recorded all the steps.) Once all my steps are over, I want macro to save as COPK_today'sdate.xls

Hi, I want to ind the record in B cloumn which doesn't contain "COPK" In 2003 if I am using filter with custom option as doesn't contain "COPK", I am getting result But the same thing is not working in 2007

Hi, I have recorded all my steps in macro.. Now I want macro to save the file with today's date To be more precise I have a downloaded file, where I have recorded one macro which apply few formula's and filter and give me few records. This I was able to acheive NOw i want system to save it...

I am really sorry... I am talking about normal form check boxes... Suppose I have option to select rows .. As soon as we insert tick box in any row, it should hide that row For e.g I have check box options for all rows. And as soon as I select any row by putting check box, it should get hided