Office Software Forum - solved topics
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
excel is automatically changing dates to a numeric code Solved/Closed
Hello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...
-
Protecting your formulas in multiple worksheets Solved/Closed
Hello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...
-
Fix The Code Solved/Closed
Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
-
Date format changes when editing it Solved/Closed
Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
-
Copying entries from multiple sheets to new sheet, then summing Solved/Closed
I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...
-
Merge two macros of 2 diffrent workbooks Solved/Closed
Hello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...
-
Remove or Clear Data Solved/Closed
Hello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...
-
Multiple If in Data Validation Solved/Closed
Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
-
Conditional copy of cells with corresponding values Solved/Closed
I have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...
-
Count formula (need help) Solved/Closed
Hello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...
-
Using IF function with dates Solved/Closed
Hello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...
-
Macros editing Solved/Closed
Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...
-
refer only one column from named range Solved/Closed
Hello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
-
Lookup Relevant Value from table Solved/Closed
Hello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...
-
Copying dates in Excel Solved/Closed
Hello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...
-
How can I restore corrupt .edb? Solved/Closed
Hello, I have an exchange server with a .edb that is in a dirty shutdown state. I have 2 storage groups. The second storage group will not mount d...
-
have changed shortcut Solved/Closed
now i can not open microsoft excel 2013
-
If statement Solved/Closed
Hi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...
-
Copy data from 1 workbook to another based on sheet tabs Solved/Closed
Good day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
-
Link data from one cell to another Solved/Closed
Hello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
-
Excel:Print one enlarged page to multiple pages Solved/Closed
Hello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101
-
Entering current time in specific cells Solved/Closed
Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...
-
Comparing Two Columns With other two columns in excel 2003 Solved/Closed
Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...
-
Excel - shortcut key for print view Solved/Closed
Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5
-
create worksheets with names from a list Solved/Closed
Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...
-
file attachment Solved/Closed
Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...
-
check info on two different cells... Solved/Closed
Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...
-
Allow rules wizard to work without Exchange Server? Solved/Closed
Hello, I no longer work for the company that had the Exchange server and I have my personal pop3 email coming into Outlook. When I try to use th...
-
auto transfer data as i marked Solved/Closed
Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
-
IF formula error: False Solved/Closed
Hello, I'm trying to get one of three answers to show up in my excel document. Currently I have: ==IF(((J43/I43)*100)>=81,"APPROVED")&IF(OR((J43...
-
Counting action under condition of theyr value, and month when.. Solved/Closed
Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
-
@if formula Solved/Closed
Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
-
conditional Formating a column Solved/Closed
Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
-
Copy cells based on conditions Solved/Closed
Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
-
Copying data from workbook to workbook using button Solved/Closed
Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
-
Change color to different cells based on another cells text. Solved/Closed
Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
-
Copy row and insert n times Solved/Closed
Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...
-
Compare two worksheets and Remove duplicated data from one Solved/Closed
Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
-
Search for matches from columns on separate sheets. Solved/Closed
Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
-
How To Copy Data Between Several Sheets on VBA Solved/Closed
Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
-
values from one workbook to another Solved/Closed
Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
-
i am unable to send out Hotmail from MS Outlook Solved/Closed
Hello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...
-
Giving false with certain answers Solved/Closed
Hello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...
-
Range of cells depending on a condition. Solved/Closed
Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...
-
Outlook Express emails disappeared - can I get them back? Solved/Closed
A user opens his Outlook Express 6 (all windows updates up to date) this morning and finds that his inbox is empty. 200-odd messages that were there ...
-
match cells in excel with all characters same except one Solved/Closed
Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...
-
Auto populate rows from master sheet to other sheets Excel 2013 Solved/Closed
Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...
-
script which can check if a debit has a corresponding credit Solved/Closed
Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...
-
IF functions with dates Solved/Closed
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
-
Excel - Compare data in two worksheets Solved/Closed
Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...