Excel project

Job ID: 34696514

Budget: $250 – $750 USD

I print a report in Excel and need to have some calculations performed on the results each time. Example of spreadsheet is attached. What I need is for each client number listed (Client numbers are listed in red) I need to calculate 50% of the Total Fees for that client number and put the result in the corresponding field in the Orig Split-50% column. This report and the number of clients will change each month. I will add new client numbers in the Client Number column in red and then need to have it search/lookup for each client number and calculate the 50% of Total Fees in the appropriate Orig Split field. The Total Fees amount will always be in the J column.
Related categories: Visual Basic Data Processing Data Entry Excel