Is this a new question or just a added response?

If a new question, I would suggest a Lookup table and a few formulas.

See Debra Dalgleish's site for help with VLOOKUP.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Mon, 18 Sep 2006 03:21:02 -0700, mat wrote:

to fill 4 cells to the right with different numbers and letters on a basic
spreadsheet using a single command code eg type L1 and the following 4 cells
fill with the selected information automatic and be able to type L2 in the
the same cell if diferent information to L1 is needed

"RagDyer" wrote:

Whew ! ! !

Glad you got it sorted (boy, is that an understatement).<g

Just realized ... this started a week ago.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"DakotaNJ" wrote in message
...
WOOOHOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

It's working!!

The problem was I was using the A3 cell reference as the absolute location
to enter the formula. The actual location, based on what I saw on your
example, was the first cell in the entry area, in my case A5 (because of
title and headings).

So, the "130" I saw returned was actually the formula trying to pull the
information over, which began with "130" in the first cell.

I re-entered the formula in the correct cell, then copied across and
viola!
Information filled the row!

RD, I cannot thank you enough for your diligence and patience here. You
should get an award!

This is a great way to end the week. Thank you! Thank you! Thank you!

RagDyer Rocks!!!

Regards,
Dominick





--
Learning and growing everyday.


"DakotaNJ" wrote:

HI RD-

I'm missing something, but I don't see what it could be?

My workbook is set up much like yours, the formulas are identical in
nature,
but it clearly works on your WB and not on mine. What could I be
missing?

Gonna try re-entering it again and see what happens.

Thanks for your helop, have a great weekend.

Regards,
Dominick


--
Learning and growing everyday.


"RagDyer" wrote:

I'm sending you my test WB so you can see exactly what I've been
describing
to you.

Let me know if you receive it and understand it.
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit !

--------------------------------------------------------------------------
-

"DakotaNJ" wrote in message
...
Yes! We now have the formula located in the A3 cell (returned a
value of
130?), and I copied that cell formula into the first row, then
copied that
row down to the end of the spreadsheet. All cells are blank.

What next? I entered a line on the main spreadsheet and it didn't
copy to
the sub-sheet?

Regards,
Dominick
--
Learning and growing everyday.


"RagDyeR" wrote:

With the formula entered into a cell, and *after* the "wrap" is
eliminated,
you must be in *edit* mode for the CSE to work.

That means, you must *either* click in the formula bar,
OR
hit <F2 when the cell with the formula is selected.

You can tell when you're in "edit" mode by looking at what's
displayed
in
the status bar.

Click in a cell containing the formula.
The status bar displays "Ready".
Change it to "Edit" by doing either of the above,
THEN ... CSE

Does that work now?
--

Regards,

RD
================================================== ===
Please keep all correspondence within the Group, so all may
benefit!
================================================== ===

"DakotaNJ" wrote in message
...
OK, I cleared the spreadsheet cell contents. Cleared the formula.
Closed
out the program. Reopened and re-entered the formula. Still
can't get
curly
brackets though. No matter how I try (enter into cell or enter
into
formula
bar).

Regards,
Dominick

--
Learning and growing everyday.


"DakotaNJ" wrote:

Hello RD-

Thanks again for your continued help.

After much struggling I was able to enter the formula into the
formula
bar,
manually seemed to work better.

Here is the present formula (I changed 2005 to 2006 in order to
play
with
a
copy of the original, this would be next years spreadsheet)

=IF(COUNTIF('Summary FNb
2006'!$F$5:$F$154,$A$1)=ROWS($1:8),INDEX('Summary
FNb 2006'!A$5:A$154,SMALL(IF('Summary FNb
2006'!$F$5:$F$154=$A$1,ROW($1:$150)),ROW(8:8))),"" )

Wordwrap was indeed a problem which I was able to correct.

Although I have performed CSE, I do not see the curly brackets
in the
formula and
I receive a #VALUE in the A3 cell.

Oddly, it seems all the cells in the spreadsheet are reacting to
the
formula
in that when I click on a cell within the spreadsheet, it seems
to
contain
the formula and the ROW reference changes accordingly. Have I
done
something
wrong?

It seems that when I click on any cell within A6:O45 it shows
the
formula
in
the bar and the ROW reference changes. I had tried to use F2
then
CSE, it
took my PC several minutes to execute this and then I received a
"0"
in
cells
in the A column. Since this was not acceptable, I reversed this
action.
Perhaps it did not reverse?

I still cannot enter data on the main sheet and have it post to
the
sub-sheet. Nothing happens.

Where do I go from here?

Regards,
Dominick



--
Learning and growing everyday.


"Ragdyer" wrote:

I would guess that you're now a victim of "word wrap".

Try this:
Copy the formula,
Click in A3,
Click in the formula bar,
Right click in the formula bar,
Choose "Paste",

If you now see the expanded formula bar with the formula
displayed
on
multiple lines, *AND* you see that each line of the formula
*doesn't*
appear
to fill all of the lines, with a lot of space at the end of
each
line,
you
know you've got wrapping.

You can try to click at the end of a line and hit <Delete,
but
you've
got
to make sure that you don't delete characters *OR* spaces.

You might have to go the manual route to enter the formula.
THEN, try <F2 and the CSE.
--
Regards,

RD




--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all
may
benefit
!



--------------------------------------------------------------------------
-

"DakotaNJ" wrote in
message
...
Ok, RD. That stopped the error. Problem is, I can not seem
to
get
curly
brackets anymore.

I copy the formula from this message, paste it into the A3
cell,
perform
CSE
and I get #VALUE as a result, but no curly brackets.

When I was copying it in prior to this latest formula, I