recording changes

  1. M

    Recording one cell entry

    ;) Hi dear I would appreciate if you could help me with this: I have a lab that requires me to record data (X) in the cell A1. using a formula i will use (X) to get (Y) in the cell B1. when I change the value of (X) in A1. i want the new value of (Y) to be recorded in B2, B3, B4..... for...
  2. C

    MACRO for recording changes Does not work properly

    Hi, i hope that you guys can help... I have macro that records changes made to a worksheet called: "Product BOM - 070". Changes however are recorded to following worksheet: " Here is the code I hv: Dim old_value As String Private Sub Worksheet_Change(ByVal Target As Range)...
  3. S

    Macro to copy/paste in new location from a filtered list?

    Morning all, Can anyone help me with this one: I need a macro to look at a list (which has been previosly filtered by the same macro) and copy certain columns in that list to be pasted into another workbook. The problem is, the length of the list will change frequently depending on the...
  4. T

    Iteration results recording

    Hello, I am using Excel Pro 2003 version. I have an iteration sheet. I have 2 (two) variables which are Angle and Area. First I set the angle constant and have the iteration solved the area. Then I increase the angle and iteration solves the area for the new input angle. While I am doing the...
  5. A

    Tracking Change on the Formula Bar

    Hey Guys I was having some troubles with my excel coding. Let me brief you on my excel workbook first 1. I have a cell in which a value is inputted by the user, cell A5 2. Cell A6 has the formula "=200+300" The problem 1. If i enter a number in cell A5, this number should be put directly...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top