Search results

Have revenue distributed between two years. How to calculate the carryover revenue with given start date of the project assuming project affected for 12 months Start date = 03/08/2017(MM/DD/YYYY format) End date = DATE(YEAR(Start),MONTH(Start)+11,1) Gross Savings = 12000 Monthly savings = Gross...

Dear Experts, In the attached table, i need to make data validation using macros. Fonts in RED color are the sum of rows and columns. Requirement: whenever the inout is given in that particualr column or row the sume should not exceed the corresponding value in both rows and columns. If it...

Dear Experts, All my excle files have been corrupted and unable to open any of them. I tried couple of free download for excel file recovery in google but non of them helped me. Your file is severey damamged unable to recover is the message i am getting. Please help me....as they are some...

Dear Experts, i have issue with date. i need to change the date format from 21-08-13 to 7/8/2013. When i apply format only few of them are changing and most of them are not changing the original format. Both the foramt are in DAte format need to change them to MM/DD/YYYY. i tried changing...

Hi All... I am trying to take the difference between two days which is in the format of mm/dd/yyyy hh:mm:ss ie., between two time stamp 2/29/2012 12:11:23 AM & 9/11/2012 3:14:20 PM. I know only Hour formula but breaking my head to solve this using formula... could you please help me on...

i am curious to know the excel survey result that you took few weeks back... is it published...Did i missed it? if so, Help me with the link .... Dee...

Dear All, This is a query on one of the Lukes's post in Chandoo.org (Formula Forensics No. 003 – Lukes Reward). Here in the specified formula we can have only one condition can be fulfilled ie., in the below example it is cell D2. what if i need to add more that one condition say <2 ...

Dear All, I need to generate serial number in the summary sheet. I have a summary sheet and a template (hidden). Macro is written to create copy of template and has to pick few details from the newly created idea template to the summary sheet.Till here its working fine. once it copies details...

Dear All, I have around 20 word documents and each containing 9 tables. I want to copy all tables from all files into an excel sheet. This is required to consolidate the performance rating. Can you guys suggest me a way to get it...? Thanking you in advance, Dee...

Hi All, I have 2 ranges one is Self & 2nd one is Manager. If average of self range is >=2 then L1,if it is >3 & <4 it is L3 & if it is <= 5 it is L3. same condition applies for Manager range also. For the value in self range the answer should be average of self range & Manager...

Hi Guys, I have two columns say Rank & Confidence. if ranking is more than or equal to 9 then the minimum of corresponding confidence level should come in Cell A3. i tried using extra column but was not satisfied, i guess there should be some smarter way of doing it using formula...

I have created a report for a report card. Student's name is stored in sheet2 and report is present in sheet 1. cell C3 contains Students name. I have 30 students and what i need is C3 should change automatically by using list f 30 students in sheet 2 and generate 30 different reports and save...

Dear Experts, I have a macro which reset all the radio button to blank at a click but the same will not work when the radio button are linked to a cell. Here is my codes... Private Sub Worksheet_Activate() For x = 1 To Sheets("B.").OLEObjects.Count Sheets("B.").OLEObjects(x).Object.Value =...

Dear experts, i am trying add a text called "NULL" in the last cell next to the list in a row. EX: if list starts in A1 and ends in C1 then the word "NULL" should come in D1. Below is the code i wrote somehow it is neither working not showing any errors. Can any one of you help me on this...

Hi, Is there a way to update the filter to other pivot tables same as that of first pivot table using macros? I have 4 pivot tables in a sheet and i am applying filter to first report filter and i want same thing should be updated to all pivot tables via macros. can Macro experts help me on...

I need to add Grand total to pivot chart. Grand total column is appearing in pivot table but it is not considered in the pivot chart. Can you guys help me in showing GRAND Total in the Pivot chart? Thanking you in advance, Dee

Dear All, i am trying to copy columns form sheet called "Productivity_Project_Record" to "Project List" only those columns whose heading are there in sheet "Headers" ie., from A1 to A55. Here is my code i am struggling with... can any one of you pls help me on this Private Sub...

Hi, I am trying to convert 2003 Excel file to 2007 macro enabled version but i am getting error like... "Excel found unreadable content...Do you want to recover the contents of this workbook?" If i choose YES It will open a repaired version of the file by removing the unreadable contents.If i...

Hi all, i have big list of 100 rows and 20 columns data for which i need to add sub total for each change in levels. For Ex: Level 1 is broad category which have many Level 2's and Level 5's Each level 2 is again have sub categories like 3's and 4's. under each Level 2 we may or may not get...

Hey All, I am trying to copy few columns from one sheet to another or from one file to another using excel macros. It should pick the columns based on the column headings (EX: Emp Id, Location,Department etc.,). Can any of the macro experts help me with macros. Thanking you in advance, Dee

Dear experts, My macros are retrieving data from other excel file and the file is linked to other excel file in share point site. When i just retrieve data from other excel file that particular tab will have issue in scrolling to left/right/up/down. If i export it to access and then again to...

Hi, The pivot table that i have created always sort either in ascending or descending order.i have to retain the same order that i have in my source data.Can anyone help me on this pls... Thanking you in advance, Dee...

Hi Guys, Below is the code which i am trying to copy column from one sheet to another by using input box.What missing in this is, its copying only from the default opened sheet. I need to give input for sheet also similar to source and destination column via input box or any other way. Can...

Hi Guys, Basically i am trying to calculate the volume and the input for this is in 4 columns ie.,input for length(L),width(W),depth(D) & diameter(Dia). Requiremetn is, If input for "L","W" & "D" is given then it should not allow user to enter value in "Dia" cell. Similarly if input is...

Hi Guys, I am using the below code to search for an excel file.Can any one of you suggest the code to get the image/picture files (jpeg,jpg,bmp files for example)in the similar pattern? Flatfilename = Application.GetOpenFilename(FileFilter:="Excel files (*.xls), *.xls", Title:="Please...