I have created a workbook to record assets purchased though out the financial year. There are 5 worksheets within the workbook, the Cover sheet (Where all details to be entered), 1ST QTR, 2ND QTR, 3RD QTR and 4TH QTR.
All the asset details are entered into the cover sheet and then these details (Whole row) need to be reflected on either the 1ST QTR, 2ND QTR, 3RD QTR or 4TH QTR worksheet depending on the value of the ‘Period Purchased’ column (drop down List) value.
Example: I purchased a drill on 20/03/2016 for $100 and set the value of the ‘Period Purchased’ to 3RD QTR. This information should then be reflected in only the 3RD QTR worksheet.
Can I have some assistance in creating the formulas? Your assistance will be much appreciated.
Bookmarks