Recent content by skygirl65

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...

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.

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?

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...

I need to be able to enter the month myself.... Thanks

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!

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 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?

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...

It's not quite that simple. I have reset the security to low and am still having the problem. what is the best way to copy macros? Should I copy the whole Personal.xls file? Rename it?

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?

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

Thanks so much.. sorry about the search.. I don't seem to ever come up with anything even remotly like what I'm searching for. I did try, but got all kinds of unrelated stuff.

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?

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?