recording changes

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

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

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

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

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