I have a source table I feed data into from an ODBC data base call. I use this table as a source table to calculate certain values in another target table.

Now I have to update this source table every week and the number of rows in the source table thus changes every week. In column 1 I have the activity names and I would like for my target table to update the number of rows and column 1 names as well when I make the ODBC call.

I have almost solved the issue by watching this youtube.com video:

link

So basically exactly what he does in this video, except I do not want a data validation drop down list, but just for the table to add rows.

Can anyone help me fix my table so what he has in the drop down data validation list gets put in my table as rows instead?

With kind regards
Ulrik