VBA Power Query connection

[Kabous07]

Good day

Almost weekend

My experience with VBA is not that good but will try my best. I have done some basics in the past. Im looking to use tables to keep records of projects information and summarize it all on one table. The problem is however, we would have a new table with each new project and i would like to avoid some steps by just using a button linked to a macro. The macro will basically append all the tables to a summary, including the new ones that get daily added.

I have on one sheet a "Summary"("Summary sheet") table and I have another sheet("Template sheet") a "Template" table. We copy the template sheet and rename it as a project number(many different numbers, normally called "PT####"). We then fill in the new project details. Afterwards we would like to add this new project to the "summary table" in the summary sheet. I was hoping to use something like Power Query and VBA or would take any suggestions please. Reason I am looking at PQ is because the append function is very nice in terms of updating project information, when going back to a certain project.

I hope my explanation makes sense.

Kind Regards
Kabous

 

[sandy666]

That's good you solved your problem
Have a nice day