**[Solved] IF Function Help Required** *Summary*: Hi, for my business website I am making a product import sheet. I Have a column for product category number with numbers ranging from 1-66 randomly de...

**Auto insert 'x' rows depending on value 'y'** *Summary*: Hi, I am currently using Excel 2003 but I am a beginner at using VB. What I am looking to do is either create a formula or macro, which ever is easie...

**[Solved] Need to recover lost Excel file!** *Summary*: Hi guys, I'm using Win98 and Microsoft Office 2003. I was working on an Excel spreadsheet and made stupid mistake, forgot to save it. So, is there an...

**[Solved] how to alphabetize data with more than 1 row in excel 2003** *Summary*: how to sort in alpha order in Excel 2003 a List of names in one column with their addresses in another column, and other data in other columns, total...

**[Solved] IF and AND in a range, Excel 2003** *Summary*: I am trying to define whether F10 is > E10. If it is and the cell below,F11 is less than E11 then 1 is the answer. It should only count if the equatio...

**Excel 2003, Windows 8.1, Canon MX860 Get a print to file** *Summary*: I had the same problem with Windows 8.1 Canon MX860, Excel 2003. All other programs seemed to print ok. Excel wanted to "print to file". I went ...

**[Solved] Excel 2003 How To Sum Monthly Data Each Quarter** *Summary*: hi,i need help with my spreadsheet,i need to do every month for 3 months then a quarterly one but when i go to the quarterly one it wont add up from t...

**[Solved] IF statement with 2 criteria** *Summary*: aNY hELP APPRICIATED, I WANT TO ACHIEVE AN ANSWER BASED ON THE INFORMATION FROM 2 OTHER CELLS IE. IF CELL A1 : A500 = "NORTH" AND CELL B1:B500 = "LTB...

**[Solved] Excel 2003 formula won't copy down a column correctly** *Summary*: Hi, I'm working on an Excel 2003 spreadsheet that looks at a list of outstanding jobs and compares with a wallplanner showing when maintenance is next...

**Macro To Open a File in Excel 2003** *Summary*: I am looking to write (or record preferably) a Macro where when I click on a button I create (let's say it's named "Open") a new worksheet is opened a...

**[Solved] My Office Excel is working abnormally.** *Summary*: My Office Excel 2003 is working abnormally. Every time i open an Excel file, a saved one or new one, Excel opens with another sheet which is in one of...

**entering data to excel 2003 in a1 and have data go to c1,the** *Summary*: make believe your writing checks and the amount is in D5,and you want the amount to go to G2,then you write another check and you want that amount to ...

**why cant i open xls with excel 2003** *Summary*: Good day I have Excel 2003 and it does not want to open .xls files. Is there a converter type software out there to solve this. Thank you ...

**Excel cann't complete the task with available resources** *Summary*: I am importing the data from one workbook (book1) to another (book2) in excel 2003 using a formula =[Book1.xls]Sheet1!$A$1 into cell B1 of book2 which...

**[Solved] Not sure how to write this formula.** *Summary*: If E2 has an "x", then show contents in d2, if not then multiply contents in d2 by 2.25 (micsoft excel 2003) ...

**Conditional Formatting in excel 2003** *Summary*: Hi, I need to write a macro that will fill in a row depending on one cell's value ie if Saturday or Sunday Highlight row blue I also need to highlight...

**VBSrcipt, to save a excel 2003 work book as a shared file ?** *Summary*: Description basically asks my question can it be done ? The reason is I get 7 to 10 sheets Dailey in CSV format and convert them to XLS (have vbs to ...

**replaced monitor, not Excel cell contents not visible** *Summary*: replaced monitor, now Excel cell contents not visible - but visible in a print screen, in formula bar, and once you scroll, it will show (for a while ...

**count no. of rows with multiple creteria in excel 2003** *Summary*: hello I have a sheet like A B C 12 3-jun-12 paper 23 10-jun-12 copy 14 ...

**[Solved] VBA Excel 2003 issue** *Summary*: Dim Start Dim Rowfrom Dim Rowto Dim S1 As String Dim S2 As String S1 = "Lifed Items" S2 = "ETI(SEI)" Start = "A4" Rowfrom = "B7" Rowto = "J7" Sheets(S...

**Need Macro Help to Look at Desktop for all *.CSV files** *Summary*: I created this Macro, but want to make a change but dont know how.. Hopefully someone can offer assitance. Question1. Instead of it looking for the f...

**[Solved] How to extract only similarly formatted data** *Summary*: I have an Excel spreadsheet challenge that I can use some help resolving. I have multiple rows of similar data within one cell where I need to extract...

**Double sets of formula** *Summary*: Hi guys, Shame, I used to be able to run rings around excel, seem to have forgotten it all now. Basically, I am making a spreadsheet displaying, in w...

**[Solved] Excel 03 - diff dropdown lists in single cell** *Summary*: I'm working in Excel 2003 and am trying to make Column B have different Data Validation drop-down lists based on the values from Column A. Example (al...

**Unable to read xls file** *Summary*: Hello, I have .xls file saved both on MS Office 2003 version, and 2007 compact mode. File size is 41 MB. Recently, I've received 'Not responding' erro...

**excel 2003 Conditional Formatting Help.** *Summary*: this is my situation. I have text in column A and B, I want to compare Column A against Column C, Like if A1 and C5 match, then in Column F, I would l...

**Copy row to another sheet if cell = x** *Summary*: Hi, I've looked around various forums but can't quite get code to work for what I want. I am using Excel 2003 to do risk assessments. Each risk has i...

**EXCEL 2003 Macro** *Summary*: I have a report that needs to do the following: insert a column in C do a vlokoup from another workbook in C sort entire workbook by those results in ...

**Cell Contents Based On Other Cells** *Summary*: Hello, I want to do the following: if i enter the word "pc" in column "a" then in column "b" the number "2" to appear. Given the fact that in other c...

**How do i highlight whether a date is upcoming** *Summary*: I have a spreadsheet with dates activites are due to be done. I am looking to have the dates occuring in the next 14 days to be highlighted green and ...