LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Change the data in one cell based on content of another.

I've had a memory lapse here. I need to change the value of one cell (user
input cell) based on the content of another cell. See the following:

Materials
# Item Unit Price Qty. Total

1 $0.00 0.00 $0.00
2 $0.00 0.00 $0.00
3 $0.00 0.00 $0.00
4 $0.00 0.00 $0.00

If no item is selected unit price will be $0.00 need Qty to revert to 0.00
as well.

Thanks in advance

Barry
 
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
Significant number rounding based on key cell Slashman Excel Worksheet Functions 2 August 27th 06 11:04 PM
How to change cell text based on another selected cell? jjh Excel Discussion (Misc queries) 1 July 6th 06 01:14 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Cell references change when entering new data [email protected] New Users to Excel 2 May 6th 05 07:48 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:33 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"