Find Dates in Range and Copy Section of Row Into Seperate Worksheet

Are you searching in Row2 ONLY as you seem to have January Dates in rows 3-4 as well? If it is row2 only, you have 4 dates to return.

Hi AB33,

I should have been more clear. I would like it search the whole range J2:AAF100, so row 2 to row 100 e.g. everytime it finds January 8th it will take the row it was found in and add C:H of that row to sheet2.

So in the case of row 2, yes it will have 4 dates to return. Then it will add to each of those dates to Sheet2 (C2:H2). And then the code will continue to check row 3 (J3:AF3) and add each of those 7 dates to sheet2 (C3:H3).

Hope that made sense

Thanks

How about if the date has a duplicate, which one do you return, 10/01/2013?

Sorry, do you mean if the same date in two different rows? If so, both rows c:h will be added to Sheet2. So for each record a new row will be added in the date filed for the information.

E.g. if row 2 contained dates 04/01 and 05/01 then c:h in row 2 will be added to both 04/01 and 05/01 in Sheet2, if row 3 also contains 05/01 then c:h in row 3 will also be added to 05/01 in Sheet2.

Thanks

No, you have only a single date in sheet2 which is a day for 31 days, but when you search in sheet1, you get a duplicate dates. I know because you have merged cell in sheet2, that is two rows are merged in to one and you are assuming two dates can be returned in to a single cell. Merged cells and VBA are not good friends. There is no way to find a value (Date) in a cell if that cell is merged with another cell.

Ah alright, understood. I've decided to change my approach as a result of what you have told me.

Please find attached.

ExampleSheet.xls

The main change is that I will no longer need to copy each row from sheet1 into its date on sheet2.

Rather i would like to use the information from rows G:N on sheet1 to subtract from its relative dates in sheet2.

I was planning on doing this step later but from what you have explained i feel it will be easier to skip my previous idea and just go straight to this step.

Please note that sheet2 is updated from the inventory worksheet.

Thanks for your persistence, is this viable?

I do not know what output you are expecting, please include with the attached your desired result.

ExampleSheet.xls

Please find attached.

I have done what you have suggested and showed my desired result. Sheet3 contains my expected results in sheet2 with added comments

Hope this helps

thanks

Hi Mackattack,
try this

Please Login or Register  to view this content.

Hi Nilem and AB33

I really appreciate the help from both of you! This looks great, I'll have a play around with it this now and try wrap my head around what you've done.

Thanks
Mack