Office Software Forum - solved topics
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
help me to count 2 cells Solved/Closed
helo, please help me to count 2 celles A1 Is either 0 or 2, A2 is either 0 or 2 IF A1+A2=0 A3 should be 6, IF A1+A2=2 A3 Should be 3 if A1+A2...
-
lock cells in Excel Solved/Closed
After setting up VB to lock cells in Excel I now need to lock additional cells. I currently have the following script (kindly given by rizvisa1) which...
-
Needs some help with a formula Solved/Closed
Hello, Configuration: Windows XP / Firefox 33.0 Okay, here is a problem I've been dealing with for over an hour now. This should be easy, but ...
-
Numbers & Symbol ü (New Challenge) Solved/Closed
i need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1 Condition is H1 may contain any numbe...
-
Lock cell in Excel worksheet with VB Solved/Closed
I have an worksheet that I need to lock the cell based on the value of another cell. I have managed to create VB which will do this for one row but n...
-
Insert Multi Rows Between Existing Data Solved/Closed
Hello, I am trying to create a macro that will insert a set amount of blank rows into a existing spreadsheet after each entry. The amount of rows ...
-
Copy and insert rows and number of times Solved/Closed
Hello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row. Example: Bef...
-
IF function formula based on three possible values from adjacent Solved/Closed
Good morning all, Excel 2007 - I need a formula based on the three possible values from an adjacent cell. 1st value: : if F5 is a date, a simpl...
-
Conditional Formatting - highlight overdue dates Solved/Closed
I am a beginner with conditional formatting and researching the net for an answer has left me more confused than when I began! I am working with Ex...
-
Auto Filter depending on Cell Value Solved/Closed
Hello, I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7). Column 1 (A8:A200) is the accounts numbe...
-
How to find out the data in six month record Solved/Closed
Hello, I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has joined?...
-
Corrupt Pptx files. Need to repair them. Please help! Solved/Closed
Hey guys, there is big mess over here. Here I quote: I made some presentation files for promoting our new business. I showed them to my boss. She wa...
-
Nested if then Solved/Closed
Hello, I would like to have the contents of b1 displayed in m2 if t2=1, the contents of b2 displayed in m2 if t2=2, the contents of c1 displayed in...
-
Lost password to PST file Solved/Closed
Hi, I had a .pst file with a password set on MS Outlook 2010. Now I can't remember what the password is. How can I get back my emails? Thanks.
-
How to format cells based on the text in another cell Solved/Closed
Help me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to...
-
Insert/Remove photos depending up on ref. cell value changing Solved/Closed
Hello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...
-
Excel VBA copy and paste loop with logic condition Solved/Closed
Hi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...
-
Excel workbook with two sheets Solved/Closed
Hi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...
-
Auto Transfer of a filtered item to a different sheet. Solved/Closed
Hello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...
-
Can't send email in Outlook 7. Solved/Closed
I have Outlook7. I can receive email with no problem, however, I can't send email. Anyone know a sure fix to this? I use pop and smtp. Thanks.
-
Excel 2007 Using vlookup function in VBA Solved/Closed
I have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...
-
Text String count within a Cell Solved/Closed
Hello, I have number of records (see below) and want to know if I can use a function to count the number of records that contain a specific te...
-
format a cell with a comment based on a comment in another cell Solved/Closed
Hi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2 will...
-
Macro to copy paste without having all the source books opened Solved/Closed
Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated. I...
-
how to convert Date to word in excel Solved/Closed
how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two
-
Automatically transfer data from one sheet to another Solved/Closed
Hello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1 and ...
-
Calculate Total Total Hours Per Client Solved/Closed
Hi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates ...
-
How to count date cells for monday of this week Solved/Closed
Hello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined...
-
Auto generate the seller sales report Solved/Closed
Hi! I create a sales report and I set up total 6 worksheet Worksheet 1 I named it Price list ... is a Data for my sales report. and I set a co...
-
Formula to increment date by seven days. Solved/Closed
Hello Everyone, In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after the ...
-
Automatically transfering rows from one sheet to another Solved/Closed
Hi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract Sta...
-
IF function with Date addition Solved/Closed
Hello, I'm having trouble finding an answer as to how I can add 5 more days in my condition. I have 4 columns: one for an Order date (A2)...
-
Dealing with 'Today()' formula in Excel VBA code Solved/Closed
Hi Everyone, I have this VBA code in a Excel sheet (specifically in the Module) which does the following: - finds the empty cell in range "B:B" -...
-
Excel > Macro for Defined Range Dates Solved/Closed
Hello, I've a question that I have starting date in Column "E3" Sheet 1 and ending date in Column "F3" Sheet 1. I want a macro that insert dates i...
-
How to copy data based on criteria met Solved/Closed
Help! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...
-
Having problems with Office Word 2010 can someone help? Solved/Closed
Hello, I had to re-download Microsoft Office Home and Student 2010. Now whenever I save a Word document I winds up saving it as a WordPad document....
-
Excel 2010 VBA Date Formula Solved/Closed
Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...
-
Copy values in row to columns in spaces Solved/Closed
Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...
-
Conditional Formatting Solved/Closed
Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...
-
Specific data from one worbook to another (Excel 2010). Solved/Closed
Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...
-
excel 2007 custom filter problem Solved/Closed
Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...
-
Microsoft Office product key Solved/Closed
what is the product key of the app i downloaded?
-
time calculation Solved/Closed
Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...
-
formula that i can get a total for D7, if D7= D4 + (C6*D7) Solved/Closed
$1,613.00 (Cell D4) (C6) Hours ___ $175.00 (D6) TOTAL (D7) Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C...
-
If -Then formula needed please... before I head to the roof Solved/Closed
Using Excel 2007, I need a formula to do the following: if the date shown in a cell is 1/31/14, display 'monthly activity - january, or if the date...
-
Extraction of Excel data by using an Excel column parameter Solved/Closed
Hi, I have a problem in extracting information from an Excel Sheet 1 (entire database), by using an Excel column parameter (Model No) in Sheet 2. S...
-
Excel Golf Skins Sheet Solved/Closed
I need a micro that will highlight the cell with the lowest unique value in each individual column. It would not highlight anything if there were m...
-
How to get free microsoft office? Solved/Closed
How to get free microsoft office?
-
VB script to notify/popup Solved/Closed
I was having a difficulty in notifying my co-worker to print all the sheets on a workbook. I a thinking if it's possible to have an pop-up message to ...
-
lookuk a value in 2 columns and get value of third (help) Solved/Closed
Hello, I have a question I need to lookup a value of col A1 of sheet 1 in col A of sheet 2 and if it matches it gets the corresponding value ...
