Hi everyone,
The monkeys need your help again. I have three files shared here and I will break them down for you.
1. OldMacrosFile contains the code that currently works on my Mac for a different problem. This is a similar scenario but not exactly.
2. FertileFemaleCount contains the data that I need moved over. Only column AJ. Each sheet is for a different monkey group.
3. FertileTest is an example of the sort of file the code will populate information into.
While many of the files that I will use this on are "like" FertileTest, there are some key differences, not in the headers, but in the columns. However, Column J will always be the populated column. J needs to be populated with data from FertileFemaleCount column AJ, based on how the FertileTest columns C (Date) and E (Group) match with FertileFemaleCount A (Date) and each respective sheet (these are based on the same group names of R1, R2, and PB).
Does anyone think they can grab the code from the OldMacrosFile and adapt it accordingly? The only tricky thing about is that for the OldMacrosFile it needed to pull the information based on a day before the date listed. For this one, the actual date is what I need.
Thanks in advance - i hope having the code already helps.
Bookmarks