Posts by prragasa

    Hello, it's been awhile.

    I've already made version 7 of the General Ledger file.

    Same as before, the edits in 'Unit Code' to 'Item Code' columns in 'Budget' worksheet should be copied to 'Unit Code' to 'Sub Code' columns in 'Chart of Accounts' worksheet.

    In addition, the edits in 'Period No.' to:

    a) 'Amount Paid' columns in 'Purchases' worksheet

    b) 'Amount' columns in 'Disbursements' worksheet

    c) 'Amount Reimbursed' columns in 'Petty Cash' worksheet

    d) 'Cr. Amount' columns in 'Cashbook' worksheet

    should be copied to 'Period No.' to 'Cr. Amount' columns in 'General Journal' worksheet.

    I've tried using the code as above and twerk it, but I can't seem to figure how to make it work.

    I created a Splash Screen based on this website:…een-for-your-spreadsheet/

    I coded it using a Windows laptop, since Userforms are not found in Excel for Mac 2019. It works fine there, but when I open it on my MacBook, I get an error about 64-bit etc. It points to this specific code I got from the website above:

    Is there any way to resolve this?

    Regarding one Command Button to trigger Edit and Save :

    How would you plan to correctly indicate which row from the Source sheet needs to be updating which row from the Destination sheet ?

    I guess that would be a problem, since in the latest version that I edited (see V3 below) I intend to identify each row with Budget Ref. = Account Code. But the Budget Ref. changes right away once I edit it.

    Double click is possible, I guess, but maybe not limit it to Budget Item, I guess? Allow Edit and Save in Unit Code, Category Title and Item Code as well?

    Thanks again!

    However, all 4 columns and not just 'Budget Item' should be updated.

    I'm also thinking whether a command button is more apt to trigger Edit and Save than just double clicking. What do you think?


    What you are requesting is indeed feasible ... as long as there is a Unique Identifier

    Why don't you create an example in your test file before attaching it ...

    Here's the file with sample data entries in both tables.

    I've started adding another worksheets, but they are not yet done.

    Also, I've tried sorting both tables automatically based on the "Budget Ref./Account Code" columns once a new row of data is completely entered.

    This is a sample VBA Code I found on the internet:

    Private Sub Worksheet_Change(ByVal Target As Range)
    On Error Resume Next
    If Not Intersect(Target, Range("J:J")) Is Nothing Then
    Range("J4").Sort Key1:=Range("J5"), _
    Order1:=xlAscending, Header:=xlYes, _
    OrderCustom:=1, MatchCase:=False, _
    End If
    End Sub

    However it doesn't seem to work. :(

    Just a follow up: is it possible to reflect any changes in the 'Budget' table data row reflect in the 'COA' table data row?

    So that when I change, for example, an existing 'Budget Item' data in 'Budget', the change is reflected in the corresponding 'Sub Account' data in 'COA'.

    Like an "Edit and Save" button, maybe?

    I think no. 2 applies in my case. COA is not a replicate of Budget table, since Budget table only creates Expense accounts.

    In COA table, I need to create Asset, Liability, and Equity accounts, in addition to the Expense accounts I will create by copying those data already in the Budget table.

    I'm not really sure how to do the exact copying process

    Hi Carim! I'm creating a Film Accounting file for my production company.

    I want to copy from Budget table to COA table he following:

    Category Title > Account Title

    Budget Code > Budget Code

    Item Code > Sub Code and

    Budget Item > Sub Account


    I have a dynamic table in sheet 1 (Budget) where specific cells must be copied to a new row in another dynamic table in sheet 2 (COA), so that:

    Entry in Category Title in table 1 is copied to Account Title in table 2,

    Budget Code to Budget Code,

    Item Code to Sub Code, and

    Budget Item to Sub Account.

    A command button (Create Expense A/C) should appear in each new row added in table 1 via the existing Add Budget Item command table, which if clicked will trigger adding another row in table 2 and the copying process.

    I'm fairly new to VBA using Excel for Mac 2019 and so I am not sure how to make this happen. I'm attaching the file for reference.

    Hoping someone could help me on this, thanks!