give

Hi I want a macro which could find the sum of column E:E and R:R If sum matches then give a message both E and R Matches would you like the macro run further Yes or no, If the user selects yes then macro should run further, if the sum of E and R column doesn't match then give the msg as sum...

Hello, I am creating a worksheet to log certain transactions so that I can automatically get the data in other worksheets. I added a button to start a series of inputboxes to get information about the transaction. The transaction is always at 1 of 2 bank, let's say Bank A or Bank B. I know...

I just received a bluetooth barcode scanner, and I'm having an excel-specific issue with it. I purchased the scanner to quickly enter student IDs, which have a Code 39 barcode on the back. Translated, the barcodes all begin with the letter S, followed by 8 digits (S00012345). Here's the...

if the data is protected, with a password, and I have to return the exact same column to another worksheet what is the best way to do this ? not copy and paste, it does not give me the same output.

Hi All, I am creating a table in Excel with various fields including a column for name. And in a different cell I am also creating a List (Data Validation) on this column NameMy question is: if there are names like Michael, Michell etc... then when I type M it should give a list of names...

Hi, I don't really know how to describe this too well, but here goes and I hope someone can help me. I have a cell which can have a number in. The number could be for this example, 15000. I want to then have a formula which will only ever take the first 10000 and multiply that by 0.45 and...

Hello, Please could you kindly assist, I have an excel summary doc, which i am trying to prepare. The requirements are for me to provide a summary page of Raw data in a vertical way as appose to current data that is horizontally... I am trying my level best to take two variables "Store...

Hello, I have the following formula on A3 = A2/A1 basically what I want my formula to read is that if we have negative with positives numbers or viceversa in cells A2 or A1 give me a N/A results, if my signs on both cells are negative or positive give the result and not N/A Thanks!

Hello Ladies & Gentlemen, I'm unable to get my head around this WEEKNUM Solution which you had provided on Excel Campus by Jon Acompora. <tbody> http://www.excelcampus.com/pivot-tables/month-to-date-mtd-comparisons-pivot-table </tbody> So I shall be breaking it down so that you can point out...

I need to get values from another file on the server. I don't want to open the file. Is there a way to reference a cell in a closed file? Really appreciate any help that you can give!

Im looking for a code in order to search all of column A for a value and select it, could anyone give me a hand? My boss will not allow me to use the CTRL-F feature.

Hello. I am trying to make a carshow judging sheet and I am wondering if this is possible. We judge and give scores for each vehicle for the class they are in. We also have specialty trophies that are judged but not issued scores like the classes are and we only give one trophy per winner so...

Does anyone have any code that will give me the row value of a chosen item on a combo box?

A little background... I work in a very busy surgical services department. We have a lot of rooms doing cases in a give day. We want to figure out how many cases are occupying rooms in a given time range. These ranges are: 0600-1500, 1500-1900, and 1900-2100 I already maintain a spreadsheet...

Hi guys, 　 Would like to ask for some help on a simple VBA formula that would allow me to sumproduct my cells selected and to give the result in the cell below. 　 e.g. I would highlight cells A1 to B3, and the VBA would sumproduct the selected cells (A1 to A3) and (B1 to B3) and give the...

Hello: I have: Dates in column F Negative/positive numbers in column V Helper column AB is for the month of the date (10/1/17 = 10, 5/31/18 = 5) The SUMIFS formula below give all the required values: =SUMIFS($V$2:$V$5000,$V$2:$V$5000,">0",$AB$2:$AB$5000,AD25) I want to get rid of the...

=IF(OR(M6>0, N6>0),($M$1+SUM($M$6:M6))-SUM($N$6:N6),"") is there any other formula who can do this type of calculation or any other way to do it because this formula give error.

Hi, I want to loop through a column and if the values in this cells are the same as my c4 cell value then I want all the corresponding values in column 34 in a a new column. I have the code below but all it does is give me the first value in the 34 column and repeats it. For Each cell In...

Hi All, I have a cell (V4) that works out the total point score of cells C4 to U4 "=SUM(C4:U4)" The Cells C4 to U4 are using a lookup formula "=VLOOKUP(Units!P44,GRADE,2,FALSE)*10" My question is if some cells give a #N/A it won't give a total points score. Instead I get a #N/A. How do I...

I have the feeling I'm making a silly mistake here. Here is my formula: =IF(S33="";"";IF(P33="Deutschland";Q33+$AS$7;Q33+$AS$7+2)) What I would like it to do is the following If S33 is 0 then give 0 as the result If S33 is higher than 0 and P33 = Deutschland give me Q33+A7 as the result...