recognize input in one sheet, auto input in other sheet

[osse697]

Hi everyone,

First of all - thanks for lending your expertise! I need some help --

So I'm building worksheets to help me keep track of my finances. I currently have two sheets, one is "Summary of Accounts", and the other is "Cash Flows". the summary of accounts just summarizes all my bank accounts' activities, while the cash flow does my best to account for how i spend cash.

here is the challenge (for me at least): if i enter in "ATM" as a withdrawal under one of my bankaccounts on sheet:summary of accounts, i want it to automatically appear as an "income" on my sheet:cashflows. i want something that almost always 'keeps guard', and that when enter it in on one sheet, it automatically recognizes that and puts it in my other sheet (although with some variation - the value in hte withdrawal column should now go inot the income column).

any advice? thanks again

 

[erik.van.geit]

Hi, osse697
Welcome to the Board !!!!!

it is unclear to me what you want to do exactly
but I feel this example might help you
TO INSTALL IN SHEET CODE WINDOW:
1. right click the "Name Tab" of sheet you want code to work in
2. Select "View Code" in drop down menu
3. VBE window will open ... paste code in and exit VBE

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "You entered " & Target & " in cell " & Target.Address, 64, "TITLE"
    If Target = "ATM" Then
    MsgBox "OK, you want to write something to sheet Cash Flows"
    Else
    MsgBox "Nothing will happen yet"
    End If
End Sub

kind regards,
Erik