[Solved] Creating A Cheque Entry from Sheet 1 and save the data to Sheet 2

[cedie082915]

Good Day everyone,

I'm a newbie in excel, I'm trying to create a cheque entry and I want to save in the other sheet so i wont forget it the details and transactions I made.

Thanks hoping that you can help me.

 

[shamimarita]

Hello cedie082915,

Welcome to the world of Excel! Creating a system to enter cheque details and save them to another sheet is a great idea to keep track of your transactions. Follow the given steps to do it.
Step 1: Structure Your Sheets
Sheet 1: Use this sheet to input cheque details. For example:

• Column A: Date
• Column B: Cheque Number
• Column C: Payee Name
• Column D: Amount

Sheet2: Use this sheet to store all your saved transactions.

Step 2: Automate with VBA (Optional)
If you’d like this process to happen automatically:

• Open the VBA editor by pressing Alt + F11.
• Insert the following code into the code window for "Sheet1":

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim entryRange As Range
    Set entryRange = Me.Range("A1:D1") ' Adjust this range to match your input area
    If Not Intersect(Target, entryRange) Is Nothing Then
        Dim recordSheet As Worksheet
        Set recordSheet = ThisWorkbook.Sheets("Sheet2")
        Dim nextRow As Long
        nextRow = recordSheet.Cells(recordSheet.Rows.Count, "A").End(xlUp).Row + 1
        recordSheet.Range("A" & nextRow & ":D" & nextRow).Value = entryRange.Value
        entryRange.ClearContents ' Clears the input range for new entries
    End If
End Sub

• Save your work and return to Excel.

Now, every time you enter details in the designated range on "Sheet1" (e.g., A11), they will automatically transfer to "Sheet2" and clear the input cells for new entries.

Step 3: Manual Copy-Paste Method

If you don’t want to use VBA, you can manually copy your data from "Sheet1" and paste it into "Sheet2" when you enter.

 

[cedie082915]

Hi shamimarita,

Thank you very much I will try this one, I'm trying to figure out my problem that would help save my time. thank you very much again.

 

[shamimarita]

You’re most welcome! I’m glad I could help. Let me know how it works out for you, or if you face any challenges while trying it. I’m here to assist if you need further guidance. Good luck with your project, it’s a great step toward making your work more efficient!