Hi,

On a regular basis I am creating a PO in an excel based template. I want to track this created PO's onto the next sheet.
The data's that I wanted to copy from the template sheet to the tracking sheet resides in specific cells (as this specific cells gets change every time I create a new PO).
What I am doing right now is time consuming, as I copy and paste and switch between sheets every now and then. I know this can be done programatically but I just do not know how. I hope this forum can help me.

The cells where are the data resides are as follows:

In PO Template
Cell Description
C3 = Country
C4 = Client Name
C5 = Date Order Received
C6 = PO Validity
C7 = PO Number
C12 = Product Description

At the Tracking Sheet

Cell Description
B2 = PO Template C3 cell content
C2 = PO Template C4 cell content
D2 = PO Template C5 cell content
E2 = PO Template C6 cell content
F2 = PO Template C7 cell content
G2 = PO Template C12 cell content
H2 = Date Created/Submitted for Approval ( normally Todays Date)
I2 = Status ( Pending for Approval )

Now, I want the tracking file to update simultaneously by row. Meaning, if I create a new PO, the new PO information will be added to the next empty row. Say in row2 PO 12345 information is already there, when I create a new PO, the next PO information should be at Row3 and so forth for the next PO's.

I will say thank you now in advance as I am certain that this is just simple to a lot of you here....