Macro to import multiple workbooks into one table

[chughes.akl]

Hi everyone,

Hoping for some assistance please - I've only been working with macro's for about three days now and this one is proving to be a bit of a head-scratcher for my limited skills!

I have created a workbook and sent it out to a database of companies for them to complete and send back to me, they are now stored in one central folder but have a variety of naming conventions. Unfortunately I also created this workbook when my excel skills were limited so the data sources aren't the easiest to navigate - but this is what I have:

1. The company name will always be in cell D6 (selected from a dropdown of company names), there may be a department identifier (but not always) in D7
2. There are four questions that have been answered (columns F, G, H, I)
3. Each of the four questions has been answered in multiple categories (headers at C11, C20, C29, C38)
4. Each category has eight identical scenarios that have been answered (C12-19, C21-28, C30-37, C39-46)

What I am eventually wanting to achieve is to be able to select one, or multiple companies, then select a scenario with the result being their answer to each of the four questions, in each of the four categories.

Any help or direction anyone can give would be extremely appreciated!

Cheers,
Chris

[Olly]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.