I am looking to make a basic IF statement to copy the data in one row to another row to make and save a log of the data transferred. all based on when the data counts up in another cell.
row a3 is the row with the data in it. cell A2 is the cell with the number counting up in it. so when cell a2 changes from 2 to 3 I want to copy row A3 and save it to another row and be able to add rows to make a sort of log file of data.
thanks.
excel data.jpg
Last edited by minepanther; 06-13-2014 at 02:01 AM. Reason: addition of info
Hi there,
example workbook with desired result will be helpful...
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
added screenshot
But unfortunately it won't help us to workout a formula since we cannot work with pictureOriginally Posted by minepanther
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for youAlso, not all members can upload picture files (Company firewalls and stuff)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
all of the data in the worksheet is generated on a different server and the worksheet is just linked to display the data the server is generating. as the data in "A2" counts up ( the counter is also on the external server) with each change in count I need the Row "3" saved the worksheet itself I am unable to upload from here.
This is what I have so far. But it copies the cell formulas to the second sheet not the data displayed by the formulas.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Sheets(1).Range("A3:I3").Copy Sheets(2).Range("B" & Sheets(2).Rows.Count).End(xlUp).Offset(1, 0) End If End Sub
Hi there,
If You want to copy only values, then use it in this way:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Sheets(1).Range("A3:I3").CopySheets(2).Range("B" & Sheets(2).Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValuesEnd If End Sub
I made a mod to the code but it worked as I needed Thanks.Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Sheets(1).Range("A3:E3").Copy Sheets(2).Range("B" & Sheets(2).Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues ElseIf Target.Address = "$G$2" Then Sheets(1).Range("G3:K3").Copy Sheets(2).Range("B" & Sheets(2).Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues End If End Sub
You are welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks