Automatically copy values to a second sheet from "master sheet" when added to the master

Hi, My name is Bill, and I am new to the forum and VBA. I would like to create a macro that will allow "Part Numbers" to be automatically added to a secondary sheet in Column A, when they are manually added to a master sheet in Column A. If Part Numbers in Col A of Sheet 1, Starting in cell A3 downward are added by me or someone else, I would like them to automatically appear in Col A of Sheet 2 starting in A5 and descending downward. Is this possible? If this can be done without writing a macro, that also works. I appreciate any help you can provide me with. Thanks.

Morning Bill. Welcome to the Forum. Will there be data in Sheet2 A5? If so then this sheet event code may help.

Please Login or Register  to view this content.

Thanks for the quick reply. Column A will be empty until populated with the values from sheet1

Then try this instead:

Please Login or Register  to view this content.