Excel 2003 Related Problems & Solutions

44 tags
Refine Tags

Start a discussion

Results 1 - 30 of 44
[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 ...

12


Ask Question