+ Reply to Thread
Results 1 to 2 of 2

Link cells with non-zero values to different file

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    Wake Forest, NC
    MS-Off Ver
    2010
    Posts
    14

    Link cells with non-zero values to different file

    Hi all,

    I relatively understand the basics of linking cells between two different worksheets. I previously asked about a macro to do this, but I'm looking for the least complicated options for my clients.

    Please see attached TestExcelHelp.xlsm--I need rows with non-zero values in column H to be linked with their Inventory numbers (column B) in a new worksheet. Column H's formula is
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    . They are fine with the requirement of having both worksheets open at the same time. I just need the second (destination) worksheet to only show the item numbers (Column B) and associated non-zero values (Column H). Rows with zero values in Column H (and the associated Inventory Numbers, Column B) should not be copied to the destination worksheet.

    Thank you in advance!

    Julie

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Link cells with non-zero values to different file

    Assuming you have a worksheet called "Destination". Otherwise adjust accordingly.

    Also, I would either update your formulas to include a sheet reference, like =MAX(0,Reagents!F4 - Reagents!G4) if you want to copy over the formulas, or change the .Formula to .Value int the code below if you don't want the formula, just the number from column H

    Please Login or Register  to view this content.

+ 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. vba/macro to paste link cells (file football)
    By win1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2012, 02:31 AM
  2. [SOLVED] Link cells to a different workbook file question
    By LKM Kevin in forum Excel General
    Replies: 17
    Last Post: 05-08-2012, 09:53 AM
  3. [SOLVED] Link footer of one file to cells in another file
    By Laura in forum Excel General
    Replies: 1
    Last Post: 11-28-2005, 05:10 PM
  4. [SOLVED] Using text in cells to build a link to within another file
    By Jon in forum Excel General
    Replies: 2
    Last Post: 08-02-2005, 05:05 PM
  5. link cells values and formatting
    By kingers in forum Excel General
    Replies: 1
    Last Post: 05-22-2005, 08:05 PM

Tags for this Thread

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