missing

Hi all, I have been compain 100 files in one master file using VBA, Sub GetSheets() Path = "C:\Users\dt\Desktop\dt kte" Filename = Dir(Path & "*.xls") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets...

So I have a table with multiple columns, each representing a store. The rows are individual products while the value is the discrepancy of stock ie we are missing 5 stock (-5). Now I want some sort of tool that can calculate that if I’m missing 5 in one store, I can move 5 from another branch to...

Hi everyone, Looking for a code that will populate e-mail drafts within outlook, but not send them out, based on information within a table. The table name is Email_Table, and the sheet is Sheet1. Specifically, what I need to populate within the e-mail is: 1) The subject which is in cell B1...

I have report that comes out of a legacy system with fiscal period end dates as column headings and budget values below: <tbody> 1/31/2018 3/31/201 4/30/2018 7/31/2018 9/30/2018 50000 25000 40000 30000 45000 55000 30000 45000 150000 30000 40000 45000 40000 25000 50000 </tbody> I need...

<tbody> Table 1 Table 2 Table 3 </tbody> <tbody> DL DM DN DL DM DN DL DM DN 1 SHIFT SHIFT SHIFT 2 1 16 1 16 1 16 3 2 17 2 17 2 17 4 #N/A 16 18 #N/A 18 18 #N/A 16 18 5 3 19 3 19 3 19 6 #N/A 17 24 #N/A 24 24 #N/A 16 24 7 #N/A 18 27 #N/A 27...

Hello all this is Mike I want to use a "template" file named CALC_Letter_Matrix_TEMP.xlsm. The macros work fine is this file. An MS Access database is using this template file and changes the name to a permanent file name with a date stamp in the file name. When I open the saved file the...

Hi All, I am entering the below formula but it says missing parenthesis =IF(AND(C10>0%,C10<80%),0,IF(AND(C10>=80%,C10<=100%),C7*C10,IF(AND(C10>=100%,C10<=120%),(C5*0.5%+(C7-C5)*1.5%,IF(C10>120%,(C5*0.75%+C5*120%*1.5%+(C7-C5*120%)*2% Can any one help C5 is Domain Target C7 is Achievement...

What is it a about this formula on why t wont work? What ()"s missing? Any help will be appreciated. =IF($G$20=$S$22,(B32-(B32*0.3%+1.5,(IF(AND($G$20=$S$23),(B32-((B32*0.15%+0.3)

this formula works perfect until i add more to it =MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000)))) (which is an array formula)...

I'm looking for a formula starting in K7 that will return the missing digits.The total digits are 0,1,2,3 that’s all and in row F7:H7 are my initial digits. Thank you <a href="http://tinypic.com?ref=2uegrx1" target="_blank"><img src="http://i64.tinypic.com/2uegrx1.png" border="0" alt="Image...

Hi I am trying to convert a cell that has a time exported as text into a cell that will contain the numeric value of time. I am using the function TimeValue(cell) but I am getting a type mistmatch error. Can anyone tell me what I am missing? this is how I am doing it (in a loop)...

I have several columns of data for which I want to plot x-y charts. The first column is the x, and the other columns will be y for different individual plots. There is missing data in the y columns. Excel treats the missing data as zeros, and plots the points along the x-axis. How to avoid this...

Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3 =IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))

I'm working on customizing my mac excel 2011 toolbar. Using View/Toolbars/Customize I can add and delete buttons. My problem is I want to add the "Edit Comment" command/button but it's missing from the list. It was there yesterday because I put it on my toolbar but then took it off. Ever since...

Hello all, I have what is hopefully a simple solution to solve. I have a sheet for staff to complete entries into columns A-G a single row at a time. In column H I have a check to make sure all entries are made and return a 1 if anything is missing. In column I u have the users email address. I...

Hello is there a formula or a VBA code to find the missing Date. i have a column that i need to review every month to identify the dates that are missing. example is below. if the column was small as bellow i can identify that i am missing 12/3, 12,4--12/8 712,9. THANK YOU IN ADVANCE...

Not being a coder, I found what I would think to be a pretty simple example of code on the Microsoft support site that compares data in two columns to find duplicates but puts the matching data in the column to the immediate right of the selected column. Cool, but not quite what I need. I was...

Hi all...my name is Doug. I have been dabbling in VBA for a couple years and probably been a guest on here a bunch of times. I am new member today! I have some code to fill in a bunch of cells with number incremented by a specified value. It is pretty basic stuff but I have found that it...

Hello. I have a workbook that I have developed for mycompany & included various marco's & userforms. Occasionally when a useropens the workbook they get an error message. It appears to happen after anOffice update. The error message is “compile error: Can’t find project library”.I know how to...

Display the missing number in number series. Ex : Colum 1 1 2 3 6 7 8 Missing number is 4 & 5 that will display in Column 2 like; 4 5