Excel Macro for Pasting a Table

[raybeiler1]

Hi,

Sheet Name: Assemblies
Table Name: AddNewAssembly
I have a table where I am entering data, and want to create a macro for the following:

1. Copy Table "AddNewAssembly"
2. Paste Table 2 rows below last filled cell in column "C" (Pasted content should be in Table form, complete with all formulas, data validation, and data)
3. Rename pasted table to B6 content (With no spaces)
4. Hide all empty rows in pasted table
5. Clear all values from following cells in Table AddNewAssembly: B6:F6 H6:M6 F8:H25 J8:J25

[AliGW]

Closed at OP's request. Thread to be opened instead in Commercial Services.