View Single Post
  #44  
Old October 13th, 2006, 10:36 PM posted to microsoft.public.excel.misc
George A. Yorks
external usenet poster
 
Posts: 38
Default creating a formul

I have two questions that hope I can get help with.

have lotus worksheet that is read only. I followed instructions from help
menu but get an error message: an error occured applying atributes to the
file, access denied. The file is on a CD, selected it, went to
file,properties and removed the check for read only. Then the error message.

Second question, Have a worksheet with 50 rows. have a second worksheet
with 50 calculations. Want to create a formula that will transfere numbers
at 29 number intervals to each of the 50 rows any and all help appreciated
--
George


"George A. Yorks" wrote:

Trying to create a formula to do the following:
Sheet 1 column A a list of personal names a1-a10

Sheet 2 has list of names a1-a10 and list of dollar amounts colums d1-d10

want to search sheet one and if any name from sheet 2 found on sheet 1 than
the corresponding dollar amount is entered.

Any help appreciated.
--
George