Summary: Using Excel 2003 - I do not have any experience writing macros. Tried it on my own and now have a pop-up window everytime I open the excel file, even ...
Summary: I have an Excel spreadsheet that I need help with a macro. I don't know much about VB scripting but I'm sure there must be a way to do what I want. ...
Summary: Hi all, I need help with an excel macro problem. I am creating what I thought was a simple scheduling macro. Basically I need to take batch residence ...
Summary: Hi, I need to use Excel to make an ordering system but I need help with it. The problem is that there are plenty of books out there that could help bu...
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: Thank you for your post and helping me with my worksheet. I have tried your formula. It works if the total payment(s) received are less than the total...
Summary: I have a worksheet with a summary page and a detail page. The IF statement is in one cell on the Summary page =IF(Detail!H6="Voided",-Detail!D6,0)and ...
Summary: Hello, OS:WINXP/Office2000 I have an excel sheet with 5419 rows and the column E has numbers that increases after certain rows. Eg: All rows from row ...
Summary: I'm working on a Macro, and have 2 problems that I can't solve with my limited knowledge of DBA. 1) Is there anyway to have a macro open all files in ...
Summary: Hello I am looking for help, I am trying to figure out a way in Microsoft Excel that I can create a macro that would look at all the text in column A ...
Summary: May I suggest that you make a copy of your current workbook before trying this procedure. I'd hate to have you lose all of your data if this doesn't w...
Summary: Hello. Grateful for any help with the following task (I'm using Excel 2003). I have 1200+ individual workbooks each containing two worksheets. The w...
Summary: Hi All, With MS Word my VB macros are available in all my documents, not true with Excel Workbooks. Is there a way to make my Excel VB macros availabl...
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 new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 i...
Summary: Ive got like 2000 numbers in 2 columns in Excel, and in each of these columns there are duplicate numbers. For Example: In column A there is a number ...
Summary: Hi, I've got a horrible problem with my Excel macro. When I my macro reads a value from a cell containing e.g. 1.33, he reads 1.38! The type of variab...
Summary: Hello I have made a macro and want it to be more general,so that I can apply it with any .log test file delivered by a audio ripping program. I want a...
Summary: I have an xls file with alot of client info. One of the fields is a 2 char country field. I have another xls file that has the two char xls files in o...
Summary: I am hoping someone can help me create an excel formula. Column C is the result of column A time Column B. If the resulting value in Column C is les...
Summary: I am trying to do some excel spreadsheet design that is a bit over my head. Say you have columns A, B, C, and D. In columns B thru D, you have X's mar...
Summary: We are writing a web application and have around 1500 excel sheets that all have macros that tie them together, we would like to be able to put them o...
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: I have a 100 different catagories in one collumn and I want an Excel macro to generate a abbreviation for each different catagorie in another collumn ...