PDA

View Full Version : Linking multiple sheet columns into one master sheet column



RubaDude
05-22-2019, 07:55 AM
I have Excel experience but am a complete newbie to VBA and not sure if VBA is even relevant but:
Is it possible to link a dynamic column from different sheets in a workbook into one master sheet column in the same workbook? For example (please see attachment): I want Column A (Name) in Sheet"New" and Column A (Name) in Sheet"Old" to populate Column A (Name) in the Master Sheet, and when I enter data into either Column A in "New" or "Old", it automatically updates the Master Sheet by adding the new data to the end of the list. Thanks for any help or advice.

大灰狼1976
05-22-2019, 08:43 PM
Hi RubaDude!
Please refer to the attachment.