Results 1 to 33 of 33

Need to adapt some code to a new data set

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-31-2014
    Location
    Texas
    MS-Off Ver
    Mac 2011 Version 14.5.4
    Posts
    114

    Need to adapt some code to a new data set

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adapt code
    By walber in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2017, 06:37 PM
  2. Adapt code
    By walber in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-13-2017, 04:46 AM
  3. [SOLVED] Change code to select only specific range
    By julhs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2017, 09:22 PM
  4. [SOLVED] Adapt VBA code to Copy only cells with Data
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2016, 11:45 AM
  5. [SOLVED] Adapt Code
    By PaulCooke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-15-2015, 12:05 PM
  6. Adapt AutoFilter VBA code
    By jarnold231 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2014, 11:48 PM
  7. Please help me to adapt this code.
    By Rob Hargreaves in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1