Messages - David1904 [ switch to compact view ]

Pages: prev1 2 3 4 [5] 6 7 8 9next
General Software Discussion / Re: autofill in EXCEL
« on: April 30, 2009, 03:57 PM »
I'm assuming you already have a table of data somewhere where "word", "word1", "word2" etc, are already existing as rows (or columns), and that what you want to do is to have the related items filled in whenever you choose a particular instance of "word".
If this is the case, then using VLOOKUP or HLOOKUP would probably be you answer.

If this is not the case you may need to supply more details so we can get a better understanding of your requirements.


TextHarvest is useful for keeping or deleting lines from text files. It is very simple to use.
You can find it on Tucows or other download sites.

General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 26, 2009, 03:46 AM »
are you familiar with the shortcuts:-
Ctrl+1   to   Ctrl+9
Ctrl+1 will "close" all items in grid (one "level")        Ctrl+9 will expand all items to the 9th level
Ctrl+Shift+1 [through to 9] will work likewise for selected item(s)

Hi tomos - I am now! :)

Looks like I'd better work my way through the shortcuts to see what they do. I'd just assumed the functionality would be there in the menus, and shortcuts would be a quicker way of doing stuff - once you knew what you were doing.

Thanks for your help, everything works as I had hoped.


General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 26, 2009, 02:28 AM »
Hi Pierre,

I am having difficulty with items and sub items.
I have maybe 25-30 items each of which may have from 1-30 sub items over time. When browsing them, it is important to be able to quickly view all sub items, then swith back to only showing items - but I can't figure out to do this. If I select all items and try and "show all sub items" an error message says to turn off the filter first. When I do, and try again, only the first item on the list expands (or perhaps the last one clicked on if I select some of them using Shift or Control.
Hunting through the manual didn't seem to help - yet presumably this is something people frequently would want to do.
Have I just missed something blindingly obvious? How can I rapidly switch between seeing only items, and seeing all items plus sub items (within a category which I have filtered for)



I also use The Master Genealogist. It is comprehensive and feature laden - in fact I don't use anywhere near all its capability. I will one day when I have more time …
Another program it might be worth looking at is GenoPro. For the money it has a lot of features and seems to handle importing GEDCOM files quite well. It is good for a visual browse around a list of people most of whom are confirmed as "in your tree" plus a host of others who might be - but as yet you haven't nailed down the precise connections. I once realised there was a connection with another family through one of my paternal great grandmothers family when I had actually been looking for a connection through a paternal great grandfather.
The program can be found here GenoPro


Pages: prev1 2 3 4 [5] 6 7 8 9next
Go to full version