Thanks for the offer.

And I know with all the RIAA lawsuits that can happen, you were kidding.

(Now google and all of usenet knows that you would never do such a thing!)



Ringmaster wrote:

Now I would like to do you a favor. I restore old LP records. Let me know
the type of music you like and I will send you some CD's.

My Address: John Anderson; 20 Haven Avenue; Abingdon, MD 21009

"Dave Peterson" wrote:

It sounds like it worked.

Woohoo!

Ringmaster wrote:

I GOT IT!; I GOT IT!; I GOT IT! Thanks for sticking with me.

I'll probably be back again with another crisis.

"Dave Peterson" wrote:

First, this is a text only newsgroup--so binary attachments aren't welcomed.

Second.

Select A3:A20025
A quick way to do this is to:
Edit|Goto
and type that A3:A20025 in the Reference box (at the bottom)

Now copy the formula from the earlier message, but paste it into the Formula bar
(at the top).

And hit ctrl-enter to fill the selected range.

Then watch what happens.



Ringmaster wrote:

I'm sorry, I feel like I am being a pest. I copied your formula, and pasted
it to cell A-3, then I scrolled down (and selected) to Line 20025. I do have
"Tools/Options/Calculation/Automatic" set. If I'm reading you right, this
should allow me to catalog at least 10,000 records (-A+ -B X 2). I tried
this on a new sheet; should I have worked with my sheet where Line l-A starts
with
45-0001-A. (uh-oh, this might be my problem, maybe I should have started with
45-00001-A). Should I start over again, and add the extra digit to Line 1-A?

I'm stuck; I'm not sure what to do. I've never worked with formulas. My
son had somebody at work help him with your original formula. I made a
"Zip-file" and tried to attach what I have done so far, but it exceeds the
limit set by the site.

"Dave Peterson" wrote:

Didn't each of the formulas evaluate to what you want?

Make sure calculation is set to automatic (tools|Options|Calculation tab).

Ringmaster wrote:

Dave,

I did this, down to Line 20025, now what do I do; an "auto-fill"?

"Dave Peterson" wrote:

I'm not sure I understand, but you could put this in A3
="45-"&TEXT(INT((ROW()-1)/2),"0000")&"-"&IF(MOD(ROW(),2)=1,"A","B")
and drag down as far as you need.

Ringmaster wrote:

I have had someone help me develop a form to catalog my 45 RPM Records. The
other forum was a little difficult to negotiate, and I really don't know how
to do any complex form development.

I am trying to get column "A" to autofill Line 1: "45-0001-A"; Line 2:
"45-0001-B", through Line? "45-9999-B".

I have had a friend to help me figure out part of the program, that the
other "User" on the other forum "Excel Banter", but I have tried to enter a
reply to the Forum, to include an Attachment .zip, and it's too large for the
Forum limitations.

This is what I have so far: Line 1: "45-0001-A"; Line 2: "45-0001-B", etc.
through Line 9983 showing: "45-4992-A". I need to complete autofill,
beginning with Line 9984 showing "45-4992-B", through Line ?: "45-9999-B".

I also need to insert two rows at the beginning, with Titles on Line 1;
Leaving
Line 2 (Blank), and Lock Lines 1 & 2. When I add the two additional lines,
fill in Line 1 with the Titles, and click on Line 3 to "Lock" lines 1 & 2,
some of the Lines that I have managed to "Autofill", delete two of the
existing catalog Line Items; for example: "45-0005-B" and "45-0006A" will
self-delete (this is for illustration purposes; I am not sure which two lines
will self-delete).

I have been working on this for three weeks, and I just can't figure out
what I am doing wrong.

Can someone help me complete developing my catalog?

Thanks,

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson