Data extraction

[AllieMcGraw]

Hi!

I hope someone could help me with the following.
I have a lot of several page excels from which I'm supposed to extract certain data into another excel. Is there a more efficient way to do this instead of me taking out data from each individual excel? An important note is that those excels have similar type data within but not exactly the same. Also, if yes then does the data from all excel files gets gathered into one excel or one original excel to one created excel?

P.s. If I'm in the wrong thread, do tell me..

Thank you

[xladept]

You're in the right thread and welcome to the Forum!

Attach a sample workbook. 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.