LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default Source and Destination worksheet difference

To the 3 Great Minds,
Thanks guys, they all worked. You all must have very strong necks to support
those giant brains. Could you modify the formula to only work in the
destination cell if the letter "S" is entered in the source cell? Again
thanks to all 3.
Best Regards,
Malcolm

"Gord Dibben" wrote:

Always tweaking<g

Shorter and more readable.

Thanks Biff


Gord

On Sun, 30 May 2010 12:21:34 -0400, "T. Valko"
wrote:

Another way to write the same formulas already suggested...

=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)


.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I insert a row in a source that links to a destination Bob Excel Worksheet Functions 1 December 12th 08 07:45 AM
Paste names from a source workbook to a destination kerfloo Excel Discussion (Misc queries) 0 January 31st 08 04:55 PM
Data Validation source = destination? andy62 Excel Worksheet Functions 7 December 4th 07 11:10 PM
updating destination when I add a line to my source workbook mygrandmashousecat Excel Worksheet Functions 1 May 22nd 07 08:00 PM
XL2003 Destination and Source Open but not updating tim Excel Discussion (Misc queries) 2 December 14th 04 01:29 AM


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"