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
Bookmarks