history

  1. S

    Can a 3rd party view previous changes / revisions in a workbook i have sent them ?

    Ive got an excel workbook im editting (updating data, formulas, delete sheets etc) prior to being sent on to a 3rd party. I worried about them being able to see the edits that ive made, is that possible ? Ive got track changes turned off. Would it still be possible for them to see the revision...
  2. R

    Excel macro : to comment history with date stamp

    Thanks in advance for your help. I am looking for a macro/function that does below: Column 1 : Has comments that I add in each day Column 2 : Maintain the history of all comments form the past When I add a comment in Column 1 , And when I press a button or automatically when I go away from...
  3. K

    Index Match Query

    Hi Folks, Can you please help me with the below query: Master Data: <colgroup><col><col span="2"></colgroup><tbody> Username Subject Score A1 English 50 A1 Maths 45 A1 Physics 34 A1 History 23 A1 Geography 56 A2 English 24 A2 Maths 67 A2 Physics 45 A2 History 32 A3...
  4. D

    Track Changes History Sheet

    Quick Question, In excel 2016, I want to track all my changes but when i make a change on the workbook, i want to record the reason for the change on the history sheet. I wanted to do this by adding another column in the history sheet tab but the sheet is protected. Is there any possible way...
  5. A

    Creating a master inventory sheet and automatic history

    I'm not sure which section to post this in, any advice on a more appropriate forum is appreciated. I am trying to create a master inventory worksheet for a small business - one that can auto populate the data into a separate worksheet to analyze sales history and then re-clear the master...
  6. K

    Bringing back column headings for descending values

    Hi, i hope someone can help me as this is driving me potty. I have student grades listed like below <!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody> Biology Chemistry History Physics Student 1 6 7 7 2 Student 2 3...
  7. W

    Creating a running history of application versions

    Hi all! I have a spreadsheet that I use to track versions of multiple applications for multiple clients. I was hoping to be able to keep a history of the previous version number in a different worksheet(i.e. app1 version history, app2 version history, etc.) upon change to the current version...
  8. J

    Having a history on a list

    Hi, I was working on a spreadsheet for work. I wanted to make a dropdown list where I am able to type text in the dropdown box. I then need to update the dropdown every week. I also need the previous entries to appear when I click on the arrow. For example: Week 1: Drop dow list has 1 entered...
  9. S

    Access Select Query not working with a form field selection.

    G]C:\Users\ShelH\Desktop\Access1[/IMG] here is the query code here is the whole SQL query coding SELECT [Trans Rvsd6292017].emplid, [Trans Rvsd6292017].gender, [Trans Rvsd6292017].dob, [Trans Rvsd6292017].name, [Trans Rvsd6292017].stint, [Trans Rvsd6292017].effdt, [Trans...
  10. Z

    How to keep a history of changing values in a cell?

    I hope I can explain this clearly in words as it is in my mind!:) Lets say I have C2, D2 and E2 as my cells for vendor costs, IT costs, Employee costs (or whatever, the actual table has a lot more components) B2 is just summing these up. So B2= sum(C2:E2) in this case. The thing is as I get...
  11. B

    Is it possible to save the history of a progress chart that shows the current state of a project, but it gets updated over time?

    I have a PivotChart that shows the target date of certain action items as well as the % completion of those action items. I've also included a progress bar showing the current date, and all of this information gets updated with a refresh click. What I want to be able to do is cycle through the...
  12. F

    How to Recall Stored Data back into a Userform based on a Reference Number

    I am trying to create a way to recall the data that has been input into my excel by my userform. I have looked EVERYWHERE and nothing works i need help. vLookup doesnt seem to work for me or im not using it right. Essentially i have 2 Userforms Userform1 = Input Form Userform2 = Recall Form I...
  13. N

    Importing Excel Spreadsheet (same data) from different days

    Hello - i am new to access and i need some help. I am working with a custom UI tool that creates an Excel extract upon request. I run this excel report daily to perform calculations on changes. I have past excel snapshots on my PC. I want to use Access to store the daily data, that way i can...
  14. P

    Copy from multiple files in a folder to multiple files in a different folder with corresponding name.

    Hi there and thanks in advance for any help and tips. So I am new to VBA and have just started playing around with it about two weeks ago. I have been searching and haven't been able to find a solution for the problem I am hoping to solve. I have two folders. The name of the first folder is...
  15. MrExcel

    15th Anniversary of MrExcel.com - Free Excel Tip Cards for All

    Thanks for being part of the MrExcel community. The site was launched on the Saturday before US Thanksgiving in 1998 - 15 years ago. Since then, MrExcel.com has published 42 books, 1800 videos, 700K message board threads and more. To thank the message board community for generating 700K+...
  16. J

    Using Excel as Work-History / Tracking tool

    Good afternoon, I'm working on a project now that involves setting up a service desk that will be responsible for tracking and guiding individuals through a certain process. It is going to be a specialized desk that only deals with a few dozen items a year, so it doesn't make sense to use a...
  17. L

    Complex Web Query Help

    Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a...
  18. L

    Remove validation w/o losing change history

    Hi everyone I need to remove a a faulty drop down validation from a Excel 2003 sheet which has track changes activated (i.e. is shared). The usual way, turning off the shared workbook settings, doesn't work, because I need to keep my change history. Is there another way I can do this, maybe...
  19. A

    Web Browser Style Back Button

    I'm not really sure where to post this because it's more of a powerpoint question than excel... but hopefully someone can help! I have this code for a web browser style back button in excel: Option Explicit Dim History As New Collection Private Sub Workbook_SheetActivate(ByVal Sh As Object)...
  20. N

    updating date every time particular cells' contents are changed

    Hi, I am working on a spreadsheet where I wish to have a column B where each cell shows the date on which the cell in the corresponding row of column A is manually updated by me. In other words, <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="484"...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top