Copying and combining Excel columns - Multiple Worksheets

I have a workbook with multiple worksheets that have similar data. I need to combine column C from selected (or all) worksheets into a new worksheet. I'm trying to create a key to be used in a separate SQL query. This is a monthly report so I need some automation.

Thanks!

Can you upload a sample workbook with no sensitive data showing how the data currently is presented and how you want it to appear - So in a sample sheet show how you want the data to be appear after the macro has run. It makes it much easier to supply you an accurate answer if we can see how your workbook is constructed and if we can see an example of how the workbook is to appear after the macro has processed the data. Select Go Advanced, Manage Attachments and select the dummy workbook to upload. Make sure no sensitive/private data is in the workbook you upload. Do not upload screen dumps as no one wants to reconstruct a workbook based on an image.
You will have a much better chance of getting an answer if you could supply a sample workbook.

You could use the following. If the result worksheet exists then it will just append to the current data otherwise it will create the result worksheet

Please Login or Register  to view this content.

See attached workbook

If the workbook is empty then this code will not place the column heading.

Please Login or Register  to view this content.

I hope this is what you mean.
If this solves your problem then please say so by marking your thread as Solved: 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 you still need modifications then just ask.

I am confused - if you run the code on a document with all blank sheets then the results sheet is still created however it will not create a column heading on the Result sheet - see attached wordbook.

Do you mean that you don't want the results tab generated if there is no data in the sheets/empty workbooks? or Just to clarify you mean with an Empty workbook you say that the heading in Column A on the report sheet still has "Combined Code Column" when you run the code? If the latter is so just make sure you are using the new code and not the old code. Try running the workbook in the last post and you will see that there is NO HEADING in the results sheet in Column A.
I just want to be clear on what has to be fixed. Let me know

Sorry for the late reply - I see the error now - it is fixed. Sorry took so long however have been busy - was a silly mistake on my behalf. The word Code will now not get copied if the sheet contains no data. Again my apologies for not getting back to you earlier.

Please Login or Register  to view this content.

Workbook attached.