Get extract in new sheet.xlsx |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y |
---|
1 | DAY | DATE | PARTICULARS | MIN | MAX | Multiples | No of Rows | | | ROW | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
---|
2 | Sun | 4/1/2022 | January | 60 | 100 | 10 | 12 | First Date to start in Extract sheet as in Data sheet cell B2 | | | 90.00 | 1200.00 | 120.00 | 140.00 | 170.00 | 10000.00 | 10000.00 | 12000.00 | 260.00 | 15000.00 | 90.00 | 55.00 | 25.00 | 10.00 | |
---|
3 | Mon | 4/2/2022 | February | 1200 | 1200 | 10 | 52 | First Date to start in Extract sheet as in Data sheet cell B3 | | | | | | | | | | | | | | | | | |
---|
4 | Fri | 4/6/2022 | March | 100 | 200 | 10 | 52 | First Date to start in Extract sheet as in Data sheet cell B4 | | | | | | | | | | | | | | | | | |
---|
5 | Sun | 4/1/2022 | April | 120 | 150 | 10 | 365 | First Date to start in Extract sheet as in Data sheet cell B5 | | | | | | | | | | | | | | | | | |
---|
6 | Wed | 4/25/2022 | May | 150 | 200 | 10 | 12 | First Date to start in Extract sheet as in Data sheet cell B6 | | | | | | | | | | | | | | | | | |
---|
7 | Tue | 4/3/2022 | June | 10000 | 10000 | 1 | 12 | First Date to start in Extract sheet as in Data sheet cell B7 | | | | | | | | | | | | | | | | | |
---|
8 | Thu | 4/5/2022 | July | 10000 | 10000 | 1 | 24 | First Date to start in Extract sheet as in Data sheet cell B8 & next date 15 days after the date in cell B8 | | | | | | | | | | | | | | | | | |
---|
9 | Sat | 4/7/2022 | August | 12000 | 12000 | 1 | 24 | First Date to start in Extract sheet as in Data sheet cell B9 & next date 15 days after the date in cell B9 | | | | | | | | | | | | | | | | | |
---|
10 | Wed | 4/4/2022 | September | 200 | 500 | 10 | 52 | First Date to start in Extract sheet as in Data sheet cell B10 | | | | | | | | | | | | | | | | | |
---|
11 | Wed | 3/25/2023 | October | 15000 | 15000 | 1 | 1 | First Date to start in Extract sheet as in Data sheet cell B11 | | | | | | | | | | | | | | | | | |
---|
12 | Sun | 4/1/2022 | November | 10 | 100 | 10 | 120 | First Date to start in Extract sheet as in Data sheet cell B12 | | | | | | | | | | | | | | | | | |
---|
13 | Tue | 4/3/2022 | December | 10 | 100 | 5 | 7 | First Date to start in Extract sheet as in Data sheet cell B13 | | | | | | | | | | | | | | | | | |
---|
14 | Mon | 4/2/2022 | Sunday | 15 | 50 | 5 | 7 | First Date to start in Extract sheet as in Data sheet cell B14 | | | | | | | | | | | | | | | | | |
---|
15 | Sun | 4/1/2022 | Monday | 8 | 12 | 1 | 365 | First Date to start in Extract sheet as in Data sheet cell B15 | | | | | | | | | | | | | | | | | |
---|
16 | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
17 | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
18 | | | | Code to do the following: | | | | | | | | | | | | | | | | | | | | | |
---|
19 | | | | Get formula in the code from columns K2 to X2 | | | | | | | | | | | | | | | | | | | | | |
---|
20 | | | | Columns K to X to resize rows K2 to X2 and fill down as per the number of rows mentioned in column G | | | | | | | | | | | | | | | | | | | | | |
---|
21 | | | 1 | Write Headings in the Extract sheet as shown | | | | | | | | | | | | | | | | | | | | | |
---|
22 | | | 2 | Copy Date from Data sheet row B2 to Extract sheet cell B2 and as per G2 drag the dates to the number of rows mentioned in column G | | | | | | | | | | | | | | | | | | | | | |
---|
23 | | | | In case the no of rows is 12and If the date is 01-04-2022 then get 01-05-2022, 01-06-2022 and so on. | | | | | | | | | | | | | | | | | | | | | |
---|
24 | | | | In case the no of rows is 52 and If the date is 01-04-2022 then get 01-05-2022+7 and fill down till 52 rows | | | | | | | | | | | | | | | | | | | | | |
---|
25 | | | | In each case the number of rows mentioned in column G, that many rows to be filled in the extract sheet starting from the date mentioned in column B of the Data sheet. | | | | | | | | | | | | | | | | | | | | | |
---|
26 | | | 3 | In the amount column of the Extract sheet, take the values of that particular row from K to X. | | | | | | | | | | | | | | | | | | | | | |
---|
27 | | | 4 | Copy date from Data sheet row B3 to Extract sheet to the next empty cell and follow the same procedure as mentioned in 2 | | | | | | | | | | | | | | | | | | | | | |
---|
28 | | | | Follow the procedure till data is available in column C of the data sheet. | | | | | | | | | | | | | | | | | | | | | |
---|
29 | | | 5 | After all the data is entered in Extract sheet, fill the line column with numbers in series from 1 to end. | | | | | | | | | | | | | | | | | | | | | |
---|
30 | | | | The extract sheet result is manually entered for 2 rows of data only to show the expected result. | | | | | | | | | | | | | | | | | | | | | |
---|
31 | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
|
---|