Re: formatting columns

From: Sue (anonymous_at_discussions.microsoft.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 04:00:10 -0700

Sorry. I'm not familiar with posting on these boards.

Both formulas worked to a point. If I did the drag down
method the cells filled in perfectly. I'm just trying to
avoid that as I will be doing a lot of data entry during a
clean up process, and preparing to use Access. That is
why I wanted the column to be formatted to autofill
depending on the number I put in the first column.

Thanks again for all the help.

>-----Original Message-----
>It would be better for you Sue, and the rest of the folks
who are willing to
>assist you if you would stay with your original post.
>In that way, all would know what was already suggested,
and what perhaps
>didn't work for you, so that they wouldn't duplicate
suggestions that you
>might have already rejected for one reason or another.
>
>Could you tell me what didn't work for you when you tried
the Choose formula
>that I had suggested three days ago?
>Even though the formula I posted only showed four
choices, I did mention
>that there was the ability to utilize the function to
return 29 choices.
>--
>Regards,
>
>RD
>
>----------------------------------------------------------
-----------------
>Please keep all correspondence within the NewsGroup, so
all may benefit !
>----------------------------------------------------------
-----------------
>
>"sue" <anonymous@discussions.microsoft.com> wrote in
message
>news:a6a901c435cc$e77e9690$a601280a@phx.gbl...
>> Thanks everyone, but let me explain my situation.
>> I am preparing to set up a database in Access2002. My
old
>> database is Clarion. It was already antiquated when the
>> department had ITS set it up 7 years ago, and I have to
>> export to Excel any time I need to pull reports or due
>> mailmerge with Word docs. That's why I'm setting up the
>> Access database. However I'm having a hard time
>> convincing my not so computer savvy boss to let me use
>> Access. He knows how to use Excel on a limited
basis...a
>> very limited basis. It will be a few months before I
will
>> have the time to set up the Access database so I must do
>> my data entry into Excel.
>>
>> There are already 8800 entries. Therefore I need the
>> entire column formatted for the one formula. AutoFill
>> takes care of most of the other 36 columns of
>> information. I'm just trying to get the two columns to
>> work together, as well has having 4 other columns
>> automatically have something in them, that I can
overwrite
>> if needed. This last part I know how to do... I think.
>>
>> So... If I type a 1 in Column A, dogs should appear
when I
>> tab to B. If I type a 2 in the next row, cats should
>> appear when I tab to B. But... I need this for all
16000
>> plus rows in the work***! Is there no way to highlight
>> the entire column when I put the formula in... in other
>> words, is there a formula that would automatically
include
>> every cell in the column, instead of my typing the
formula
>> in the first cell, and then having to drap it down the
>> whole column.
>>
>> Also, if creating the spread*** ahead of time, and
then
>> protecting the one column...can I copy the current
>> spread***, with all the info in it from the Clarion
>> database? Basically what I need is a formula that will
>> work for the whole column, for 8 different choices.
>>
>> I've tried the =IF(A1:A16000,"dogs", .... that didn't
work.
>>
>>
>
>.
>