Macro to copy range from sheet A, B and C to sheet D under cell with certain value

[theNemon]

Hi, excel 2010 here again. Been searching for similar issues but it's both difficult to describe in google the problem and understand different solutions, but it's something like this:

In sheet A, B and C the cell E1 has a value, let's say "abc". This value is also located on sheet D, and I need a macro that will copy the ranges D3:D10 from sheet A, B and C, search and find the cell on sheet D that has the same value as sheet A's E1 ("abc" or whatever) and then paste everything under it. Any help is greatly appreciated, as vba is fairly new to me!

 

[hiker95]

theNemon,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

To start off, and, so that we can get it right on the first try:

Can you post screenshots of the actual raw data worksheets, worksheets A, B, and, C?

And, can you post a screenshot of worksheet D (manually formatted by you) for the results that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG/IMG file, or, flat text) try one of the following:

There are several methods. Here are 3 for you to investigate.

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

To test the above:
Test Here


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com