Copy data from one sheet to another depending on condition

Hello All

Trust all is well.

I need one MOTHER of a miracle here guys before I jump off a cliff.

I have attached a workbook containing two worksheets and what I have been trying to achieve for nearly two weeks now, is to populate one sheet in particular cells with data from the other sheet, depending on certain criteria. I apologise if this doesn't make sense as I am halfway driven mad already by this thing! So rather than waffle a load of confusion, here are my criteria for what I am trying to do:

What are the worksheets?
Sheet 1 is a timeline that just shows dates when certain actions are due by (fully automated)
Sheet 2 is where the detail of what actions are to be taken is manually entered

What columns from each sheet do I need to use?
On sheet 1 I will be using Column B (store name), Column C (Product) and Row 5 (which displays the date)
On sheet 2 I need to use the worksheet name (ASDA in this example), Column C (Date), Column E (action) and Column I (product)

Ok so what is it I want to achieve?
From Sheet 1, loop through each cell within column B (from B6 downwards)
If cell value = a worksheet name, then select cell C6 and go to the worksheet (ASDA in this example)
From sheet 2 (ASDA) look through column I (from I16 downwards) and for every cell value that matches C6 from sheet 1, do the following:
Offset to the corresponding value in column A and select that date
Go back to Sheet 1 (Time line) and from that original cell (C6), scroll across to the right until the date in row 5 matches the date selected from column A in sheet 2
In that target cell, I want the value of that cell to match the value held in column E on sheet 2

Ok, using the above example, from the attached workbook the sheet 1 value in cell C6 is showing as ASDA and the product is Chicken Skewers. Using sheet 2 as the reference page (ASDA), the cell E6 on sheet 1 should have the value 'phone call completed'. Then if I scroll to the right of sheet 1 along that same row (6) I should see the value 'store visit rescheduled'. This is because the dates on both sheets match for the cell values.

Does that make sense? If not then that would explain why I am going mad with this.

I really hope someone can shed some light on this for me as I am in a very dark place!!!

Many thanks in Advance
G1

The first miracle we need is a review of the forum rules, and then an amended thread title.

Thanks.

No need to jump off the cliff.
Try this macro-

Please Login or Register  to view this content.

Glad to know that helped

The trim just removes extra spaces at the beginning, end or between the words. I used that because I noticed you had some spaces preceding some of the values which created problems while matching.

And learning is a ever-going process, it would never end. I still have a lot to learn about excel.