Multi Step VBA to Pull Information From Multiple Tables and Create a .CSV File

[rslay]

Hi All,

I really appreciate any help I can get. The scenario is that we use an Excel template for our proposal process to calculate the hours and costs associated with certain activities.

Once we have a signed contract, we have been manually inserting those hours into our time management system to create bill codes that employees can attribute thier efforts towards.

I have recently discovered that our time management system allows for the importation of a .CSV file to automatically create bill codes instead of entering data by hand. This is also useful for when we have ammendments to contracts.

The catch is the information needs to be provided in a certain syntax.

What I need is help writing a VBA code to automatically pull information from multiple departments into the single syntax format.

In the attachment I have provided examples of 2 departments and the steps I would take to create the syntax if doing it by hand. Any help writing VBA to limit the manual process would be so appreciated.

Thank you for your time and for taking a look.

[alansidman]

I believe the file you have uploaded is corrupted as the ribbon appears blank when I open it.