45 RPM Record Catalog

[Ringmaster]

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]

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]

Dave,

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

 

[Dave Peterson]

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

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

 

[Ringmaster]

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]

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.

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.

 

[Ringmaster]

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]

It sounds like it worked.

Woohoo!

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

I'll probably be back again with another crisis.

 

[Ringmaster]

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]

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!)

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

 

[Ringmaster]

Do you think it's possible that another person could make a "post" using my
name?

Somebody's going to get a lot of mail; I kinda feel sorry for anybodybody
that dumb. That's about as bad as putting your Email address on your car
window!

Wonder where we would wind up if we decided to visit?

If I could restore old records, it seems like I should be able to do a
simple Excel catalog program......

That was funny. Good talking to you; and thanks again.