How To Find Risk Analysis Calculation For The Attached Spreadsheet
Aug 7, 2014I am trying to find risk analysis calculation for the attached spreadsheet.
View 2 Replies
ADVERTISEMENT
Spreadsheet That I Have A Lot Of Macros That Are Attached To A Customized Toolbar Saved In The Same Spreadsheet
Jun 26, 2008I have a spreadsheet that I have a lot of macros that are attached to a customized toolbar saved in the same spreadsheet. I saved this is a read-only file. When I open as read-only and run my macros (testing), I save it as another file. When I then open the "template" to do the same thing, the toolbar/buttons now reference the file I previously saved as something else. Help please? Is there a macro that would delete all macros before saving the file as something else?
View 9 Replies View RelatedKey Formula (E10 On My Attached Spreadsheet)
Jun 25, 2009I am trying to set up a cell (E10 on my attached spreadsheet) to act as a key that would collect all of the PO#'s from a seperate column (cells A12:A27 on the attached sheet) and wouldn't repeat any of the repeat PO#'s. I am trying to do this because I currently save each order form by the PO #('s) and at times I find myself typing a long string of PO#'s for the book name. It would be much easier if this key cell would reflect all of the PO's for me and I could just copy and paste the contents into the save as box. This brings up another problem- when I try to copy and paste the contents of the key cell I have now, I just get the formula, not what the formula returned.
View 10 Replies View RelatedEmailing Attached Spreadsheet?
Nov 29, 2012Add worksheet as an attachment to an outlook email by having a button on the spreadsheet itself. However I have added another worksheet which i would like to add to the same email ie 2 attached worksheets to the same email this being decontamination certificate. I have tried to do this myself by copying and pasting some of the code and changing the paths and name but all I get is one or the other or the wrong name to the worksheet.
View 10 Replies View RelatedFormula In / With Dropdown: Calculate The Average %age In The Attached Spreadsheet
Oct 13, 2009Need formula to calculate the average %age in the attached spreadsheet. I would like to enter a score between 1 and 4, but with 1 = 10%, 2 = 25%, 3 = 80% and 4 = 100%. The score in the cell must still show as between 1 and 4 but the total must be an average of the relevant %ages. i.e. if scores are recorded as 1, 2, 3, 4, then the total average % will be (10%+25%+80%+100%)/4 = 53.75%. I'm not sure whether this should be in the Validation or in the Total cell.
View 2 Replies View RelatedAnalysis Using Sumif - Spreadsheet With Two Columns
Oct 31, 2012I have a spreadsheet with two columns, in column A i have text and in column B i have time format (01/01/1900 13:30:00) im trying to pull out information that if in column A says London to sum up the hours in column B is there analysis that would calculate this for me.
Area
Hours
Newcastle
37:30
Newcastle
37:30
[Code] ..........
The Results Of The Formula In Cell K36 In The Attached Spreadsheet Returns A Value Of Null
Feb 5, 2010The results of the formula in cell K36 in the attached spreadsheet returns a value of null. It should be $1,200. Am I blind or have I done something wrong. I just can't see the problem with the formula.
View 6 Replies View RelatedFormula For A Calculation With Varying Spreadsheet
Mar 11, 2014I've tried an if statement with AND function with no luck either.
my spreadsheet looks like this:
A1 = "One", B1 = 17/08/2013, C1 = 1000.00
A2 = "Two", B2 = 16/08/2013, C2 = 500.00
A3 = "One", B3 = 17/07/2013, C3 = 1500.00
A4 = "Two", B4 = 13/07/2013, C4 = 400.00
A5 = "Two", B5 = 14/07/2013, C5 = 300.00
"One" represents the total that needs to be paid and "Two" represents the payments.
What I want to do is recognise when "One" is present and deduct "two" from that amount, but the whole spreadsheet is never the same (the data is being pasted from somewhere else) so it's really, really difficult to do that.
So I want to do =1000-500 (for that period, so in D2 it should say 500) and then =1500-400-300 (for the other period so in D5 it should say 800).
NB: Any payment ("two") that comes in after the 17th of the month will be carried forward to the next months "one".
How To Create A Risk Matrix
May 1, 2014I'm trying to create a risk matrix like the attached example. I want to be able to enter a value and to have it to appear in the right quadrant.
View 2 Replies View RelatedCreating Risk Heat Map Without VBA?
Jun 23, 2014I am trying to create a Heat Map for Risk in a spreadsheet that auto populates. Very simple dataset and I can convert my values to numeric if that makes the graph easier. Data Set is basically as follows:
Column 1 - Risk Description
Column 2 - Impact (score of 1-5)
Column 3 - Probability (score of 1 to 5)
Column 4 - Risk Indicator (Col 2 x Col 3 to give score out of 25.
Looking to create Heat map with upper right being my highest risk and lower left the improbables or low impact. I should mention that my VBA is as good as my Latin skills, i.e. Zero! so looking for a way of doing it through excel, either suggested or inbuilt charts.
Calculate Reward To Risk Ratio
Sep 30, 2003I have a spreadsheet that calculates Reward to Risk Ratio for the stock market investing. The formula is Target Price - Entry Price / Entry Price - Stop out Price.
The problem is the ratio often comes out to something like 3/4 or 7/8.
Is there a way to reduce the result down so that the first number is always a 1 to make it more clear but still maintain the ratio. For example, 1-1.3, or 1-7.8, etc.
Find All Instances Of "Text" In A Range, And Add Time Attached
Dec 23, 2009I am not even sure if what I need is a possibility with excel. I need to "find" specific information and the amount of time that is attributed to it. All of the information is provided via drop down box (times as well) in daily segments then grouped by two week (bi-monthly) chunks and have the total times for each information type placed elsewhere. There are notes placed in the excel file to the right of the information you will see when first opening the file.
View 4 Replies View RelatedData Analysis: Place Called Data Analysis Under Tools
Nov 22, 2006in excel, is there a place called data analysis under tools? im an exchange student in sweden andthe work that teacher gave me is half swedish and half english.. im looking for histogram there.
View 3 Replies View RelatedMatrix To Return Risk Rating - Array Returns Opposite Result
Nov 20, 2013I am looking up a risk matrix to return the risk rating... it is very simple, it works on one sheet, but on a different sheet (looking up different data, but same basic format) it returns exactly the opposite rating.
My formula is: =INDEX($G$6:$K$10,MATCH(I19,$G$5:$K$5,0),MATCH(J19,$F$6:$F$10,0))
Here is F4 to K10
I have data validation on I19 and J19 based on the cells below
Consequence
Priority
Very Low
Low
Medium
High
Very High
[Code] ..........
BUT... when I put Very Low and Very Low in the two cells (I19 and K19) I get Very High as the return.
Create A Find Button In The Spreadsheet
Jan 15, 2009I'd like to create a button that makes the "Find and Replace" popup come up when pressed. How to do this? (Ctrl + F is the shortcut for it)
View 3 Replies View RelatedFind The Last Cell With Data In Spreadsheet
Feb 25, 2009I have a spreadsheet that I have been entering and deleting data from. Currently there is data in A1:J1 only, however, when I Ctrl+End my cell focus is on J242. I have deleted rows 2 through 300 and cleared all from the Edit menu on cells A2:J242, both to no avail. How do I clear this so that if I Ctrl+End it goes only to J1?
View 2 Replies View RelatedFind Next Empty Row In Spreadsheet Using A Userform
May 24, 2006I‘ve made a Userform which should transfer data form the userform to a spreadsheet (see Example). Because the spreadsheet contains a formula in column A the data must be place in column B and further. This part of the code is working. I also want the data to be placed at the first empty row. The following code works when no data or a formula is entered in column A. Because column A contains data up to row number 14 the data will be placed in the first empty row number 15.
Private Sub cmdAdd_Click()
Dim lRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
' Find First empty row
lRow = ws. Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row
The code has to be changed so it will find the first empty row. If I use the userform in this example the data must be place in row number 6 in the columns B till L.
SUMIF: Find Out Duplicate Records In My Spreadsheet
Apr 4, 2009Im trying to find out if there are any duplicate records in my spreadsheet. See look at the attached. Cell 6745 down is highlighted in green. I want to check this against all the cells above. need to write a formula so that it marks any products in the green section with duplicate (in column I) if they are in fact repeated.
View 2 Replies View RelatedHow To Find Missing Numbers In Excel Spreadsheet
Dec 24, 2012i need to find the missing numbers from 12 rows of 20 numbers.
ie, i have these numbers (only between 1-80) and need to find the *normally* 2 numbers that are not in that list between 1-80. there are 14 rows in this example
134810131417182832464855565758596475
412131417212223303235374044545861707880
57101117202528303435363940495155606264
35121823254148495051565860646670767879
311161719212225262829404447586063697578
126713162326353638394652535863707678
710172021272930414445464750515569727374
[code].....
these numbers wont be the same every time, but in theory after i enter 12 rows there should be only 5/6 numbers left max.
i need a script so that when i copy/paste 12 rows, i can be presented with the numbers not in that field. or even if i have a field of 1-80 displayed, then i copy paste my numbers in the fields below and can somehow highlight which numbers between 1-80 aren't in my pasted fields on the 1-80 field.
btw the numbers missing here are 24-68
ps im using excel starter 10 if that makes a difference
Find Data In First Spreadsheet And Then Copy To Last Row Of Destination Sheet
Nov 8, 2012I think I am closer but how do I get all of the data from A2 in the origination worksheet and then copy it to the last blank cell in column A in the destination sheet?
Code:
Sub test4()
Dim lastrow As Long
Set StartSheet = ActiveSheet
'MFG PART NUMBER
StartSheet.Range("R2").Copy
Workbooks.Open Filename:="D:\_DoxaMobiusServtrax Import Template"
[Code]...
Find A Value In Cell Then Copy Entire Row And Paste At Top Of Same Spreadsheet
Jan 8, 2014first need to look for "PR" in column G, if found need to cut the entire row and insert at the top of the same worksheet.
View 1 Replies View RelatedFind Amount In Variable Call Locations That Change On Each Spreadsheet
Feb 15, 2012I am acquiring multiple spreadsheets that do not always match row number, due to additional information on some sheets. By this I mean that the information may be in row 31 on on sheet and row 39 on another, the column location is the same each time. I have been trying Vlookups, indexing and matching plus combination formulas - with no luck. How to get the information I need with a moving cell reference?
I can provide a small copy of a workbook, if needed.
Create A Macro That Find And Calculate Based On Details Of 4 Columns On Same Spreadsheet
Jul 21, 2012create a macro that will find and calculate based on the details of 4 columns on the same spreadsheet.
Basically, here is what I need to do:
1. Need to calculate how many QTY IN (Column F) and PALLETS IN (Column I) of a specific PART# (Column A) and LOT CODE (Column B) For example if enter a PART # and LOT CODE, it will calculate how many QTY IN and PALLET IN of that PART # and LOT CODE.
2. Need to do the same for QTY OUT (Column G) and PALLETS OUT (Column J) also.
3. Output should contain the PALLET # , QTY IN and PALLETS IN based on the PART # and LOT CODE search. I just want to simplify the search function in this spreadsheet because it is very cumbersome if you need to find how many items left for that PART # and LOT CODE.
Attached is the spreadsheet..
Attached A Macro To Button
Sep 18, 2006I attempted to attach the following Macro to a button. But when I tried to run it the following errors: Complie ErrorInvalid inside procedure.
Sub commandButton()
Option Explicit
'Dim MyArray(6, 4)
Dim MyArray(200, 4)
Public MyData As Range, c As Range
Private Sub cmbAdd_Click()
'next empty cell in column C
Set c = Range("c65536").End(xlUp).Offset(1, 0)
Application. ScreenUpdating = False ' speed up, hide task
'write userform entries to database
c.Value = Me.Textbox1.Value
c.Offset(0, 1).Value = Me.TextBox2.Value
c.Offset(0, 2).Value = Me.TextBox3.Value
c.Offset(0, 3).Value = Me.TextBox4.Value
c.Offset(0, 4).Value = Me.TextBox5.Value.....................
Split Up The Address In The Attached Sheet?
May 27, 2014I'm after a formula or some formatting trick to split up the address in the attached sheet. As you can see, the addresses have come through from a database in one cell, instead of a separate cells for the street line and the suburb line, making it difficult to merge for mailing.
eg. the address are coming through to the merge like this;
Joe Bloggs
3/119 newtown street sydney nsw 2001
When i need them to look like this;
Joe Bloggs
3/119 newtown street
sydney nsw 2001
Match Columns With Attached File
Mar 8, 2007I attached a sample of what I am working with basically at the end of the day I download all my sales and the following day my distributor sends me a sheet with all the orders that went out.
what I would like to do is match column A and C of the attached fileand have them match up on the same rowso then i can just deduct D from B and see how much I made off that particular item. im sure I have to put C & D in a diff sheet but I still do not know where to go from there
I know from the sample it would look like I could just sort but sometimes there is more in C than A or vice versa because of orders that were filled a day late or so.
Re-create The Attached Chart (.jpg File)
Apr 27, 2009I would like to re-create the attached chart (.jpg file) but have tried for the past 30 or so minutes with no luck.
I know how to arrange my source data. I just do not know how to combine the stacked columns with a line graph.
Attached Additional Pdf File To Email?
Aug 18, 2014I have an existing macro that convert active sheet to pdf then email it as an attachment thru outlook.
now, what i need is to attach another pdf file in it, so it will now be 2 attachment. here is my codes:
var all_spans = document.getElementsByTagName( 'SPAN' );
for( var i =0,skip =0 ; i [code]......
Sends An Email With A List Attached
Sep 25, 2008I have a list of products in column A and a expiry column B. What I'm trying to do is when I open up excel, a macro gets invoked and creates a list of expiry products based on today, then sends me or someone else an email with a list attached or in body doesn't matter, so that I can attend to the problem. I've searched a lot of places and haven't found the right answer that I'm looking for. This shouldn't be new because I think others would have wanted to know something similar.
View 5 Replies View RelatedAttached Message Window Pops Up
Oct 18, 2009When I run my Excel 2003 macro, the attached message pops up. Is there a way please to modify my macro so that when this Excel message pops up, it automatically selects OK?
View 3 Replies View Related