urgent excel help

I want to have validation while saving (without using macro) Lets say i have cell A1 to A10. If i enter data in cell A1, only then it should give validation message while saving that "Cell A2 to A10 should not be empty." Generally if cell A1 is not blank then cells A2 to A10 should not be...

Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...

Hi, I have a list of 70 clients with contract amounts and start dates on one tab. I need to make projection for 12 months in a way that for each customer no more than 15,000 monthly revenues is included in the forecast. For instance if the contract amount is 42,000 USD then I should account...

Hi Guys, I am doomed, Please help me I need your help to create an interactive Dashboard, I have a data divided is Categories and sub categories. Complete data is divided in 6 categories, Which further are divided,1) Location wise, Further divided as 2) Manager wise and so on it end at...

Hi, Need your help to convert the below formula into a Button VBA, If I use this formula directly on the sheet it is getting stuck into a Circular Referance, Circular referance is because, Q7 is getting calculated from the Range selected, but I want the entries to happen in the Range as per...

Hi Everyone, I maintain a contracts database and need to automate the total qty column. Having a really tough time getting it to automatically show those numbers. Summary: This data represents one contract (internally it is contract #18, externally, it is contract #21). It is broken down into...

I want to find the sum of top 3 values from several datas..But if my datasheet is not complete(that means i have less than two datas) and I want to get sum of the two datas..How can I do that?(if I put 0 on the blank cells,it works.But I dont want to put 0,I need to solve it by having the blank...

Hi, I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing...

Hi, The overall problem I have is that I need to identify codes found column H and column J that match, When they match I need to identify if the order number is different in column E. So when the number in H has a match then look in in J for a code that duplicates. H J...

<tbody> friday monday part qty date qty date 140880 25 6/20/2015 50 6/30/2015 140890 25 6/25/2015 7/15/2015 140891 30 7/20/2015 100 10/15/2015 </tbody> i have a report ran everyday for shipment dates i want to know if it is possible to pull in multiple dates...

Hi everyone, Today i gave my MOS Exam 77-420 : Excel 2013. i scored 980/1000. overall the exam was easy. i got 100% in all objectives except 90% in 'Applying Formulas & Functions'. I know where i did wrong. But i still can't figure out how to solve that problem because of which i couldn't score...

Hi, I am in desperate need. I have a file which looks similar to the data below: <tbody> A B C D E 20140930 3344 XYZ 141 AAB7 20140430 3344 XYZ 141 AAB7 20140930 3344 XYZ 2196 AAB7 20140430 3344 XYZ 2196 AAB7 20140930 3344 XYZ 21345 T2FG 20140430 3344 XYZ 21345 N8J5 20140930...

Can somebody please help me with a formula for buttons? I need that when I press a button the formula changes or adds a spacific number. for example if formula is "=60*D45+O43" I need to make buttons to make the number 60 to change to another number that i specified for that button. and if i...

Hello everybody, I have been working on a task where I have to copy some data from cell A1 and A2 in sheet2 of a workbook to a macro that uses it later. I have declared some variable and the values present in sheet2, cell A1 & A2 is assigned to them. But it gives me "Runtime error 9 : Script...

At work we use this spread sheet. Part of my job is to fill out this spread sheet whenever i issue the material for a job. Now if you look under the 1.75x4 colored in the blue there will be an arrow and it will say "arrow #1" what it is doing is adding it up,for how much material we have used...

Hi Everyone . . . Not really an Excel VBA expert, so I thought I would come try my luck here. Essentially, what I am trying to accomplish is this: I have two columns of data that I would like to generate, a date range and an hour range. I have the following range of data in Sheet 1 Column B...

hi, i wanted to write a macro that would truncate the cell B1 to 10 character from the right. Then rename the sheet with the right bit of the cell. And finally delete both cells. And repeat this process with all sheet in the workbook (they all contain a section number and section description in...

Hey Everyone . . . I have the following AVERAGEIFS formula in my workbook: =IFERROR(AVERAGEIFS(Data!$A:$A,Data!$J:$J,"="&CONCATENATE(TRIM($B$3)," - ",TRIM(Orders!$C3)),Data!$K:$K,">="&Orders!$H$1,Data!$K:$K,"<="&Orders!$I$1),0) The purpose is to average a number set if a string matches and the...

Hi All, I am trying to convert a table that looks like this: Time; Event 1; Event 2 12:00; 0; 0 13:00 ; 0; 0 14:00 ; 10; 0 15:00 ; 4; 0 16:00 ; 5; 4 17:00 ; 3; 5 18:00 ; 5; 0 19:00 ; 0; 0 20:00 ; 0; 0 21:00; 0; 0 22:00 ; 0; 0 23:00 ; 1...

I have a defined function in an excel file. When i paste the funtion in any cell it returns a value. I tried finding out where/how is it fetching the value through formula auditing, where i saw it's pulling the value from a sheet named Data2, cell g23, though this sheet is not showing in the...