Thread: Help with Lists
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RalphB RalphB is offline
external usenet poster
 
Posts: 3
Default Help with Lists

Thank you.

"L. Howard Kittle" wrote:

Hi Ralphb,

Perhaps something like this in sheet 2 and pulled down far enough to cover
the list in sheet 1.

=IF(Sheet1!A1="","",Sheet1!A1)

HTH
Regards,
Howard

"RalphB" wrote in message
...
I have a list on one sheet and would like to show the same list on
anothersheet. The problem is, I want the list on sheet2 to be updated at
the
same time the list on sheet1 is changed so that both they are always the
same. Both sheets are in the same workbook. Can anyone one help?