Hello VBA gurus,

This is my first post on this forum and I really need help on this.

I have two sheets in my workbook. One sheet is called "TB", the other sheet is called "Crosswalk".

In my Trial Balance (TB) sheet I have 4 attributes that will be relevant to make this macro run.

•General Ledger (GL) Accounts header in column J1
•Dollar Amount header in column K1
•Begin/End Indicator header in column M1 that has the values "B" or "E"
•a Fed/NonFed header in column T1 that has various numeric values, but only "99" is considered Fed and any other values is Non-Fed

Keep in mind the number of rows in the TB sheet can increase or decrease.

My Crosswalk sheet serves as a template to determine which GL, Begin/End Indicator and Fed/NoFed attributes to use for the different financial statements. I am interested in producing the Balance Sheet, and it's respective crosswalk section in the "Crosswalk" sheet has the GL header in A2, Begin/End Indicator header in B2, and Fed/NonFed header in C2. If I change something in the Crosswalk template and re-run the macro, it should know to pick the new attribute in the TB sheet.

What I would like the macro to do is take the TB sheet (by looking at the specified columns indicated above) and run it against the Crosswalk sheet (by looking at the specified columns indicated above) to determine which GL accounts, Begin/End Indicator, Fed/NonFed attributes to use for each row in my TB sheet in order to produce the Balance Sheet. It's possible that some GL accounts maybe in the TB sheet but not in the Crosswalk sheet for the Balance Sheet section, so those should not be used to create the output.

Feel free to let me know if you have any questions.

Thank you in advance.