For worksheets 21000, 21010, 21020, 21030, 21036, 21070, and 21090 we can use the Travel Order Number column (C) as unique identifier to remove data from the MAIN GOE RECONCILIATION worksheet table. For the other worksheets, data is automatically populated to each worksheet thru a macro that runs after data entered on the Procurement Log worksheet. Maybe we could use the PR NO Column for those other worksheets, as it is entered on the Procurement Log, update button hit and data goes to the appropriate worksheet. Just a thought. Any suggestion or help welcome.
Code runs for "NO" and now subtotal shows at bottom of table. We are so close, just need to remove data when Yes or blank entered.
I added the new updated workbook.
|