Excel Sorting help

Thanks for effort Max, I just can't make it work. I am copy/pasting the
formulas and can get everything to work right up until the "WSN" part.

I tried testing the [insertnamedefine] by entering [=WSN] and I get a
#VALUE! error. Perhaps I am entering something incorrectly but I think
I am following the directions exactly.

I have found numerous posts where you have given the exact same answers
to others and they always respond that it worked great.

Maybe I have a setting wrong or something.

I'll keep working on it and any input would be appreciated.

Thanks again.

Hi

In case Max is offline by now (for his time zone), then from his
original post

Click Insert Name Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)
Click OK

You don't put =WSN in the define part.

Max was suggesting you type =WSN into a cell in any worksheet (after you
have created the definition of WSN as above) and it will return the name
of the worksheet.

--
Regards

Roger Govier


wrote in message
ups.com...
Thanks for effort Max, I just can't make it work. I am copy/pasting
the
formulas and can get everything to work right up until the "WSN" part.

I tried testing the [insertnamedefine] by entering [=WSN] and I get
a
#VALUE! error. Perhaps I am entering something incorrectly but I think
I am following the directions exactly.

I have found numerous posts where you have given the exact same
answers
to others and they always respond that it worked great.

Maybe I have a setting wrong or something.

I'll keep working on it and any input would be appreciated.

Thanks again.

Right. Can't get it to cooperate.

Under heading "Names in workbook:" WSN
Under heading "Refers to:" =MID(....
[Copied and Pasted the formula AND manually entered it]
then clicked OK.

Went to any random cell (for example cell C1 in Sht1) and input: =WSN

returned the "#VALUE!" error message. If you input =WSN without
defining the name the error message is #NAME?, so it obviously
recognizes something is there.

I can't figure it out.

Since I don't know anything about defining names, perhaps someone can
give me a REALLY simple naming formula that I can test as a base.

Still truckin along....

Nate

I just tried InsertNameDefine using WSN as the "Name in workbook"
but just using a simple cell reference as the "refers to" and it worked
like a charm. Returns the value entered into the cell reference
wherever I input =WSN.

Aaaah!!!

One small point that we have omitted to say, the Workbook has to have
been saved.
Try saving the workbook, then all should work as described.

--
Regards

Roger Govier


wrote in message
ups.com...
I just tried InsertNameDefine using WSN as the "Name in workbook"
but just using a simple cell reference as the "refers to" and it
worked
like a charm. Returns the value entered into the cell reference
wherever I input =WSN.

Okay, I am going to try a new approach. Sorry if I wasted anyone's time
befo I did learn a handful of new tricks though.

I have uploaded a stripped down version of exactly what I am working on
to:

http://savefile.com/files/44089

As you can see what I specifically need is to get one input list of
info into multiple output lists on the same page. There will always be
three potential owners (1,2, or 1&2) although the number of assets
owned by each will vary.

The extra info on the input sheet goes to other places and should not
be heeded attention.

Lastly, if anyone is feeling particularly genuis, I could use a way to
automatically number the assets on the "asset ownership" sheet. In
other words, IF owner one has three assets listed they are numbered as
such. More importantly, however, I need owner 2's first asset in the
list to pick up at numeral four and continue from there.

I am hesitant to ask someone else to "fix it for me" as that provides
no education. However, I am running out of options and all I can ask is
that my temporary Saint trust that I will learn from the formulas on
the functioning spreadsheet.

Thanks immensely,

Nate

Roger & Max

I am deeply indebted to you. It was all in the SAVE! I got it to work.
If you have free time I would still like someone to look at the
uploaded sheets. They are a good bit different than the potential fix
we have worked out.

wrote:
... http://savefile.com/files/44089
Think savefile is still having intermittent problems ..

Use either of the 2 free filehosts listed below to upload your sample and
then post the link to it in response here (the link is generated when you
upload, just copy and paste it here)

http://www.flypicture.com/
http://cjoint.com/index.php

For cjoint.com (it's in French), just click the "Browse" button,
navigate to folder select the file Open, then click the button centred
in the page below (labelled "Creer le lien Cjoint") and it'll generate the
link. Then copy & paste the generated link as part and parcel of your
response here.

Kindly note that no attachments should be posted *directly* to the newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

As per earlier response in the other branch ..
think savefile.com is having problems (cannot download)
use either of these 2 alternatives to upload & post the link to your sample:
http://www.flypicture.com/
http://cjoint.com/index.php
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
oups.com...
Roger & Max

I am deeply indebted to you. It was all in the SAVE! I got it to work.
If you have free time I would still like someone to look at the
uploaded sheets. They are a good bit different than the potential fix
we have worked out.

Sorry, I didn't know it was having problems. I re-uploaded he

http://www.flypicture.com?display=updone&id=r9DylKnR

Hope you have some ideas Max.

Thanks