Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    need help in Excel 2002 (Excel 2002)

    Hi,
    I just installed my excel 2002 and need help.WOuld be obliged if anyone can help me. I use this worksheet often to calculate the landed cost of goods.I have a few areas in which i would welcome any help.see attached file
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: need help in Excel 2002 (Excel 2002)

    There were several questions on your spreadsheet. I will tackle a few of them for you in separate posts..

    Print Settings: First you will select (highlight) the area of the sheet that you wish to print and then click on File|Print Area|Set. Secondly, you will click on File|Page Setup and set the number of pages, the margins, orientation, etc. Thirdly, from the Page Setup dialog, you can choose Print Preview to see what your printed page will look like. Lastly, once you're happy with the print settings, Save the File. The print settings will be saved, also. Next time you open the file, you will just click on the Print icon without having to go through the setup process, again.
    - Ricky

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: need help in Excel 2002 (Excel 2002)

    There were several questions on your spreadsheet. I will tackle a few of them for you in separate posts..

    Drop Down Lists - I can see where this will be a benefit to you in a few places but it's probably not the best choice for placing a date on the form (the list would be infinite)!! The keyboard shortcut <font color=blue>Ctrl</font color=blue> + <font color=blue>;</font color=blue> works good for dates. That's Control and the semi;colon key.

    There is more than one way to deal with the other "drop down boxes" you want. Data Validation, ListBoxes and ComboBoxes. From what I see on your sheets, I believe Data Validation will be the way to go.

    While Excel is open, Tap the keyboard F1 key. Type in "list box" in the selected area and tap the Enter key. There lies step by step instructions on using Data Validation.

    THis should get you started.
    - Ricky

  4. #4
    Lounger
    Join Date
    Apr 2002
    Location
    Los Angeles, California, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need help in Excel 2002 (Excel 2002)

    These two macros will put the sheet name in B1 and set the worksheet to print as one page.

    Sub GetTabName()

    Range("B1") = ActiveSheet.Name

    End Sub

    Sub OnePagePrint()

    With ActiveSheet.PageSetup
    .FitToPagesWide = 1
    .FitToPagesTall = 1
    End With
    End Sub



    Drop Down Lists aren't too hard.

    Look in Help | index | drop-down lists, | data validation <img src=/S/read.gif border=0 alt=read width=19 height=33>


    Hope this helps.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need help in Excel 2002 (Excel 2002)

    <pre></pre>

    Try the attached for your Meters to Feet conversion. <UL><LI>The conversion formula is in D31, but it could be anywhere.<LI>The Custom Format of ";;;" (without the quotes) has been used to hide it. (Look at Format|Cells|Number|Custom - and then scroll down to the very end.)<LI>The conversion formula then has been given a name - using Insert|Name|Define - of "m_ft" (without the quotes).<LI>Whenever you need to use the conversion factor simply type: *m_ft. (This will continue to apply if your workbook ends up having many sheets in it.)[/list]HTH
    Attached Files Attached Files
    Gre

  6. #6
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need help in Excel 2002 (Excel 2002)

    Thanks for ur help.The printing solution works fine.
    With regard to the date----nice shortcut --thnks --but still doesn't solve my problem. Require a drop down list as the dates vary for different invoices
    thnks
    jb

  7. #7
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need help in Excel 2002 (Excel 2002)

    thanks for ur help.

    jb

  8. #8
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need help in Excel 2002 (Excel 2002)

    thanks.it worked
    jb

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need help in Excel 2002 (Excel 2002)

    <UL>[/list]On the date issue, from where is the workbook going to get its list of dates to populate the drop down box?
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •