RandiJ
03-10-2016, 11:03 AM
Hello,
I have two excel files that I am trying to merge. I've looked at various code examples but they don't seem to work with my issue.
File 1 has the following headers: (this is also my desired output)
Ledger Group
Year
Period
Fund Code
Organization
Description
Program
BOC
Pre Encum Amount
Encumbrance Amount
Expenses Amount
File 2 has the following headers:
Show Budget Type
Ledger Group
Account
Fund
Org
Description
Program
BOC
BFY
LY
Fiscal Year
Period
Budget
Expense
Encumbrance
Pre-Encumbrance
Avail Budget
Percent Avail
I only need the following from File 2:
Ledger Group
Fiscal Year
Period
Fund
Org
Description
Program
BOC
Pre-Encumbrance
Encumbrance
Expenses
As you can see, only Ledger Group, Period, Description, Program, and BOC are similar but I need to merge the data using the headings from File 1 in the merged file.
Is is possible to get the desired result using VBA Code?
Thank you for any help received.
I have two excel files that I am trying to merge. I've looked at various code examples but they don't seem to work with my issue.
File 1 has the following headers: (this is also my desired output)
Ledger Group
Year
Period
Fund Code
Organization
Description
Program
BOC
Pre Encum Amount
Encumbrance Amount
Expenses Amount
File 2 has the following headers:
Show Budget Type
Ledger Group
Account
Fund
Org
Description
Program
BOC
BFY
LY
Fiscal Year
Period
Budget
Expense
Encumbrance
Pre-Encumbrance
Avail Budget
Percent Avail
I only need the following from File 2:
Ledger Group
Fiscal Year
Period
Fund
Org
Description
Program
BOC
Pre-Encumbrance
Encumbrance
Expenses
As you can see, only Ledger Group, Period, Description, Program, and BOC are similar but I need to merge the data using the headings from File 1 in the merged file.
Is is possible to get the desired result using VBA Code?
Thank you for any help received.