Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: Automate column rename/deletion

    Greetings,

    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?

    TIA,

    Regards,
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    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.

  3. #3
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66
    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?
    Regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •