conditional link

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

In one worksheet I use a drop down list to choose a name to identify that
list where I input values. These values are linked to another worksheet
with the formula =IF(B7=Sheet1!D5,(Daily!$E$14),"") in every cell. B7 is
the name of the sales person and is picked from the same drop down list. I
want the 2nd sheet to update the values from the first list if the name
matches. The above fomula works, but when I input data under another name
the data from the firs name dissappears. I need the input data to stay when
I input data for a new name. Appearently I'm doing this wrong.
 
Pat,
On Worksheet 2 name the column in which your data is
listed. {Insert, Name, Define} For this example lets call
the column "MyData". Then on Worksheet 1 use the
Validation option for your drop down. {Data, Validation}
You then choose list and key in "=MyData.
Patty
 
Thank you,

I think I'm loosing you somewhere, maybe I was unclear from the beginning.
All I want to do is to move sales data from one form, where I also check the
validity of the report, to a summary. I want this to be done as I check the
sales forms. I use a drop down list to identify the salesperson and as I
input the sales records I want it moved to the summary (maybe with an update
function?).

When I check another salesperson's report I need the first input to remain
(my formula removes the first data).

Thanks in advance.
 
Back
Top