Excel VBA Macros

[Niclasfa]

Hey guys. I am having trouble understanding requirements.



I would appreciate any and all productive guidance feedback, thank you in advance.

So basically these are the excel VBA Macro requirements.

1. Macro mcrImport

to import eight state/territory workbooks each into their own separate sheets in template National. Your macro should accomplish the eight imports using looping. The macro will be attached to the button with caption Import on the Summary sheet.


2. Macro mcrCombine

to combine the eight new sheets into one new sheet called Combined. The data should begin from row 2 in sheet Combined to leave room for column headings. After combining the separate eight sheets, the macro should delete the eight separate state/territory sheets. The macro will be attached to the button with caption Combine on the Summary sheet.


3. Macro mcrValidate

to perform validate and summarise tasks according to the details below. The macro will be attached to the button with caption Validate on the Summary sheet