Summary: Please i need some excel expert to help solve this spreadsheet. I'ved tried solving the problem but I'm not sure if i got it right so need some compar...
Summary: I am assuming that you are getting a dialog box telling you that the workbook contains macros. If you "tried" to write the macro, then you probably ha...
Summary: I would like to ask is there a GoalSeek function that is in Ms Excell found in Visual Basic.Net ? Does VB.Net have such a function ? I would like some...
Summary: I have tried to format the lines to add all the times together. When doing so I am getting an error that I am unable to resolve. I then have tried to ...
Summary: Hey, I am working on a quick spreadsheet for reporting for work, and everything works fine, except for 1 sheet, which i'm not sure how to do it! I'm n...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...
Summary: I'm a basic Excel user, but need help with a weird application. For Excel 2007, I want to build a cell with mult-colored dots (wingding character) ba...
Summary: I have a database that is 600 MB (139,000 columns), and need to open it in Excel. Will it bomb and crash my puter ? How should I go about doing it? An...
Summary: I am facing a major problem in excel. For the past few days whenever I run my spreadsheets I get the following message Application exception occurred:...
Summary: hello.is there any way i can scan a plain text document to my computer.then open it in excel,and configure it to be in an .xls format.which will allow...
Summary: Hi Guys, I know this is simple, but I'm very new to the MS office environment. Does someone know what I would do to add duplicate rows in excel based ...
Summary: I m facing a problem and I am bounded to work in excel: Hope u all will help me after reading the following situation. Let me discuss it in detail: I ...
Summary: Thank you very much for your comments, they are really helpful. But I want the result to appear in the same cell for year to date. For example: THIS...
Summary: The only way I've achieved this is: You have Excel create a text file (containing your net send) which it saves as a ".bat" and then Shells the ".bat"...
Summary: ok... once again i need some help...darn vba got me again...this time what i am looking for is i track certian stats at work such as how long each emp...
Summary: Excel Formula help I am trying to create a spread sheet for Employees ID with their names. 1) I am creating "sheet1" for New Employees and have to all...
Summary: I need to write a macro in excel 2007 to generate an summary , as in Summary is a different sheet in my workbook there are 2 in total. In the first sh...
Summary: ok, so im basicly trying to come up with a formula which takes information from lets say Cell A1 and Cell B1 and then Cell 4A will decide how much i c...
Summary: Silly me. Nowhere in the code was copy or paste. :) I see the "=" in the For Next loop. I just don't know the syntax to VB well at all. I can sort...
Summary: I have an Excel sheet that has over 1900 addresses in single column. I need them in Excel spread over 3 multiple Columns (Company, Street, City/ST/Zi...
Summary: Hi, Please help me in comparing dates in Excel. Let the cells have dates as given below... A2 = 10-Jan-2009 B2 = 20-Feb-2009 C2 = 30-Mar-2009....
Summary: I need to input a negative time value into a time formatted cell in excel. I have a cutom cell format: [hh]:mm;[Red] -[hh]:mm This works perfectly for...