Track The Levels: Club Is 0 To 19 Points And Yields An 11% Discount
I have a 4-level program. The levels are Club, Bronze, Silver and Gold. Each is awarded when a certain amount of points are gathered.
Club is 0 to 19 points and yields an 11% discount.
Bronze is 20 to 44 points and yields an 12% discount.
Silver is 45 to 59 points and yields an 11% discount.
Gold is 60 and better and yields an 11% discount.
I am looking for a way to total the points and have the spreadsheet automatically calculate the leve and percentage. So if my total points is 22, I would need the formula to return "Bronze" in one cell, then "11%" in the next.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Conditional Statements Using IF: Get A Discount (no Discount) Not To Apply The 10%
I have attached a 2004 excel document that has a conditional statement that says, if an amount is over $400.00 you get a 10% discount, else, the cell says no discount. That is working fine. I also have a absolute cell ready to do the math for the 10% amount. There is also a column that shows the discount amount and column that shows the amount after the discount has been applied. Since I have been just doing one calculation and auto-filling, my problem is, how do I get the record that doesn't get a discount (no discount) not to apply the 10%?
View Replies!
View Related
False If Result Yields Unexpected Error
If I create a simple conditional statement in a cell: =IF(A8="NX-QSNT",B8, "") I get the expected B8 cell contents when "NX-QSNT" exists in A8, or blank when it doesn't. If instead of qualifying this full string, I try to Search for the "-QS" string in that cell as the criteria: =IF(SEARCH("-QS",A8),B8, "") I get the expected B8 cell contents when "NX-QSNT" exists in A8, but I get "#VALUE!" if it does not find this "-QS" string. I'm guessing it may be because SEARCH isn't actually returning a TRUE/FALSE response, but rather, a numeric one based on the position of "-QS". I tried using a numeric approach also, but this didn't help: =IF(SEARCH("-QS",A8) > 0,B8, "")
View Replies!
View Related
CountIf: Frequency Distribution Of The Yields Column
I'm working on has me making a frequency distribution of the yields column. If you look at M6 on the spreadsheet i'm trying to use the formula: =COUNTIF($I$6:$I$35, "<=L6") to represent all yields that are less than or equal to 0, in the next box (M7) I want to represent all yields that are greater than 0% and less than or equal to 1%. etc until I reach 7%, however the original formula isn't working and I don't know whats wrong with it.
View Replies!
View Related
Demarcating An Unusual Series To Club Alike Elements
Demarcating an Unusual Series to club alike elements. First and Foremost ... Happy Diwali to everyone. May this year bring peace and happiness to the globe less of terrorism and war-like situation.. Now back to the query... I need to not only count the no of cheques used for a particular account but also understand to which Cheque Book they Belong to.. I have some cheque mentioned one below the other not neccessarily in series but they need to be clubbed to Series 1 and if not alike then the next Series i.e. Series 2 so on so forth.. I have atttached the file which can explain in better manner the exact requirement.. Please someone help me on this as I have burned enough midnight oil with no futile gains till now.
View Replies!
View Related
Formula: Recognise When A Child Equalled Or Bettered A Club Record In An Event
I wrote a formula to recognise when a child equalled or bettered a club record (CR) in an event. However what I neglected to do and cannot work out is for the formula to recognise the new time as the new club record that will then have to be equalled or bettered from then on to be recognised as a club record. For example CR for 70 metres is 9.28 secs. Formula I was working with was IF(ISBLANK(B3),""),IF(B3
View Replies!
View Related
Discount A Row
Is there a way to insert a discounted row at the top of an existing spreadsheet? I'd like to name it "0" or "Row Zero" or "MasterRow" or something similar, such that the existing rows retain their original numbering, and none of the existing code is effected.
View Replies!
View Related
Discount Function In Macro
I have a quote system which takes data from tabbed sheets if there value is greater than 0, then does a simply formula which is then times by a discount which found by searching for the sheet name and then attaching the appropirate discount. In short this means that the whole forumale doesn't work and is not displayed
View Replies!
View Related
Discount Based On Amount?
I need to create a price list a we give a discount based on the price of the product for example:.... All products over £100 have a 10% Discount, how do this and also at the sametime round the value up to 0.99p. ie Product ZXY123 is £123.99 10% off is £111.59 we need the calculated price to be £111.99.
View Replies!
View Related
Cost Price Vs Quantity Discount
I'm trying to work out how to get a spreadsheet to calculate when it works out cheaper to buy more of something, due to quantity price breaks, than less... e.g. 1-10 are £12.50 each, but 10-20 are £10 each and 20-30 are £8.75 each.. so it's as cheap to buy 10 (10x10=100) as it is 8 (8x12.50=100) and cheaper to but 10 (100) than it is to buy 9 (112.50) than 10... but there are similar price breaks at 20, 50 +
View Replies!
View Related
Calculating A Discount Based On Certain Rules
I'm looking for assistance with working out the following formula. I live on an apartment complex in Marbella Spain and we pay Monthly Community Fees of say $100. We want to calculate a penalty amount for late payers of say 30% of the monthly fee due for non payers? So for instance if the monthly amount due in Cell D8 = 100 and the actual amount received in cell E8 shows 0 or then increase any figure due for the following month in Cell F8 should increase by 30% ($ 130) in the following month. and so on I use Excel ver 2003. Trust my query is reasonably clear?
View Replies!
View Related
Stock Levels
how to go about actually doing it, For an old project which was a till system i had two sheets,a data sheet and till system sheet , the data sheet contained : example: column A - numbering of the data (to be used with V Lookup) column B - product name Column C - price This would then be replicated in the next 3 cells for the next data category. Till system then had a combo box which had a cell link on the current page and data from the data sheet and then i had a price column next to i (containing V Lookup formula) the price then changed depending on the choice in the combo box. I want to incorporate combo box's in to this new project. If i can then get some kind of stock thing i intend on then using conditional formating to colour code stock levels to show severity of needing to order etc..
View Replies!
View Related
IF Command - Too Many Levels, Alternative?
I am trying to use the command below to report what type of bonus is to be awarded. .05% - 1% bonus, commission based. =IF(E7>=0.12,1,IF(AND(E7>=0.115,D11<=0.1199),".09",IF(AND(E7>=0.11,E7<=0.1149),".08",IF(AND(E7>=0.10 5,E7<=0.109),0.07,IF(AND(E7>=0.10,E7<=0.1049),"0.06",IF(AND(E7>=.095,E7<=.099),".5",IF(AND(E7>=.09,E 7<=.0949),".04",IF(AND(E7>=.085,E7<=.0899),".03",IF(AND(E7>=.08,E7<=.08499),.025, IF(AND(E7>=.07,E7<=.0799),".15",IF(AND(E7>=.065,E7<=.0699),".005"))))))) It is telling me there are too many levels. I am not an Excel expert, so I am trying to figure out an alternative to this command, I am sure one is available.
View Replies!
View Related
Different Users, Different Levels Of Views
Right now, I've this pop up box which prompts users for passwords and user name for log in. They are two main users : Admin and User. Admin is the user which is allowed to see all sheets. While User is only restricted to user interface sheets. The problem is for the "User" I want to restrict a view in the sheet "ELEMENT". I wish to hide columns L to AI if "User" logs in. But if "Admin" logs in, I want no columns hidden. Everything must be visible. Private Sub CommandButton1_Click() Sheets("Main").Select Dim strUser As String, strPword As String, strWs As String Dim w As Worksheet, c As Range, r As Range strUser = Me.TextBox1.Value strPword = Me.TextBox2.Value Select Case strUser Case "User" If strPword = "User" Then Sheets("SMXINVENTORY").Visible = xlSheetVisible Sheets("SMVINVENTORY").Visible = xlSheetVisible Sheets("SMIINVENTORY").Visible = xlSheetVisible Sheets("SMF1INVENTORY").Visible = xlSheetVisible..............
View Replies!
View Related
Solver With Constraints For Inventory Levels
I have a maximization problem. I have to maximize Kitchen Sets given available materials. I have 11 different Kitchen Sets and every set requires different material.I have attached an excel spreadsheet for making the problem more clear. I have T1;T2;T3;T4;M1;M2;M3;M4;O1;O2;O3;O4;Z1;Z2;Z3;Z4 different materials. Every kitchen sets requires one material from T which is fixed (for example T2), one material from M which is fixed again (for example M3), one material from O which is fixed (for example O1) and one material from Z, which is fixed (for example Z4).To complete a set the sum of all materials used should equal to 4. I have some constrains T1+T2+T3+T4<=2 it is the same for M1+M2+M3+M4<=2, O1+O2+O3+O4<=2 and Z1+Z2+Z3+Z4<=2. So basically my goal is to say which materials should I keep in stock in order to maximize the Kitchen Sets.
View Replies!
View Related
Convert Levels To Numerical Values
I need to convert levels to numerical values and then: Firstly, add together two vlookup values THEN divide by 2 to get an average AND THEN see if this average AND a second, individual lookup value are above a specified another value, which may be different. IF all these criteria are set, return, "yes" if either the first or second, or both criteria are not met then "no" Or put it another way. if lookup values A+B/2>"5" AND C>"3" then "yes", Else "no" Lookup chart: P11 P22 P33 P44 P55 P66 1c7 1b9 1a11...............
View Replies!
View Related
Autonumber/highlight Stock Levels
to create an order ID so when customer is transferred from the new order to Existing orders it will automatically generate CUW001 for first order then CUW002 for the second order and so on I have added a column form Order ID so this may have affected the macros pasting location. Also one last thing could you also tell me how I could highlight stock items red if the stock levels fall below 5 i have attached the spreadsheet
View Replies!
View Related
Workbook Password Protect 2 Levels
On opening a workbook (XL2003) I want users to enter a password which will give them read Only permissions or access to the whole book. I do not want use the "save as" option it is not suitable for my needs & here is why. I have about 10 staff who need to fill in timesheets using XL SS on a public folder on the server. The staff need full access to file & management such as myself only need to view (read only) the timesheet without the ability to change data. Using the "save as" function the staff need to input 2 passwords. The staff (in general) are not overly computer literate so I was hoping to be able to write code so that on Workbook_Open event only one password is entered and depending on the password gives the user full access or readonly access. This will also save management having to remember different passwords for read only access to different staff timesheet files & will give crude protection to the files. Private Sub Workbook_Open() Dim Message, Title, Default, Password As String Message = "Enter your password" ' Set prompt. Title = "Password" ' Set title. Default = " " ' Set default. ' Display message, title, and default value. Password = InputBox(Message, Title, Default) If Password = "test" Then Workbook.ReadOnly = True Else Workbook.ReadOnly = False End If End Sub Error occur on "Workbook.ReadOnly" lines . I also want to put an errorchecking code for invalid passwords. Again, I know I can use the "save as" option but that is not what I need.
View Replies!
View Related
Figuring List Price - Cost To Show Discount Percentage
List Price $46.98 (e2) Net Cost $19.53 (e3) How do I enter a calculation that will show me my discount percentage from my supplier? (e4) I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item.
View Replies!
View Related
Formula Is Returning Msgbox Too Many Levels Of Nesting
I have the following formulas which when I try to put in excel, it says I have too many levels of nesting: =IF(K4="","",IF(AND(Hta_1>=D4,Hba_1<=D4,Hta_1<>"",Hba_1<>""),1,IF(AND(Hta_2>D4,Hba_2<=D4,Hta_2<>"",H ba_2<>""),2,IF(AND(Hta_3>D4,Hba_3<=D4,Hta_3<>"",Hba_3<>""),3,IF(AND(Hta_4>D4,Hba_4<=D4,Hta_4<>"",Hba _4<>""),4,IF(AND(Hta_5>D4,Hba_5<=D4,Hta_5<>"",Hba_5<>""),5 ,IF(AND(Hta_6>D4,Hba_6<=D4,Hta_6<>"",Hba_6<>""),6,IF(AND(Hta_7>D4,Hba_7<=D4,Hta_7<>"",Hba_7<>""),7," No reinforcements"))))))..........
View Replies!
View Related
Collapsible Rows & Column With Different Levels
I have been using a spreadsheet which will allow you to hide columns and rows with a button associated with that row or column. I need to adapt this spreadsheet for another purpose but dont know how to recreate this feature. I have attached a screan capture to assist with my description
View Replies!
View Related
Nested IF Function For Months Exceeds 7 Levels
I had more than 7 nested if statements so I attempted to formulate the named ranged formula. My 2 ranges are as follows: LDD1=IF(MONTH(P1)=MONTH(F2),C5-F5,IF(MONTH(P1)=MONTH(G2),C5-G5,IF(MONTH(P1)=MONTH(H2),C5-H5,IF(MONTH(P1)=MONTH(I2),C5-I5,IF(MONTH(P1)=MONTH(J2),C5-J5,IF(MONTH(P1)-MONTH(K2),C5-K5,IF(MONTH(P1)=MONTH(L2),C5-L5))))))) LDD2=IF(MONTH(P1)=MONTH(L2),C5-L5,IF(MONTH(P1)=MONTH(M2),C5-M5,IF(MONTH(P1)=MONTH(N2),C5-N5,IF(MONTH(P1)=MONTH(O2),C5-O5,IF(MONTH(P1)=MONTH(P2),C5-P5,IF(MONTH(P1)-MONTH(Q2),C5-Q5)))))) Basically what it's doing is comparing the current month with the month in the column heading and calculating appropriately. However, when i input the if statement (=if(LDD1,LDD1,LDD2), i get an error saying that it's an inconsistent formula and the result that it gives is wrong, too. Problem cell is e5
View Replies!
View Related
Calculate Amount Of Days Paid In Advance And Apply Percent Discount
Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message. give point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount? attached is the start of the assesment question. You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid. Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received: • If students pay the course fee less than 7 days prior to the course commencing then they receive no discount. • If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%. • If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%. • If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.
View Replies!
View Related
Subtotal Two Levels Based On Color Change Or Indent
I need advice regarding the best way to subtotal data that has been exported from SQL Reporting Services to Excel. Formulas are not exported with the worksheet and need to be re-entered. The data is contained in three levels, but second level is not always present (see attached). The Level 1 data has a "pale blue" background and desciptions start in column A. Level 2 data has a "Gray-25%" background and starts in Column B. Detail level data has no fill color and descriptions for it start in Column C. The detailed data should be subtotaled in the Level 2 line directly above it (if available). The Level 2 data should be subtotaled in the Level 1 row directly above it. If no Level 2 row exists beneath a Level 1 row then all of the detail rows below should be subtotaled in the Level 1 row. I have looked at options for keying on the color or the column contents for triggering when to calculate the subtotals, but nothing that I have tried works. The attached sample file illustrates how the data looks after being exported from Excel. The number of detail rows may change at any time as new projects are added.
View Replies!
View Related
Index Match: Summary Page That Shows Product Levels For Each Org.
I am creating a summary page that shows product levels for each org. The summary page looks something like this. ORG 863869880 Warehouse SubWHS1WHSWHS Part NumberQTYQTYQTY 122796 143091 147388 118494 And the data source looks like this ORGPartSubQty 863122796WHS1420 863143091WHS115 863147388WHS185 863118494WHS160 863122796VAN033 863118494VAN021 869122796WHS180.......................... I've been trying to return the qty based on the ORG and SUB using an INDEX MATCH function but it keeps giving me a #NA error. Here's the logic behind what I'm trying to do. Return Value (QTY)of part # X if ORG = B and SUB = C (in this case WHS). Here's my Formula =INDEX(Data!$D$2:$D$43,MATCH(Summary!B$1,IF(AND(Data!$B$2:$B$43=Summary!$A4,Data!$C$2:$C$43="WHS1"), Data!$A$2:$A$43),0)) This is an array formula so I have confirmed with CTRL+SHIFT+ENTER to designate as such.
View Replies!
View Related
Named Ranges Based Upon Indent Levels & Entries In Column
I had an idea that I could use the level of indent in the first column to provide the name for the range. The easiest way to explain is with the example spreadsheet I have attached Cells C5:C10 show how the naming convention should look like, basically Indent Level 0 returns a prefix (Sheet_Name_Prefix) and its corresponding row entry in Column A. Level 1 should return the last Level 0 name and its corresponding row entry in Column A. I had a go at the code and it works for Level 0 but I can't get it to put to Level 1. Sub Test() 'Dimension Variables Dim RowTitleEntries As Integer Dim NameLoop As Integer Dim IndentLevel As Integer 'Set the value of RowTitleEntries RowTitleEntries = 6
View Replies!
View Related
Discount Prices Based On Order Quantity And Package Quantity
I have two idential spreadsheets with several rows of items each with different packaging quantities, price break quantities and corrisponding prices next to each break quantity. I'm trying to build a discounting sheet on an idential page by using formulas that read off the price sell in the same relative position on sheet 2. Below is one row of sheet1 and the idential row of sheet2 - underneath the cells are the rules I would like incorporate: Sheet 1 ABCDEFG 1Pack QtyQty 1Prc 1Qty 2Prc 2Qty 3Prc 3 210010.91000.744000.6 Sheet 2 ABCDEFG 1Pack QtyQty 1Prc 1Qty 2Prc 2Qty 3Prc 3 210010.91000.744000.6...........................
View Replies!
View Related
Track Changes
So I got this code from http://www.ozgrid.com/VBA/track-changes.htm i followed the directions and pasted it in the workbook module but does not seem to be working. I am thinkning the copy and paste feature is messing something up anyone know what? I have added a worksheet named Log
View Replies!
View Related
Track Changes On Another Worksheet
I have a list of items that I keep track of when they were last used. For example: Item# Last Used Item#1 8/27/06 Item#2 5/2/07 Item#3 6/30/07 What I would like to do is when I enter a date, it automatically tracks the changes so that I can not only see the most current date but all previous dates if I need to. The ideal would be to transfer it to another worksheet so that is looks like the original except that is shows multiple dates after it instead of just the most recent. For example: Item#1 5/3/05 7/23/06 8/27/06
View Replies!
View Related
Track Users
We have an excel file that I've developed that people in our department are supposed to be using - not that they want to - but it is an edict from our bosses. Is there a way to track who is actually using that file so I can verify that they are using it rather than just relying on them saying that they are?
View Replies!
View Related
Track Changes From All Worksheets
I have found another user's code that will track changes for a single sheet, if that code is in the sheet. This code uses the Worksheet_Change function. However, I have just stumbled acroos the Workbook_Change function. The workbook function is exactly what I need, since I have multiple tabs that need to be tracked. However, the code does not seem to work. I can switch between the two functions, using the same code afterwards, but with the new workbooks phrase it does not work. I tried placing the Workbooks_Change in the "ThisWorkbook" object in VBA, but it does not seem to work there or anywhere else. I have attached the file. The code is in the "thisworkbook" function. For quick reference: Private Sub Workbook_Change(ByVal Target As Range) Dim r As Long, OutSht As Worksheet Set OutSht = Sheets("Log") r = OutSht.Cells(Rows.Count, 1).End(xlUp).Row + 1 OutSht.Cells(r, 1) = Target.Address OutSht.Cells(r, 2) = Now OutSht.Cells(r, 3) = Environ("UserName") OutSht.Cells(r, 4) = Target.Value OutSht.Columns("A:D").Columns.AutoFit End Sub
View Replies!
View Related
Keeping Track Of Payments
i am a builder and i want to make a spread sheet to keep track of what i have been paid and the labour costs i have paid out so i am working on 20 houses that all have 7 stages of payment each, and 5 to 8 men working on them who receive a price for each stage, but are paid a portion of that price each week while they are working on that stage what i am trying to do is set up a sheet to keep track of what has been paid and the balance remaining for each stage and what has been received i have tried doing it a few different ways but im none to clever with spread sheets and what is causing me the problem is next to each payment made i need to put the date and the name of the person who was paid so it always seems to just look a cluttered mess have any of you got any ideas of how i could simplify this and make it look neat and easy or alternatively is there some other software that may suit this application better?
View Replies!
View Related
Track The Time From 1-NY To 10-Lukket
So if we take first line the defect id is 10. The date entered is 21-08-2007 and the status is 1-NY ( means new) NExt line the defect ID is still 10 the date is changed to 22-08-2007 and the previous status is was 1-Ny and the new status is 03- under vurdering (to be evalueted) Third line the defect ID is still 10. The date is changed to 04-01-2008. The previous status was 03- Under vurdering ( to be evalueted). The new status is 10-lukket. I want to be able to track the time from 1-NY to 10-Lukket. Now the even more tricky part. As you can see other defects go over different statuses e.g defect number 1000 here. The sheet I have is 13000 rows and I have a total of 2300 defects 1021-08-2007 10:491-Ny 1022-08-2007 15:381-Ny03- Under vurdering 1004-01-2008 13:4703- Under vurdering10-Lukket 10029-08-2007 10:051-Ny 10003-09-2007 14:121-Ny04- Afventer tilretning 10012-09-2007 15:2204- Afventer tilretning10-Lukket 100006-02-2008 11:2901-Ny 100012-02-2008 15:0501-Ny04- Afventer tilretning 100015-08-2008 08:5304- Afventer tilretning10-Lukket 100015-08-2008 22:1310-Lukket04- Afventer tilretning 100004-02-2009 14:0404- Afventer tilretning10-Lukket
View Replies!
View Related
CountIf - Track Last Item
How to track the value of last item in CountIf and work backwards? I am trying to do inventory valuation at the end of the month. For example I have 7 purchases in a month for 1000 units in each purchase order, my on hand inventory is 1500 units. from the purchase details I did a countif to tell me there are 7 PO's in a month for the item, but if i want to find how much each units costed starting from last PO in the CountIf is there a way to pull that number? I have total purchase amount by PO & quantity by PO also in separate columns, so I know cost per unit in each PO but can't figure out how to go backwards (starting from last in)
View Replies!
View Related
Track Comments On The Spreedsheet
I have created a spreadsheet for my students on a shared drive. They will be able to go there and make comments..My question is this: I know they can have their name set in Excel...How long will the name stay in it. I have to change the speedsheet daily. Does that mean the students will have to enter their name daily. Also how can I track each student comments on the spreedsheet?
View Replies!
View Related
Track Changes Based On Login Name
I've been looking around for a way for Track Changes to reference the loggedin username of the workstation rather than the name in Excel registration. I found this Function UserNameWindows() As String UserNameWindows = Environ("USERNAME") End Function : on this board and another blog. But I don't know how to enter it to make this work. I had read you make it a new module and assign a formula, but the most I could get through was opening the VBA editor for the workbook, creating a new module, and pasting the code. Changes would still reference the Excel registration name, not the Windows' logged in username.
View Replies!
View Related
Worksheet To Track Inventory
I'm trying to make a worksheet to track inventory, not for sales but for tracking how many supplies are on hand in storage rooms, closets, etc. The worksheet will be used by as many as 20 different users probably on a network. Because it will be used by many people, I'm trying to see if there is a way that the worksheet can be updated after every save. In particular, the amount that are "on hand". For example, say there are 10 of a particular item on hand to start. Joe takes 2 and goes to record it on the worksheet. He inputs the 2 he takes, which now show that there are 8 on hand remaining. He saves the worksheet. Then, Jerry comes and takes 2 and goes to record it on the worksheet. I can't figure out how, or if it's possible, to have the worksheet show Jerry that there are 8 on hand to start, not 10. So that when he takes his 2, it should show that there are now 6 on hand remaining. I've attached an example worksheet.
View Replies!
View Related
Program To Keep Track Of The Hours
i m trying to use Excel program to keep track of the hours he is working. I know there is a way to do it but it has been many years since I used Excel and can not remember how to do it. He would like to insert the time (hours & minutes) he works in column A and have a sum in the next column.
View Replies!
View Related
Track Changes. Project Unviewable
I believe that someone is using excel's coding features to sabotage a file by entering blank and/or false data into a speadsheet using macros / vb code, and the project is locked for viewing so I cannot view the code. Is it possible to track the changes of vb code by using the 'track changes' feature in Excel? I have pictures of the history sheet and a copy of the file if any of the experts here want to take a look at it.
View Replies!
View Related
Track Changes Detail In A Cell
Is there any way to capture the comment that comes when we use "Track Changes", the date & time when the cell content changes should be retrieved in the adjacent automatically. Is there any way to do it using formulas/ VB code.
View Replies!
View Related
Track Changes In Workbook By User Name
I am unable to add which user made the change to the specific cell. The code used is: Dim vOldVal 'Must be at top of module Private Sub Worksheet_Change(ByVal Target As Range) Dim bBold As Boolean If Target.Cells.Count > 1 Then Exit Sub On Error Resume Next With Application . ScreenUpdating = False .EnableEvents = False End With If IsEmpty(vOldVal) Then vOldVal = "Empty Cell" bBold = Target.HasFormula With Sheet1 . Unprotect Password:="Secret" If .Range("A1") = vbNullString Then .Range("A1:E1") = Array("CELL CHANGED", "OLD VALUE", _ "NEW VALUE", "TIME OF CHANGE", " DATE OF CHANGE") End If..................................................
View Replies!
View Related
Race Track Chart
I am running a contest for my office and the theme is 'nascar'. Anyway - we'd like to chart the contestants using a racetrack. Is this possible in Excel or any other MS Office tool? Basically I'd like to show the placement of ten contestants on a circular racetrack. It would be updated weekly.
View Replies!
View Related
Track/Report User Changes
The module that you wrote on tracking changes made in a workbook was fabulous I had been looking for so long for that. I was just wondering if there was a way to find out WHO made the changes to the workbook. I am on a network and everyone in my office can make changes to this particular workbook, therefore there are some mistakes. I would like to know who is making the mistakes. Dim vOldVal 'Must be at top of module Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim bBold As Boolean If Target.Cells.Count > 1 Then Exit Sub On Error Resume Next With Application . ScreenUpdating = False .EnableEvents = False End With If IsEmpty(vOldVal) Then vOldVal = "Empty Cell" bBold = Target.HasFormula With Sheet1.............................
View Replies!
View Related
Track Changes Then Delete Unchanged Rows
I have a spreadsheet which is sent to one of my suppliers..they fill in there product information then send it back. When they need to add new products or make changes to existing ones they simply use the same file and re-send it. So I end up with two files, old and new. I need to flag up which cells have been changed in the new file compared with the old one. At the moment I am copy and pasting the data from the new file into another spreadsheet which has =IF(B10='\HalusersSimon[Copy of Copy of Copy of Book1.xls]enter data'!$K$6,"","Change") in a empty column next to each column from the new file. This displays 'Change' in the cell next to the one I have pasted if it is different from the original file. Unfortunately I am still left with all of the rows where none of the data has changed, so I still have to sort through maybe 10000 rows....BORINGGGGG. First of all the formula isnt perfect for the job...is there a macro which can do this instead...and secondly is there a macro to delete all rows within a certain area (so that I can keep the field headings and stuff) which dont contain the word 'Change' in them
View Replies!
View Related
Track Number Between Two Tabs On Same Workbook
I'm trying to see if the same numbers exists in two different spreasheets on the same workbook. Both "asset tags" columns are sorted ascending. If the number appears on both table I would like my formula to add a "Y" (for yes) on the proper cell. Not sure if I should use Vlookup, sumproduct or sumif formula. Here is the main table where I want that "Y" to appear in Column D .....
View Replies!
View Related
|
TRACKER
