Genealogy Chat

Top tip - using the Genes Reunited community

Welcome to the Genes Reunited community boards!

  • The Genes Reunited community is made up of millions of people with similar interests. Discover your family history and make life long friends along the way.
  • You will find a close knit but welcoming group of keen genealogists all prepared to offer advice and help to new members.
  • And it's not all serious business. The boards are often a place to relax and be entertained by all kinds of subjects.
  • The Genes community will go out of their way to help you, so don’t be shy about asking for help.

Boards

Quick Search

Single word search

Tools

Findmypast DNA Banner

Icons

  • New posts
  • No new posts
  • Thread closed
  • Stickied, new posts
  • Stickied, no new posts

family tree via spreadsheet

Login to Add Reply Watch This
ProfilePosted byOptionsPost Date

tinkers

tinkers Report 24 Aug 2006 07:47

Have you done ur tree via spreadsheet? I have family tree maker software but i also want to add the tree via spread sheet and print that of but was wondering what would be the best way to do it

tinkers

tinkers Report 24 Aug 2006 10:53

thanks gillian

Richard in Perth

Richard in Perth Report 24 Aug 2006 10:53

Are you talking about Microsoft Excel? I have a macro that imports a Gedcom into Excel. If you'd like a copy, pm me with your email address & I'll send you a copy. No point in getting it if you don't have Excel, though! It won't work on MSWorks either. I use Excel to store all my census and BMD info. It's great as you can set up hyperlinks to scanned copies of the actual documents. I can then see at a glance what data I have and what I'm missing. Dates can be a problem in Excel though, as the program doesn't recognise dates pre-1900. However, there are several add-ons that enable you to work with dates back to 1/1/0100 - which should be plenty far back enough for most trees!! Richard

tinkers

tinkers Report 24 Aug 2006 11:01

richard yes im talking micrsoft excel i have sent u a message with my email thanks very much

Unknown

Unknown Report 24 Aug 2006 12:08

How do you set up hyperlinks? That looks interesting.

Eve

Eve Report 24 Aug 2006 12:21

That sounds interesting, Can you tell me please what is a macro? I am sure it's something I should know about but I don't. I once copied a tree into excel and it took me ages to do. If there is a better way I would love to know it. Eve

Mandy

Mandy Report 24 Aug 2006 12:37

Ok, here's my second jumping on the band wagon of the day. I'd love to hear more and have more info! The hyperlinking to excel seems just what I may be looking for!

Gill1957

Gill1957 Report 24 Aug 2006 13:23

Question to Richard - Can you not format the cells with dates in to be general and then type in??? Should try really am sitting at comp. with Excel on it! Also can I be cheeky and ask if I pm. with email addy. would you send me macro?? thanks Gill :))

Gill1957

Gill1957 Report 24 Aug 2006 13:25

Hi, quick update, have just tried and if you format excel cell to general you can type in date format like 10-1-1876, I tried it and it seemed Ok - Gill :))

Nana Anna

Nana Anna Report 24 Aug 2006 14:05

To insert a Hyperlink on a spreadsheet: Click on a cell. Then hold down Ctrl key and K at the same time. Select Link to file or URL from drop down box or Browse your files from your PC. Click OK and then you should have your hyperlink in your spreadsheet. Click on it to open the file or web page you selected. A Macro is a series of instructions written in Visual Basic Computer language. To write a Macro: Click on Tools > Macro > Visaul Basic Editor Hope it helps Anna x