Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. methoni

    Excel 2003 settings

    The "send-to" option in Excel (and Word) is greyed out.I'd like to be able to email a file that I'm viewing, directly from Excel without switching to Lotus Notes first. Can anyone help me activate this option?
  2. methoni

    Excel formula

    I am looking to set up a formula that would add a certain number of consecutive cells in a table based on an input. For example; cell A2 will have an entry. Based on a lookup of that entry, I would like cell B2 to be the sum of G2:?2. Si, if cell A2 = 6, then B2 should be sum of G2:L2. Lookup...
  3. methoni

    Excel 2000 settings

    I am running Microsoft Excel 2000 on WinXP Pro. It seems that every time our IT dept works on our network system, my toolbar gets reset and also my default file location and alternate file start-up locations get changed. Are there any settings that can prevent this? Thanks for your help. DT
  4. methoni

    task manager

    Thanks in advance for your help... I am having problems accessing my task manager. Sometimes it will show up for a split second (not long enough to be able to use it). I want to kill a job sometimes and task manager is not accessible. Also, no access to msconfig. I want to see what files are...
  5. methoni

    Excel Vlookup Named Range

    How about using the data filter option. Just setup the "data", "filter", "autofilter" option on and when someone wants to know all the data on the 24's, click on the down arrow of the "key" column and pick the entry you are inquiring about. This will hide all other entries and display only what...
  6. methoni

    Excel toolbar

    In Office 2000, my toolbar gets reset every time I start Excel. I set it to fit my needs and then when I close Excel, my setting disappear and the default settings come back. Is there a way to make them permanent?
  7. methoni

    Update links when opening Excel workbook

    I have used the find/replace option to find cells that are linked to other workbooks. Just use the workbook name in the "Find what" box (including the extension) and keep repeating. That is fairly simple if the link is in only a few cells and I know it works.
  8. methoni

    Internet explore favorites

    Thank you carrr, it worked just fine. Star for you!
  9. methoni

    Internet explore favorites

    Thanks, I will try the import/export wizard. I had tried copying from windows explorer as you mentioned. I will find out tonite if it works.
  10. methoni

    Internet explore favorites

    I am not sure what forum to post this in, but here is my question: How can I copy my Internet Explorere favorites links from my work PC and send them to my home PC? Is there a way to copy all of the links and email them or copy them to file? I tried emailing them and the file could not be opened...
  11. methoni

    excel toolbar

    No such file exists. Here's another hint: I can change the toolbars in Word and they become permanent, but not in Excel. Also, my co-worker, with a similar system, can change it!! There must be some settings somwhere...
  12. methoni

    excel toolbar

    yes it is a network PC.
  13. methoni

    excel toolbar

    I customize my toolbar but when I restart Excel, all my buttons are reset again. How can I make my changes permanent? Thanks in advance.
  14. methoni

    Excel - Updating data in a cell based on compare of two other columns

    use this formula: =vlookup("cellinsheet1","datarangeinsheet2",3,false) the items in quotes are your cell addresses. Good luck!
  15. methoni

    Running macros from drop down box on user form

    I would love a copy as well.. Thanks in advance. demitrius.Triantafylidis@ahlstrom.com or methoni7@aol.com
  16. methoni

    match or lookup

    What function should I use to find a match from a table? Here's an example: Data table Col_a Col_b Col_c car red 1 car green 1 car grey 2 bike red 3 bike silver 10 scooter black 6 resulting/required table: Col_A Col_B Col_C Col_D Col_E...
  17. methoni

    excel format

    Thank you Dale, That was indeed the problem. I was unaware that each worksheet has its own settings. Thanks again
  18. methoni

    excel format

    In a workbook, I have 3 sheets. In sheet 1 cell a5 is a blank cell. In sheet 2 cell a5 references cell a5 from sheet 1 (=sheet1!a5). This results in "0". In sheet 3 the same formula in cell a5 (=sheet1!a5) results in a blank cell. Why the differences? I would like them to be blanks...
  19. methoni

    toolbar

    thank you, got it back
  20. methoni

    toolbar

    I have lost my customised toolbars after my administrator did some work on my pc. Anyone know how to quickly recover them instead of recreating them?(MSOFFICE 2000 and IE) Also, how do I prevent each open workbook from showing as an entry in my taskbar? Thanks

Part and Inventory Search

Back
Top