Combine Rows from Multiple Workbooks into One

[JobsSteve]

Hi All,

At a complete loss on where to start on this one so any pointers would be great!

I have 7 workbooks with one worksheet each (Sheet1). The data I need starts from A6:Q*. Depending on any given date, the number of rows may change, but will always start from A6.

I need a VBA button to pull the A6:Q* rows from all 7 workbooks and paste into the active workbook or "Dashboard". The data must be pasted starting at range A6 too.

I've attached a workbook containing what the Dashboard should look like.

Thanks in advance anyone who can help!

[alansidman]

https://support.office.com/en-us/art...8-6a00041c90e4

[JobsSteve]

Thanks for this. Checked the link and although its a bit of a workaround I can work with it! So thanks!

So many functions to Excel that I'm still learning about!

[JobsSteve]

I have been a bit premature in marking this as solved! So the power query option works great, but just for me.

There are other users on my organisations network that need to use this dashboard and they cannot access the filepath for my folder location.

Any workarounds for this, OR a VBA solution rather than a power query solution?

[jindon]

See if this works.

Please Login or Register  to view this content.

[alansidman]

For this to work with multi users you need to create a parameter to direct each of the users to correct path.