Hi!
I have SHEET1 like this:
And SHEET2 like this:
So basically what I want to do is to automatically post SHEET2 entries to SHEET1.
The amounts on "SHEET2 column D & E" will link to "SHEET 1 Column D & E".
If you notice, "Petty Cash" have 2 adjusting entries, so I need to insert a new row to accommodate the next adjusting entry, then I need to "BOX" the 2 adjusting entries like below:
Then on "SHEET1 Column H" will link the "No." from "SHEET2 Column A)
Which SHEET1 will eventually look like this:
Due to my limited Macro knowledge, I don't know how to start.
I hope someone can help me or give some suggestions.
Thanks a lot!
I have SHEET1 like this:

And SHEET2 like this:

So basically what I want to do is to automatically post SHEET2 entries to SHEET1.
The amounts on "SHEET2 column D & E" will link to "SHEET 1 Column D & E".
If you notice, "Petty Cash" have 2 adjusting entries, so I need to insert a new row to accommodate the next adjusting entry, then I need to "BOX" the 2 adjusting entries like below:
Then on "SHEET1 Column H" will link the "No." from "SHEET2 Column A)
Which SHEET1 will eventually look like this:

Due to my limited Macro knowledge, I don't know how to start.
I hope someone can help me or give some suggestions.
Thanks a lot!