Thanks to all who have replied. The suggestion below from Jim N6VH at the DXBase reflector works. As a matter of fact "Find All" found I had made a mistake in assigning YB8EL to Sumatra, which is only for YB4, 5, or 6. Turns out YB8 actually goes to Celebes and Molucca Islands with a 1937 prefix of PK6. I've corrected my error, but would never have caught it without using "Find All" to produce the entire list of hits on Indonesia.
Unfortunately, as Jim mentions, it isn't possible to jump directly to any of the line items in the list produced by "Find All". Rather you must scroll up or down to get to the various lines to see which one is the correct one for your entry. Fortunately the list of finds can be kept open for reference while scrolling about checking the various possibilities. 73, Gary AL9A ----- Original Message ----- From: "Jim Preston" <[email protected]> To: <[email protected]> Sent: January 10, 2012 6:26 AM Subject: Re: [Dxbase] ARRL Diamond DXCC Award > Gary, > > Here is one work-around. Instead of using "Find Next", use "Find All". > This will list the cell where the item is. Scroll down to the cell > number. This isn't very elegant, but it works. > > Using F2 to edit the cell worked for me, as did doing the edit in the > formula bar at the top of the sheet. > > Incidentally, I use Excel 2003. > > 73, > > Jim N6VH ----- Original Message ----- From: Joe K2UF To: [email protected] Sent: January 10, 2012 9:20 AM Subject: RE: [ARRL-LOTW] Re: ARRL Diamond DXCC Award Gary, I am using (antique) EXCEL 2000 The FIND command works but you can not leave it up and do anything on the ss. I must close the FIND window to edit the page. If I make a mistake on a box I just go back to the box and hit delete and enter every thing for that box again. Works similar to the CQ marathon submittal form. Joe K2UF No trees were harmed in the sending of this e-mail; however, many electrons were inconvenienced. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Sent: Tuesday, January 10, 2012 1:09 PM To: [email protected] Subject: [ARRL-LOTW] Re: ARRL Diamond DXCC Award Gary, I'm using OpenOffice Calc also. The sheet is protected in OpenOffice, but the Find works anyway. I haven't been using Excel much lately, so I don't know if there is a way around your problem (without unprotecting the cell), but it seems like a nice feature on the part of OO. Mike N2NW --- In [email protected], "Gary AL9A" <al9a@...> wrote: > > I'm using Excel 2007. Just discovered what is probably causing the problem. > The worksheet is protected. Many of the drop down menu items are grayed out > as are many of the tool icons in the various tabs at the the top of the > spreadsheet. There is an unprotect icon, but clicking on that opens a > window that asks for a password necessary to unprotect the sheet. I'm sure > ARRL did this to "dummy" proof the thing so they wouldn't be getting a ton > of phone calls and emails asking for help in restoring a damaged > spreadsheet. > > Apparently the protection scheme doesn't work when opened with OpenOffice. > I have that package on a Netbook running XP so maybe I'll give it a try just > to see what happens. > > 73, > Gary AL9A > > ----- Original Message ----- > From: "iain macdonnell - N6ML" <ar@...> > To: <[email protected]> > Cc: "DXbase Reflector" <dxbase@...> > Sent: January 09, 2012 8:55 PM > Subject: Re: [ARRL-LOTW] ARRL Diamond DXCC Award > > > >I opened the spreadsheet using OpenOffice.org Calc 3.3.0, and the Find > > function seems to work. I don't have Excel, but I'd be kindof > > surprised if its Find doesn't work too....... > > > > ~iain / N6ML > > > > > > On Mon, Jan 9, 2012 at 9:34 PM, Gary AL9A <al9a@...> wrote: > >> > >> > >> > >> Here's a gotcha for anyone using the Excel spreadsheet from the ARRL web > >> site to track your Diamond DXCC progress. Unless I'm missing something, I > >> cannot get Find to work in the spreadsheet. Using Find makes it easier > >> and > >> faster to get to the country you want, but without Find working you must > >> use > >> the mouse to repeatedly scroll up and down the list. Then there is a > >> problem in finding some countries as they are not alphabetically listed > >> by > >> current country, but historical country. I had a problem trying to find > >> Indonesia today. The former name is Sumatra, so unless you're a geography > >> wiz... > >> > >> Absent getting Find to work in the Excel spreadsheet my work around is to > >> also download the Diamond DXCC country list in pdf format. Find does work > >> in the pdf file so if I get stuck looking for a country that had a > >> previous > >> name I can search the pdf file to find the present day name in the row of > >> its' former name, then jump over the the Excel spreadsheet and scroll to > >> the > >> correct former name. A bit of a pain unless someone can figure out how to > >> make Find work in the spreadsheet. > >> > >> Oh, another gotcha. In making an entry in the Date/Time field I messed up > >> and tabbed to the next field after entering just the date and not the > >> time. > >> When I saw my mistake I went back, hit F2 to edit the cell entry and > >> added > >> the time to the field. When I hit Enter only the Date still displayed, > >> not > >> the Date and Time. In checking the cell entry line at the top of the > >> spreadsheet I could see the time was now there along with the date, but > >> it > >> would not display in the cell. I tried to go to Format the cell, but it > >> is > >> grayed out in the selection menu. > >> > >> Fortunately I am working on a copy of the original spreadsheet as > >> suggested > >> in the ARRL instructions. I opened the original empty spreadsheet and > >> copied the empty cell from the Date/Time column and pasted it into my > >> spreadsheet. That restored the cell formatting and let me enter date and > >> time so it displayed correctly. > >> > >> 73, > >> Gary AL9A > >> > >> > > > > > > ------------------------------------ > > > > Yahoo! Groups Links > > > > > > > ------------------------------------ Yahoo! Groups Links __._,_.___ Reply to sender | Reply to group | Reply via web post | Start a New Topic Messages in this topic (5) Recent Activity: Visit Your Group MARKETPLACE Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now. Switch to: Text-Only, Daily Digest . Unsubscribe . Terms of Use. __,_._,___ ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
