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 Wanet Telecoms Ltd 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: *

  • Users: skygirl65
  • Content: Threads
  • Order by date
  1. skygirl65

    Excel question - comparing two lists

    I have a workbook with monthly account lisitngs. Each month is on a seperate worksheet and the customer lists are simelar. I need to compare the two lists - match up the numbers for each identical customer name and identify any rows that are on one month's report but not on another. Any...
  2. skygirl65

    opening multiple windows in IE 6

    I just got a new computer and it is configured to open only one IE window at a time. I can't find the setting to change that. If I have a web page open and I minimize it and click on IE, it closes the open page and navigates to the home page again.
  3. skygirl65

    Using a macro on someone elses computer

    I have an excel spreadsheet with a macro in it that my co-workers need to use. When I copy the spreadsheet to their computer and try to run the macro, I get the following error: "compile error - Named Argument not found. DataOption1:=x1SortNormal" What does this mean?
  4. skygirl65

    Sorting error

    I have spreadsheet with a macro that sorts it alphabetically at the end of the macro. After I made what I believed to be unrelated changes, now the sort does not recognize the headers. For example the lable "last name" is no longer in the header cell, but is replaced by the first entry...
  5. skygirl65

    Pause a Macro

    I have a simple macro in excel that I would like to change the date in the header before moving on... how do I tell the macro to pause and wait for me to type in the Month? I am VERY much a beginner in VBA.. so be gentle!
  6. skygirl65

    Pause Macro

    I have a simple macro in excel that I would like to change the date in the header before moving on... how do I tell the macro to pause and wait for me to type in the Month?
  7. skygirl65

    Giving Excel Macros to other people

    I have macros in my personal workbook that my co-workers need to use. we are not on a network. How can I copy them and e-mail them to someone else and how do they get it into their personal workbook?
  8. skygirl65

    COUNTA formula

    I am trying to count the number of dates in a calendar spreadsheet that have an entry in a certian place...The formula i am using is: "=COUNTA(D4,G4,J4,M4,P4,D11,G11,J11,M11,P11,D18,G18,J18,M18,P18,D25,G25,J25,M25,P25,D32,G32,J32,M32,P32)" It is not displaying as a formula,,, it shows the...
  9. skygirl65

    Copying Excel Macros

    I have several macros recorded in the personal.xls workbook on my laptop. I need to be able to copy those and give them to my team members. I keep having secrutity problems. What is the best way to do this?
  10. skygirl65

    Seperate two pieces of data in one cell

    I have a cell with date and time in it. How can I seperate that data into two cells?
  11. skygirl65

    Beginner looking for course, or book

    I am VERY much a beginner and would like to find some resource (class, book....) that would start at the beginning. I often record Macros in Excel, but I can't edit them in any way. Any suggestions for how to learn the basics?
  12. skygirl65

    Excel nuumber format with 10 digits

    I need excel to change the format of a series of number to always be 10 digits. Some are 8 some are 9, but I need to add 0, or 00 at the beginning so that all numbers will be 10 digits. Any Ideas?
  13. skygirl65

    Sending an excel macro to someone else

    I have my recorded macros saved in my personal workbook so that they will work with any open file. How can I send this macro to someone else that needs to use it? Thanks!
  14. skygirl65

    Excel Macro with variable field?

    I need to record a Macro in Excel that will stop and prompt me for the file name to open. I am not good with VBA, but I can record simple macros. (can't edit them after they are done) Can this be done?
  15. skygirl65

    Printing very large single powerpoint slide

    I have some posters that are all on one powerpoint slide. Every time I try to print it, I get about 1/6 of it because it prints out way to large. I've tried every way I know to resize it in the print option. Any ideas?
  16. skygirl65

    Excel Format every other line

    I have a spreadsheet that needs to have every other line shaded, like accounting paper to make it easier to read. Everytime I sort is by a different column, the shaded lines go with the data and it is no longer every other line. Any ideas?
  17. skygirl65

    XP home freezes on navigation

    I am running XP home and just updated to SP2. When navigating in windows explorer to save files, the system freezes. When I click on a folder or use the up arrow icon to navigate up the tree, the system was slowing wayyy down. I'd have to wait about 50 seconds for the selected file to show...
  18. skygirl65

    Power Point Design Template

    I have a design template from my company that I have to use for all presentaitons. It automatically makes every placeholder filled white with a black border around it. It's driving me crazy. I have to change it on every single placeholder in the entire presentaion. When I try to change it in...
  19. skygirl65

    Outlook connects sometimes.... sometimes not.

    I use outlook to access my company exchange server. I am using sonic wall VPN. It is VERY inconsistent. Sometimes I can connect right away, then for days on end I get the error message that the exchange server is not available... when it is. If I go in thru outlook web access, it's fine and...
  20. skygirl65

    conect to exchange server w outlook & Verizon air card

    I am using outlook 2003 and a VPN client to access company e-mail. If I access it thru a cable connection, or a wireless connection and my home wi-fi network, it works fine. I just got the Verizon "broadband" wireless card and it works great to accessing the internet, however, outlook will not...

Part and Inventory Search

Back
Top