Hi there, I am trying to do billing reconciliation in an excel sheet.
The sheet contains of rows of inventory items that were purchased, where the rows are grouped by unique IDs called CIcode(as each CIcode represents a bill that contains several line items of inventory).
(Completed) 1. Sum up the price of all inventory items under each unique ID. I have completed this and the variable that contains the total sum of inventory items under each CIcode is called CIGroupSum.
(Unable to complete) 2. In a new sheet, print the summarised CIGroupSum.
It should print
CI Code, Total Amount
What I have tried
Creating a new datatable called VlookupComplete, where
Assign CurrentRow(“Total Amount”) = CIGroupSum
Write Range to “Sheet2”, “A1”, “VlookupComplete”
I have tried writing cell and writing range, and both instances it prints all the rows of the last CIcode and not the CIGroupSum.
Could someone assist me please? Please let me know if you need more information. Thank you!