var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Automate column rename/deletion
Given the attach sample order/receiving report
1. Rename column names that are labeled differently in receiving report to match those in order report
2. Delete the remaining columns
I'll then use vlookup, macro, or formulas to reconcile the two reports.
What would be the best tool (Access or Excel) to automate this process?
If the fields are always in the same order, run a VBA macro to re-assign each field.
Range("A1").value = "CLIENT"
Range("B1").value = "AMT"....etc.
ranman, thank you.
Yes, the fields are always the same way, and using vba I have those columns needed in both my reports (order and receiving) in the same workbook. How can I load them into one report for reconciliation purposes?