Splitting Fixed Assets into multiple rows


September 23rd, 2014 by admin admin

A past participant was working on a Fixed Asset Register and one of the tasks she is required to do is to split up the Fixed Assets into multiple rows, based on the quantity. Given below is an example of what has to be done.

a) A00016 Well Management Pte Ltd 10297 AM00000000002685 4.00 APOT-0150

19-Dec-01

369.48 369.48 0.00
b) A00016 Well Management   Pte Ltd 10297 AM00000000002685 1.00 APOT-0150

19-Dec-01

92.37 92.37 0.00
c) A00016 Well Management   Pte Ltd 10297 AM00000000002685 1.00 APOT-0150

19-Dec-01

92.37 92.37 0.00
d) A00016 Well Management   Pte Ltd 10297 AM00000000002685 1.00 APOT-0150

19-Dec-01

92.37 92.37 0.00
e)A00016 Well Management   Pte Ltd 10297 AM00000000002685 1.00 APOT-0150

19-Dec-01

92.37 92.37 0.00

Meaning I need to split item (a) of qty 4 equally into (b) to (e) of qty 1 and cost p/qty in each line.

This would have been quite straight forward if the quantity for all the Fixed Assets are the same. The problem is, they are not. Therefore, we have to use VLOOKUP with approximate match to determine the number of rows required for each line of Fixed Assets and populate them into the relevant rows. The worksheet function COlUMN is used to help us identify the column index number for the VLOOKUP formula. And in this example, I also did a quick demonstration on filling up a range to a specific number almost instantly. Watch the video below to learn the application of each function.

If you have benefitted from the video, we would love to hear from you. Let us know which part of the solution is useful to you and how it has benefitted you.

 

 

Leave a Reply

You must be logged in to post a comment.

s2Member®