Copy Data From 3 Worksheets into a 4th Worksheet

I have three worksheets with different data. All three share one common field “Alpha.” I need to copy “Alpha” to the fourth worksheet along with one other column of data. But that other data varies between the three worksheets.

• From Sheet1 I need to copy Non-Blank instances of “Alpha” plus “Bravo” to Sheet4
• From Sheet2 I need to copy Non-Blank instances of “Alpha” plus “Charlie” to Sheet4
• From Sheet3 I need to copy Non-Blank instances of “Alpha” plus “Delta” to Sheet4

The attached worksheet illustrates.

All four worksheets have varying and unknown numbers of data rows.

All four worksheets have the data in tables (ListObjects). I don’t think this matters but it may be helpful to know.

When Sheet4 is activated we first need to clear all content in Alpha, Bravo, Charlie and Delta columns without disturbing other columns that have formulas. Because I am using Tables, it is possible to delete all rows except the first data row that contains the formulas (when new data is pasted the formulas automatically fill in).

Thanks in advance for your time and consideration.

Hello,

See if this code helps

Please Login or Register  to view this content.

Thanks

Hi fredlo2010,

All four of the worksheets exist already and all have headings too. I will take a look at the code tonight.

Thanks!

Here's some more info, fredlo2010.

As we cycle through the ws the input columns is not identical so the For Each won't work. I can get around that by declaring each copying separately.

But there are a couple other problems, too. First, we need to clear the contents of Alpha, bravo, charlie and delta on the final ws before pasting new content, keeping in mind that there are a dozen other columns containing formulas.

Finally, we need to sort Final by Alpha number on the Final ws.

I am clueless about the function appended.

Please let me know if I have raised more questions!

Thanks again.

I am sorry snapfade I am not able to find a solution with the updated information.

Sorry about that

no worries...thanks for trying.