Say I have the number "2" in cell A1 of sheet "Assets". Can someone please provide a simple vba command for:

1. Entering the contents of cell A1 into cell A5 of "Assets"

2. Entering the contents of cell A1 of "Assets" into cell A5 of sheet "Liabilities".

In the old (pre-Vba Excel) macro language which I am familiar with the command "Formula" was used, however, it does not appear to available in VBA.

I greatly appreciate all help.