Scenario Your manager likes the table you created with clients ABC, 123, and XYZ

Scenario
Your manager likes the table you created with clients ABC, 123, and XYZ. They would like to have the table on an entirely new workbook and find a way to look up what each of their expenses are as well as other pieces of information.
Complete the two requests outlined below. Your manager shared an existing project similar to the one you will be working on and acquired the code to help expedite this project (Basic VBA.xlsm).
Before you begin:
Make sure you have the appropriate references checked! See instructions below:
Right-Click any of the tab names in the Ribbon at the top of the Excel Window  Click Customize the Ribbon to open Excel Options window
Go to Customized Ribbon section  Under “Main Tabs”  Make sure “Developer” box is checked, if not check the box  Click OK
Click the Developer Tab in the Ribbon  Click “Visual Basic” under ‘Code’ section to open VBA application
Click Tools in the Toolbar in VBA application  Click References
Find and make sure the following are checked:
Visual Basic For Applications
Microsoft Excel 15.0 Object Library
OLE Automation
Microsoft Office 15.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Scripting Runtime
Microsoft Windows Common Controls-2 6.0 (SP6)
Click OK
Request #1 – Make a subroutine using only code (in a module within the Excel Assessment file) that can:
Create a folder on your desktop called “[Your Last Name]_[Your First Name] Excel Assessment VBA”
Make an entirely new subroutine that can:
Make a new workbook
Copy the table contained in the ‘2. Formatting’ tab in the Excel file
Paste the table into a new workbook
Rename the worksheet tab in the new workbook to ‘Table Data’
Save the new workbook to the folder created on the desktop using the following name: “_  Excel Assessment VBA”
Save the workbook as a macro-enabled worksheet
Make the folder path universal so other people can create this folder too
Within the file title, add today’s date using the date format function, using the following format: dd-mmm-yyyy
After making these subroutines:
Create a button from the Developer tab so your manager can simply run your macro
Assign the button to the first subroutine you made
Repeat 1 and 2 for the second subroutine
Request #2 (Intensity Level 6) Make a new subroutine that gives the user information on some values from certain cells in a row using a message box and input box.
The input box will be used to look up the engagement name (by keyword) (e.g., “Americas” will yield “Americas LEP Remote Booking”)
The message box will give the following:
Client Name
Engagement Name
Engagement Partner
Total Expense
Charged Hours
TER
NER
SER
Create a button the same way you made the last one (manually), and assign it to the subroutine that produces the message box.

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount