+ Reply to Thread
Results 1 to 9 of 9

Values of cells to be routed to other sheet

Hybrid View

laansesu Values of cells to be routed... 12-31-2015, 06:06 AM
laansesu Re: Values of cells to be... 01-02-2016, 02:48 AM
LeoTaxi Re: Values of cells to be... 01-02-2016, 02:49 PM
laansesu Re: Values of cells to be... 01-03-2016, 03:06 AM
LeoTaxi Re: Values of cells to be... 01-03-2016, 04:38 PM
laansesu Re: Values of cells to be... 01-05-2016, 01:58 AM
laansesu Re: Values of cells to be... 01-12-2016, 06:19 AM
LeoTaxi Re: Values of cells to be... 01-12-2016, 08:04 AM
laansesu Re: Values of cells to be... 01-13-2016, 04:49 AM
  1. #1
    Forum Contributor
    Join Date
    08-02-2015
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    160

    Re: Values of cells to be routed to other sheet

    Thanks Leo!!!! There is a small modification required in the code.

    Call Balance button is not required as I'm trying to get the balance with simple Index formula as shown below

    =IFERROR(INDEX(SSR!$B$9:$FU$42,MATCH($F14,SSR!$A$8:$A$42,0),MATCH($G$8&"BAL",SSR!$B$7:$FU$7,0)),"")

    Replace Quantity button should be just Quantity, as I'm trying to add the quantity with the existing quantity rather than replacing.

    So request you to please make changes and do the needful.
    Last edited by laansesu; 01-05-2016 at 02:13 AM.

+ 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. [SOLVED] Values to be routed from one sheet to other sheets
    By laansesu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-12-2015, 06:19 AM
  2. Sending Routed Worksheet as a 1993-2003 Doc
    By walke145 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2014, 11:01 AM
  3. Replies: 2
    Last Post: 11-21-2013, 10:01 AM
  4. Replies: 1
    Last Post: 04-11-2013, 01:02 PM
  5. Replies: 5
    Last Post: 02-21-2013, 07:17 PM
  6. Change Routing Message in Outlook when Excel File is Routed
    By Mike R. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2005, 12:45 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