Closed

Macro, data validation

1) Create defined names for every column on the DAA3 Data worksheet.

2) Use Data Validation to restrict values for the entire Date column (excluding the header row) on the DAA3 Data worksheet to have to be less than or equal to today's date (so that dates which have not occurred yet cannot be entered).

3) Analyzing data from the DAA3 Data worksheet, use reference/lookup formulas to find the following information about the sale where SalesRep5 sold to Cust10 in Region4:

3a) How much was the sale in sales $?

3b) On what date this transaction occur?

3c) Which product was sold?

4) Create two MACROs, one each that captures all of the steps required to answer the questions 4a) and 4b) respectively. Please name your MACROs some variant of "Question 4a" and "Question 4b" so that I know which MACRO replicates the answer to which part of the question.

4a) Create a new column called Gross Profit into the DAA3 Data worksheet. In that column, calculate Gross Profit for each row as Sales - COGS for that row.

4b) Use SUMIFS to populate the B2:E6 array in the cross-sectional table on the DAA3 Table worksheet with total sales by region and product, analzying the data from the DAA3 Data worksheet.

Skills: Excel, Data Processing, Visual Basic, Data Entry, Software Architecture

See more: excel vba validation formula1, excel vba data validation list named range, vba drop down list from range, excel vba data validation list values, excel vba dynamic data validation list, excel vba data validation alertstyle, excel macro to validate cell value, data validation in excel, excel macro data cell, excel macro data online, excel macro data base entry, macro data internet, excel simple macro data comparing copy, excel macro data manipulation, macro data spreadsheet, internet macro data extraction, excel macro data consolidation, excel 2007 macro data input, excel macro data update, paste data cell content excel macro

About the Employer:
( 0 reviews ) Garden Grove, United States

Project ID: #27826056

7 freelancers are bidding on average $70 for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: Macro, data validation ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you ar More

$100 USD in 2 days
(455 Reviews)
8.3
(305 Reviews)
7.8
(178 Reviews)
6.6
Orientwork

hello sir... how are you??? i can start this job as you asked in porject details.. please talk to me... regards

$50 USD in 3 days
(73 Reviews)
5.2
KumailMohammad

Hello. I have skimmed through the file and this is something i can help you with. Let me introduce myself. I am a Chartered Accountant and I have over 5 years of experience using MS Office tools. When it comes to MS E More

$100 USD in 2 days
(9 Reviews)
4.0
(10 Reviews)
3.4
faiiz

Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and dat More

$25 USD in 1 day
(6 Reviews)
3.1