+ Reply to Thread
Results 1 to 1 of 1

Copy cell range to another workbook based on a value

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    9

    Copy cell range to another workbook based on a value

    I've looked for help on this before, but I approached it the wrong way. I need to copy and paste certain cells across workbooks in real-time.

    WB1 (FABF Jobs.xlsm) contains information that is entered and changed constantly throughout the day. WB2 (FABF Live.xlsm) will be a read-only display that shows limited information from WB1. I already have WB2 set to update in real-time, so the macro will also need to auto update WB2 when changes are made to WB1.

    WB2 needs to show projects that are marked "F" in column A, and only show Customer, Pcs, Lbs, and Ticket in that row. For example, when cell A3 is marked "F" in WB1, then copy B3:E3 and paste into B3:E3 on WB2. The days must coordinate, so other examples:
    If A24 = "F" then copy B24:E24 and paste to WB2 G3:J3
    If A108 = "F" then copy B108:E108 and paste to WB2 L24:O24

    Anything in column A marked "D" or blank will not be copied to WB2.

    Please help! I've been looking for a solution for weeks and I'm just exhausted... Thank you!
    Attached Files Attached Files

+ 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. Copy a range based on dynamic row numbers and paste into another workbook
    By Grizz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2013, 02:07 PM
  2. Replies: 4
    Last Post: 09-15-2012, 02:18 PM
  3. Macro, copy UNLOCKED cell range of sheet in open workbook to workbook template
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 11:18 AM
  4. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  5. Copy data from a range in a workbook based on a value in another
    By DJ Dusty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2006, 10:00 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