Hello,

I am trying to get a table in excel to update when data is inputted on another sheet in the same document.

Capture.PNG

When I add data into the column T (Seen above) I want a macro to take the data from T30 and do the following:

c2.PNG

c3.PNG

Create a header for the column as seen above and then input the data from T30 into U20. Each row in U comes from a different sheet on the document.

Is this possible or does it have to be done through manual data entry and cell formatting?

Thanks in advance,

Tom