the macro must be done through VBA (visual basic aid) on excel. thank you
Create a button by clicking on developer tab and add controls and a button.
In my case I have named it as extract.
Below is the macro code which will get invoked when the button is clicked
Sub Button1_Click()
Dim sourceRow, destRow
destRow = 5
ThisWorkbook.Sheets("Sheet1").Activate
sourceLR = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
For sourceRow = 5 To sourceLR ' Initiate from Row 5 since we have data from Row 5
If (Sheet1.Cells(sourceRow, 1).Value < DateValue("December 31,2015")) Then
Range(Cells(sourceRow, 1), Cells(sourceRow, 2)).Copy Range(Cells(destRow, 7), Cells(destRow, 8))
destRow = destRow + 1
End If
Next sourceRow
End Sub
Screen clipping taken: 26-02-2019 08:24
I have not included answer to the question no. 2 .
the macro must be done through VBA (visual basic aid) on excel. thank you 1 Create...
Create a SQL query based on tblProducts and tblTransactionDetails that will display all the fields from tblProducts and the TransactionID and Quantity fields from tblTransactionDetails. Use a join to include all products, regardless of whether or not they have been purchased. Sort in ascending order by Brand. Save your query as qryTransactionDetails_initialLastn ame. tblTransactionDetails TransactionID ProductID Quantity 1 VZH159 2 2 EPP101 2 3 EOL672 3 4 VZH159 2 5 ZLE580 2 tblTransaction TransactionID CustomerID EmployeeID TransactionDate MethodOfPayment 1 11...
2. In M6 create a calculation in excel to work out how many Clients have Bronze status. Copy the formula down to M9. 3. In N6 create a calculation in excel to work out how many jobs Clients with Bronze status have booked. Copy the formula down to N9. 4. Create a Donut chart to show the percentage of clients of each status. Change the Chart Title to Client Status and add Data Labels to show percentages. Use Chart Element...
please show all the work. if you use excel please show the screenshots. Thank you ! Question 5 (25pts) Suppose the athletic director at a university would like to develop a regression model to predict the point differential for games played by the men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of games,...
java: 1d arrays PLEASE NEED HELp THANK YOU!!! One dimensional (1D) array 1. Create an array of 1000 integers. Name the array: x 2. Assign 95 to the ninth element, 25 to the twentieth element of array x. 3. Assign the sum of the ninth and the twentieth element to the sixtieth element of array x. 4. Display the sixtieth element of the array. 5. Use the for statement to generate all indexes to read and display all elements in...
Obs # Age Obs # Age Obs # Age Obs # Age Obs # Age 1 2019 11 2019 21 1976 31 2019 41 2006 2 1998 12 2019 22 2013 32 2018 42 2013 3 2019 13 2019 23 2019 33 2019 43 1982 4 1995 14 1980 24 1994 34 1997 44 2019 5 2018 15 2019 25 1979 35 2015 45 1988 6 2011 16 2016 26 1974 36 2019 46 2019 7 1974 17 1998 27...
can you help step-by-step so I can enter into Excel ms B С F H 1 M 1 2. 3 4 5 DE 11. Bond Pricing. A 30-year maturity bond with face value of $1,000 makes semiannual coupon payments and has a coupon rate of 8%. What is the bond's yield to maturity if the bond is selling for: (L06-2) a. $900? b. $1,000? c. $1,1002 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
tela 8 Hosgital wlections Mn 1 2 Medam 3 234 a 205 Mas Chek or Ose 249 222 16 17 304 20 121 215 22 6 24 25 28 149 134 14 Yopic 1-InfeetionsTopie 2-wd MTH/217: Statistics Health Seirvicn and Norsing Scenario tepic" ection ewe d205the infetios d d the holw er ofan d de t y vo hodv enof p tigtehe be oere in yrate in e5 The bodw Sc witim ws nedoon bdbt the t Scenate yor edite...
Obs # Age Obs # Age Obs # Age Obs # Age Obs # Age 1 2019 11 2019 21 1976 31 2019 41 2006 2 1998 12 2019 22 2013 32 2018 42 2013 3 2019 13 2019 23 2019 33 2019 43 1982 4 1995 14 1980 24 1994 34 1997 44 2019 5 2018 15 2019 25 1979 35 2015 45 1988 6 2011 16 2016 26 1974 36 2019 46 2019 7 1974 17 1998 27...
Obs # Age Obs # Age Obs # Age Obs # Age Obs # Age 1 2019 11 2019 21 1976 31 2019 41 2006 2 1998 12 2019 22 2013 32 2018 42 2013 3 2019 13 2019 23 2019 33 2019 43 1982 4 1995 14 1980 24 1994 34 1997 44 2019 5 2018 15 2019 25 1979 35 2015 45 1988 6 2011 16 2016 26 1974 36 2019 46 2019 7 1974 17 1998 27...
Problem: 1. There are two lists of customers: those who bought products in 2016 and those who bought products in 2017. Each of these lists is in alphabetical order (by last name of customer). To simplify the application, we'll assume that no two last names in the database are identical. For example, if we see Smith on the 2016 list and the 2017 list, you can assume that it is the same Smith in both cases. We want to generate...