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!

  • Congratulations Chris Miller 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. newworld51

    Excel Macro - Find Cells & Insert Formula

    Thanks Skip, I guess what I'm really trying to do, In my macro I need to go the cell above the last value in a column and the Macro puts in a formula in that cell. The same thing for the cell below the last value in that column. Many Thanks, Alan
  2. newworld51

    Excel Macro - Find Cells & Insert Formula

    I've been trying to record a Macro and this part has me stuck. Need to insert formulas (F5 & F7) above and below the Subtotal formula. Since the data table changes with each update, the reference changes. Thanks for any help!!!! Colm F 1 x 2 x 3 x 4 x 5 =A7 6 Subtotal...
  3. newworld51

    Excel Macro - Go to Cell below formula

    I've been trying to record a Macro and this part has me stuck. Need to insert formulas (F5 & F7) above and below the Subtotal formula. Since the data table changes with each update, the reference changes. Thanks for any help!!!! Colm F 1 x 2 x 3 x 4 x 5 =A7 6 Subtotal...
  4. newworld51

    Add Access 2000 to Office 2003 Small Business Addition

    My Machine has MS Office 2003 (SBE) installed. Can I install Access 2000 from my MS Office 2000 (Professional)edition ? Thank for any help
  5. newworld51

    EXCEL 2003 RETURN VALUE BASED ON ANOTHER COLUMN

    Great, Thank You so much!!!!
  6. newworld51

    EXCEL 2003 RETURN VALUE BASED ON ANOTHER COLUMN

    Hello, I have 2 columns with only vendor name and account #. I have columns with multiple invoices and corresponding account # How do I return the vendor name in the blank column based on the account #? Inv #| Account # | Blank | Account # | Vendor Name 1 | A1 | ______ |...
  7. newworld51

    Losing remote connections

    * Have 2 windows 98 remotes at same location in another city and they both drop connections sporadically. They are connecting to a Win 2000 server using terminal services. Other widows 98 remotes in this city are ok. Swithched to Bell South at both locations for voice and data, and they...
  8. newworld51

    Error 108

    Seems when I do an A/R aging asof an old date, I get an error 108 and now I can't get an aging for any date and I can't access the invoices on individual customers. Previously did a restore and it worked fine until now. Any Ideas appreciated greatly! Thanks,
  9. newworld51

    Shipping Labels and Sales Orders

    I have two printers set up on a workstation and sometimes I only need a shipping label. In order to only print a label, I have to print a sales order also. Is there any way to bypass printing the sales order? Any help? Thanks, Alan
  10. newworld51

    Status Aborting - Frozen

    Tape on Novell Server. Has been doing fine. Now stuck aborting and status is active and not doing scheduled backups. I can't exit. How do I stop and reset to backup schedule. Thanks for any help. Alan
  11. newworld51

    A/P VENDOR PURCHASES ANALYSIS

    I HAVE 2 COMPANIES USING MAS90. On one of them, I get no data for PTD & YTD when running the Vendor Purchase Analysis Report, but I get prior year data. The other company is ok. Any help? Alan
  12. newworld51

    Exporting to Excel

    When I export an A/R aging to Excel 97, the negative values are not recognized by Excel. I have to manually adjust. Thanks, Alan
  13. newworld51

    Can't Find Printer IP Address

    Tried that, But the ip settings changed to 0's after the printer was serviced. Thanks Alan
  14. newworld51

    Can't Find Printer IP Address

    Using Novell 4.11 with W98 Workstations. Have a Techtronix Phaser 850 on NW and using Jet Direct. Had the printer serviced and I need the printer IP address for the printer configuration. I don't know where to look. Please any help, Thanks Alan
  15. newworld51

    CDRW WON'T OPEN

    Sometimes my drive will not open when I push the button on the drive; and also, when I select eject after opening the icon. Rebooting helps sometimes. Any Ideas? Thanks a bunch!
  16. newworld51

    Invoice Entry - Wrong Date

    Updated Windows 89 and Internet Explorer and the date error no longer appears. ???
  17. newworld51

    Invoice Entry - Wrong Date

    Thanks, The system date in control panel is current.
  18. newworld51

    Invoice Entry - Wrong Date

    When first going to invoice data entry in MAS90, I get the wrong default date. Sometimes it's last month and sometimes it's 2 or 3 months ago. This only happens on one workstation using Win98 on a Novell 4.11 Network.

Part and Inventory Search

Back
Top