Đã Đóng

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.

Kĩ năng: Excel, Xử lí dữ liệu, Visual Basic, Nhập liệu, Kiến trúc phần mềm

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Garden Grove, United States

ID dự án: #27826056

7 freelancer chào giá trung bình$70 cho công việc này


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 Thêm

$100 USD trong 2 ngày
(455 Nhận xét)
(305 Nhận xét)
(178 Nhận xét)

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

$50 USD trong 3 ngày
(73 Nhận xét)

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 Thêm

$100 USD trong 2 ngày
(9 Nhận xét)
(10 Nhận xét)

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 Thêm

$25 USD trong 1 ngày
(6 Nhận xét)