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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top