Forum Discussion
HOW TO JOIN VALUES ON DIFFERENT SHEETS ON 1 MASTER SHEETS see sample
The software cannot create sheet on its own, I will be the one to define on which cell it will started.
because it is a template and all that 6 columns is constant, my problem is how to join them all into the master sheet and the data that will be displayed in row is not constant it will vary depending on how many objects have been selected from the other software.
I want either of solution, I'm sorry i just mistakenly typed it.
I hope my message is clear, Im not good at english , really sorry.
Jaygenodiala112 No apologies needed. I'm just trying to get a clear picture in my mind. Personally, I'm not a VBA person and prefer to work with PowerQuery. Set-it up once, add or delete data and you can refresh the query over and over again.
Studied your file a bit closer and it seems that every sheet is for a project and the data seems to start at C13. Sheet 1 and Sheet2 are shifted one column to the right because you inserted one column in your attempts solve this with formulas. Correct?
Yes, I tried all my little knowledge but failed to do so. Thank you so much for responding my question here. I really appreciate it.