Copy column data from multiple worksheets to single worksheet based on header criteria

Thanks for the welcome, and I apologize for not reading the rules more carefully. I will use the code tags in the future, for sure. I also apologize for my tardiness in reply, I've been traveling without internet for several days.

The text of the 5 column headers that I am trying to grab are the same; however, the order and number of columns will vary from sheet to sheet. This means, for example, one of my desired columns may be in column 4, or may be in column 7, depending on how that sheet was generated, which is beyond my control.

I don't totally understand your question, and I think it's probably because I wasn't clear enough in the original post. To restate hopefully with more clarity, I want to run this process once, to process a number of sheets with similar yet different structures and assemble the data in a single sheet based on my 5 column criteria.

Can you attach a workbook with some sample data showing before and after result. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Example.xlsm

I've attached a file. What's going on here is the first sheet is building different urls that will query google places API and return results based on differing keywords for businesses in a specified geographic radius. Then, I have a macro that creates a new worksheet, grabs a URL from the first worksheet, runs a web query with that URL, which returns an xml table that is populated in the newly created worksheet. There are 8 urls, so 8 worksheets are created. The problem is that some businesses return different parameters, so you will find all the worksheets are largely similar, but some have different columns that the others may or may not have, so consequently, there is not an exact similar structure shared amongst the worksheets.

I'm a bit confused. In post #1 you wanted to consolidate information in Sheet12, by identifying the proper heading in each sheet and aligning in up to the format in Sheet12? The attachment doesn't reflect that. Or maybe I'm way off?

Sorry, I modified the workbook to make it more understandable, but apparently failed, haha. If you add a worksheet to the one I attached at the far right, it'll become sheet 10, so consider that the sheet that should be referenced by that code if the code I originally posted is to be used.

OK. What are the five Column Headers to pull from in each sheet? How should they appear in Sheet 10.

Example_edited.xlsmAh! I'm really sorry for being so obtuse. I've redone the worksheet, and have included the 5 headers in worksheet titled "master". It's attached.

Does this do what you want? Again I might be way off.

Please Login or Register  to view this content.

Flawlessly. Thank you, very much, John!

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Hi. This is my first forum post... I have a similar requirement to the above and I am not familiar with using VBA in Excel. I need to generate a report from multiple sheets/tabs in a single workbook. There is specific criteria to follow when extracting to the report i.e each tab represents a Task assigned to a team and within that specific task there are action items assigned to one or more team members. Each tab is the same layout with a header row for the range to search and within the range there are action items identified and Open/Close status assigned. I need to update a report with only Open Action Items while also identifying the tab it came from (on another worksheet) after I have updated each tab with the most recent information. I know there is a way... I just haven't learned enough about Excel to do it myself yet. Can you help?

Can you attach a sample file with some dummy data? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

9 Box Tasks - Tool V1.0 UNIX 20MAR14.xlsm

Here's a sample John.

Thanks,
Angie

Angie. Perhaps you should start a new thread for this. Others who may be able to help may overlook because the thread is marked as SOLVED. BTW what determines an Open item?

John, I can start a new thread... but it will be later today. I determine open tasks from the task tab and status, then open actions for each task is on the specific tab for the task listed as a action item and Open status.