Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

VBA to match data with column headers

Avatar of gtgloner
gtglonerFlag for Canada asked on
Microsoft Excel
9 Comments1 Solution871 ViewsLast Modified:
In the attached file, I have data coming from a database and I have to find a way using VBA to match up the individual data with corresponding column headers. The data sample is on the "Chart data" tab in the file and the final result as I would like it to appear is on the "Historical data" tab. There are dated row headers as well, but I already have code to find the row for the correct date to put the data on, that is not a concern here. Hope this is clear.
Book1.xls
ASKER CERTIFIED SOLUTION
Avatar of Rowan Scott
Rowan ScottFlag of Australia imageEngineering

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers