Is it possible?
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 could get
curly
brackets from CSE. Of course I also got File Not Found too.
Am I just an idiot and I'm missing a step somewhere?
This seems to have moved from a curiosity to a passion for me. I'm
determined to get this thing right so all your wonderful help is not
wasted!
Regards,
Dominick
--
Learning and growing everyday.
"Ragdyer" wrote:
Try this:
=IF(COUNTIF('Summary FNb
2005'!$F$5:$F$154,$A$1)=ROWS($1:1),INDEX('Summary
FNb 2005'!A$5:A$154,SMALL(IF('Summary FNb
2005'!$F$5:$F$154=$A$1,ROW($1:$150)),ROW(1:1))),"" )
Don't forget to use CSE to enter it.
--
HTH,
RD
-------------------------------------------------------------------------
--
Please keep all correspondence within the NewsGroup, so all may
benefit !
-------------------------------------------------------------------------
--
"DakotaNJ" wrote in message
...
OK, sorry about that RD.
The EXACT names a
Incident statistics 2006.xls (The Workbook)
Summary FNb 2005 (Main spreadsheet)
Summary FNbG (sub sheet)
Summary FNb-C (sub sheet)
Summary FNbH-Range (sub sheet)
Summary FNbW (sub sheet)
Summary HAP (sub sheet)
The F-column (Divission name) values a
FNbG
FNbH-C
FNbH-R
FNbW
HAP
Each of these values are the name of the respective sub-sheet,
located
in
cell A1 of each sheet.
Yes, the names of the sub sheets exactly match what I enter in the
F-column
of the "Summary FNb 2005" sheet.
I use cell A3 of each sub sheet to enter the formula.
I can't think of any other variables. I see the methodology pretty
clearly,
just need to tweak the formula to make it work.
As always, thanks so much for your excellent help!
Regards,
Dominick
--
Learning and growing everyday.
"RagDyer" wrote:
It seems that each new post of yours divulges *new* information
or
*changes*
information previously stated.
OR ... you're making a bunch of typos!
What is the *exact* name of your MAIN sheet, including spaces?
Are you *sure* that there are *no* spaces at the beginning and/or
the
end of
the name?
The "File Not Found" window is coming up because the sheet name
in
the
formula *does not* match ANY sheet in the workbook.
That can also give you a #VALUE! error when you by-pass it.
Are you entering the name of the sub sheet in *A1* or *A3* of
each
sub
sheet? ? ?
Do some of the names of the sub sheets contain dashes (Summary
FNb-C),
and
some don't (Summary FNbW)?
And if they are mixed formats, do they *exactly* match what you
have
entered
on the Main sheet in Column F?
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!
--------------------------------------------------------------------------
-
"DakotaNJ" wrote in message
...
AARRGGGHHHH!!!!!!
I'm somehow missing something.
I was able to copy the formula into the A:3 cells of each
spreadsheet,
I
CSE'd them, got a #VALUE response in each of those cells. I
copied
that
cell
into a row across the spreadsheet, then copied that row down
through
all
rows. I get a #VALUE in each of those cells.
|