VBA codes for copying certain cells from many workbooks

**samirelsabagh** · 04-17-2013, 08:38 PM

Hi there
I am using Excel 2010. I have around 2,000 workbooks with three worksheets each. They are identical in their formatting. Some of the cells include text, dates or amounts.

I need to import the content of around 10 cell from each workbook. These cells are not in a range, A5, B6, C10, D12, M24 .. etc. Some cells are merged. I need to import the content of these cells for each workbook in a row in a new worksheet.

I tried several VBA codes in this forum that copy rows and columns and a single cell but they do not give me what I need.

Your help is much appreciated.

Samir

**davesexcel** · 04-17-2013, 08:40 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**samirelsabagh** · 04-17-2013, 08:55 PM

thanks davesexcel for your prompt reply. Sample file is attached. I need to import all cells marked with xxxxx from around 2000 workbooks into a single worksheet.