Lord Uriel Posted April 5, 2006 Report Share Posted April 5, 2006 Alright, sorry to bother you gentlmen with this, but I hope somone here can help me. I've been using Phasedragon's spread sheets for a while with some success. Through practise and research I *think* I can make my own. However, I want to try and recreate something similiar to his Ship Design sheet. On the "Design" worksheet in column "G" or "item name" he has what looks and acts like a list for each component you could put on a ship. I just want to know how to recreate this. I know how to make a "list" but I can't seem to make one like his. Anyone have any thoughts or suggestions? A grateful and reformed technophobe, Lord Uriel Quote Link to comment Share on other sites More sharing options...
hobknob Posted April 6, 2006 Report Share Posted April 6, 2006 I don't use Phasedragons sheet myself and since he has left the game you are likely stuck with what you have. However, I have generated several spreadsheets and may be able to help you out. Send me Phasedragons Excel sheet that you want to duplicate/copy/modify and I will see what I can do. Quote Link to comment Share on other sites More sharing options...
Chargerman Posted April 6, 2006 Report Share Posted April 6, 2006 I don't use Phasedragons sheet myself and since he has left the game you are likely stuck with what you have. However, I have generated several spreadsheets and may be able to help you out. Send me Phasedragons Excel sheet that you want to duplicate/copy/modify and I will see what I can do. <{POST_SNAPBACK}> Hobknob, Would you mind sharing the spreadsheets you are using? I'm somewhat of an Excel junkie and have a set of sheets I’ve developed by building on what I have found out there so far. Also I’m a visual person and have been incorporating some Visio drawings for warp links and fleet locations. I would love to take a look at what a veteran player uses. Thank you Quote Link to comment Share on other sites More sharing options...
looker Posted April 6, 2006 Report Share Posted April 6, 2006 Or try :Jim Mooney [mailto:PhaseDragon@cox.net] He's in Las Vegas (last time I conversed with him). He has a good reputation and its likely he would give you a tip or two; Quote Link to comment Share on other sites More sharing options...
hobknob Posted April 7, 2006 Report Share Posted April 7, 2006 Just send me an email and I will be happy to send you copies of what I use. Quote Link to comment Share on other sites More sharing options...
Chargerman Posted April 9, 2006 Report Share Posted April 9, 2006 My Email is Mark_Margolis@yahoo.com Thank you very much!! Quote Link to comment Share on other sites More sharing options...
Calamaran Posted April 9, 2006 Report Share Posted April 9, 2006 You can open help in Excel and search for this: "Enter data in a cell from a list you specify" This will explain how to create a pull down list from a list of values you specify and seems to be exactly what you are looking for. Calamaran. Quote Link to comment Share on other sites More sharing options...
Lord Uriel Posted April 9, 2006 Author Report Share Posted April 9, 2006 You can open help in Excel and search for this:"Enter data in a cell from a list you specify" This will explain how to create a pull down list from a list of values you specify and seems to be exactly what you are looking for. Calamaran. <{POST_SNAPBACK}> You sir, rock! I'll check this out later today (after the yard work) Thanks, Lord Uriel Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.