Macro to copy data from multiple workbooks to one worksheet

[Shellybelly]

Does anyone know a macro that can copy data from multiple workbooks to a single worksheet? I am stuck.

I want to only pull the time stamps for statuses like First Break, Second Break and Lunch and also the agent names.

Anyone?

[mikeTRON]

Did you try google?
There are plenty of examples that would be just as helpful as us randomly recommending some code.

[Shellybelly]

Believe me I've tried lol

[mikeTRON]

Well we can't help with your ambiguous request unfortunately. So you can either cobble something together with google (which can be done fairly easy if you are familiar with VBA) otherwise you need to provide a specific representative sample.

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 (or use the paperclip icon).



Make sure to show the RAW data, and tell us if it will change or be in the same spot (as in the EXACT SAME SHEET AND CELLS in the multiple workbooks) and where you want them to go.