Writing any fancy code to find the appropriate cell location

Reference no: EM133610007

Question 1: This macro can be completely recorded. You need to copy the necessary material from the PO to the register. You will also need to copy the formulas in the register for each new purchase order that you post. There is a nice trick you can use to fill in the register without writing any fancy code to find the appropriate cell location. By inserting a blank row into the register before pasting a new row, you can enter new data without deleting the existing data.

Question 2: To complete the macro section, you will need to create buttons as you did in the second "2)" requirement of Part C. Then assign macros to the buttons. I put a Post to register button on the PO form.

Reference no: EM133610007

Questions Cloud

Explain why people are likely to believe that flying : explain why people are likely to believe that flying in a plane is more dangerous than driving in a car. Similarly, why do you think people are likely to list

Determination to justify both his concern : Determination to justify both his concern about the existing formulas and the basis for switching two of the formulas to use different explanatory variables

How do the ell special populations of refugee and migrant : How do the ELL special populations of refugee, migrant, immigrant, and Native American, relate to LTEL, RAEL, and SIFE?

Explain how you develop the concept of bird : What is a mental concept? Explain the difference between logical and natural concepts. Provide two original examples of each. How would the exemplar theory

Writing any fancy code to find the appropriate cell location : Writing any fancy code to find the appropriate cell location. By inserting a blank row into the register before pasting a new row, you can enter new data

Explain gap in market that new hospital attempts to solve : Explain the gap in the market that the new hospital attempts to solve. Include an industry / competitor overview.

What tensions notice between women of different and classes : The New York Times' article, 141 Men and Girls Die in Waist Factory Fire (121-123), what tensions did you notice between women of different races and classes?

Does the artifact accurately represent the concepts : Does the artifact accurately represent the concepts or theories we are learning? Yes, the artifact accurately represents the concepts we are learning.

What is the direct materials cost variance for canary inc : which it incurred $4,000 for direct material, $1,100 for direct labor, and $3,500 for factory overhead. What is the direct materials cost variance for Canary

User Account

All Pages