Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 28th 07, 09:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 23
Default Data Entry in shared workbook

I have a worksheet which tracks the progress of a new contract during the
set-up process. The contracts have many groups that work on them, and each
user updates their "sections" progress.
A= Dealer Code
B=Dealer Name
C=Dealer's Major State
D=Acct Exec Name
E=Acct Exec Code
F=Region
G=ARR
H=Agreement Tyoe
I=Request Type
J=Type of Location
K=Request Date

A-K are required on each line entry. Dependent on the data in column I
(which has a drop-down list, for selection), I would like to color specific
cells in L-AH, to indicate which of these fields also require data to be
entered, on that particular transaction.

I am using Excel 2003. Any and all suggestions are welcome.

Thanks in advance,
Sandi


Reply
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
Shared workbook loses data Chuck W[_2_] Excel Discussion (Misc queries) 6 September 12th 07 03:24 PM
Data Lost While Using a Shared Workbook WLP70 Excel Worksheet Functions 0 July 19th 07 07:52 AM
Data Entry in a Shared Workbook SueTinkham Excel Worksheet Functions 0 March 28th 07 12:09 AM
Why do I lose data in a shared workbook? trainer07 Excel Discussion (Misc queries) 0 September 7th 06 11:36 PM
Shared workbook does not display data... Kevin B Excel Discussion (Misc queries) 0 September 6th 06 02:07 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017