Results 1 to 1 of 1

Carry over certain data meeting conditions from one sheet to another.

Threaded View

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

    Carry over certain data meeting conditions from one sheet to another.

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

    I currently have the cells in March with the formula [=IF(+January!K3="",January!A3:B4,""] to pull the data over, however, if a row needs to be inserted, it automatically throws everything below it off. 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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Carry information from Sheet 1 to Sheet 2 maintain data integrity when adding rows
    By rhett7660 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 02:53 PM
  2. Carry over line to next worksheet if conditions are labeled not complete
    By shorthounds in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-04-2015, 05:34 AM
  3. Replies: 6
    Last Post: 10-29-2013, 12:37 AM
  4. Previous Data formula in ONE Data block that will carry each time sheet is updated
    By imagrits101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2013, 12:14 AM
  5. [SOLVED] Auto-create and name a new tab, and carry relevant data to new tab, from a master sheet
    By teenyjem in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-05-2013, 03:38 PM
  6. automaticaly copy cell data meeting certain conditions to separate worksheet
    By marc eber in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2008, 05:47 PM
  7. carry over data to other sheet - help needed
    By Svea in forum Excel General
    Replies: 3
    Last Post: 07-17-2006, 02:50 AM

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