Windows 7. LO version 5.1.6.2.
How can I merge two or more mailing lists built using LO CALC into one consolidated list?
Saw one suggestion on ‘Tech Republic’ saying ‘share’ the sheets, then click “Tools / Merge”. But in MY Tools drop-down menu there is no Merge option!
Tried “Insert / Object / OLE Object” but that option is greyed out in CALC for what I want to be the end result List (it is available in the list I am trying to add!).
In that same drop-down, I tried “Insert / Object / Chart from File” which brought some of the rows in, then wouldn’t add any more (“General OLE Error” - not very descriptive or helpful!!) It was as if the original sheet wasn’t big enough, but surely it just grows as it needs to?
On another Google search, I found “Edit / Compare Document”. I typed in the name of the second list, it asked to be “Accepted”, I clicked “Accept”, something got processed because wheels were turning - but no new names were added to the original list!
When I do somehow get them merged, I want to sort the rows by last name (Column B). I wanted to try this with the original list to see how it works. A suggestion which sounds pretty obvious was to click on ‘Data’ then select ‘Sort’.
Except the “Sort” option is greyed out and cannot be selected!
I confess to having very limited spread sheet experience, and a lot of the suggestions I’m running into seem to be about ‘defining ranges’, and other things I don’t understand. Merge different lists together; Sort the resultant merged list by Last Name. Doesn’t sound like it should be that difficult!!
Can anyone help?
I also apologize for the long post, which maybe is asking more than one question. But they are so related I was hoping for a simple answer.
Thank you all in advance!
Cheers,
Jim BK