VBA for automated copying of a specific table column to another sheet

[rockriscia]

Hi everyone!

I need your help. Please teach me how to use VBA for my worksheet.
I have a table named as "Database" in Sheet1. And I want to automatically copy the specific columns to Sheet2 using VBA.
I want to copy the data automatically every time I add rows in Database table.

Please see attached worksheet.

Hoping to hear from the Excel gurus. Thank you in advance!

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter the data starting in column A and press the RETURN key or TAB key after each entry.

Please Login or Register  to view this content.