+ Reply to Thread
Results 1 to 3 of 3

VBA code to pull data between sheets on a condition of column K

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    9

    VBA code to pull data between sheets on a condition of column K

    I am creating a workbook that has 12 sheets, January - December.

    I would like to have the data from January to automatically go pull into the March, May, July, September, November sheets if there is not a date in column K.

    I currently have this set up with a formula for each line. For instance, the cells in March with the formula [=IF(+January!K3="",January!A3:B4,""] to pull the data over from January, however, if a row needs to be inserted, it automatically throws everything below it off. Another problem, is that if a date is entered in column K, then it just leaves empty rows in the spot it would pull from the previous 60 days. Again, if those are taken out, it throws an error. I am not sure what I need to do to first.. Do I need a macro for this? or a condition?

    I attached a sample of what I'm working on to view. Any input you may have on this will be extremely helpful
    Attached Files Attached Files
    Last edited by MichelleD75; 05-11-2016 at 03:08 PM. Reason: Was told it was not within the rules guidelines for title.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Need HELP! VBA code or just a formula needed for this??

    title updated.
    Last edited by protonLeah; 05-11-2016 at 03:13 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    05-10-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    9

    Re: Need HELP! VBA code or just a formula needed for this??

    Absolutely, I will change it. Sorry for the confusion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. FORMULA Needed to code records
    By matthewdete in forum Excel General
    Replies: 5
    Last Post: 06-02-2015, 12:09 PM
  2. [SOLVED] VBA Code needed for introducing a CHAR on the left side of a cell with formula
    By alchavar in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-29-2013, 12:25 AM
  3. VBA Code Needed for a certain formula in Excel
    By raishikoh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2013, 09:25 PM
  4. Help needed for creating array and writing formula in VBA, code included
    By yanheng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2012, 02:00 PM
  5. VBA code needed to apply formula to each value in a dynamic range!
    By burk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2006, 09:00 AM
  6. Complicated Formula/Code needed
    By Andy (Hypnotic_Monkey_Scratcher) in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2005, 05:05 PM
  7. [SOLVED] formula / code help needed
    By Paul Watkins in forum Excel General
    Replies: 2
    Last Post: 03-16-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