Office Software Forum
- Excel (9,723)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (173)
- Word (2,181)
-
If formula [Closed]
This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...
-
details to another worksheet fr main worksheet using macro [Closed]
Hi, I trying to input my project data into my Master list. When we won or lost the project, the data will auto disappear and transfer to the Won list ...
-
Date not showing up as a date??? [Closed]
Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...
-
Ms. [Closed]
working with several worksheets in one notebook, how do I get amounts from sheet 1 plus sheet 2 plus sheet 3 etc. to total to the final total sheet? ...
-
Conditional Formating [Closed]
I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...
-
Macros code [Closed]
My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...
-
Exchange inbox repair tool [Solved/Closed]
Hello, I have Exchange 2010 server that is being used to temporarily hold mailboxes. After a reboot the .edb file went from 276gb to 0kb. Of cour...
-
Macro for transferring data from one excel to different excel [Closed]
Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...
-
Looking for help with a macro/vba for find/copy/paste [Closed]
I have a lot of data in column A of a spread sheet. I would like to "search" for part of a string, and then copy the row of the cell with this data in...
-
Enter current time in a cell by clicking it [Closed]
Hello, I followed the instructions and it works great. My problem is how do you turn it off with out deleting the visual basic entry? AJ Co...
-
If function date problem [Closed]
Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...
-
Comparing two lists of names in Excel and then sorting them [Closed]
Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...
-
Can I accomplish this with Conditional Formatting or another way [Closed]
Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...
-
excel [Closed]
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
-
removing false in excel [Solved/Closed]
=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!
-
VBA UDF for Color [Closed]
Hello, I'm sure my question is simple to most of you as I'm new to UDF. I've created the following UDF but cannot apply it across columns when I us...
-
Increment a cell value - conditions applied [Solved/Closed]
Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...
-
Michelle [Closed]
Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...
-
want to copy sheet1 data to sheet2 [Closed]
Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...
-
Apply a negative until 0 is reached in Excel [Closed]
I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...
-
How to merge the data from 2 different sheets into 1? [Closed]
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...
-
Rating from Parameter Lookup [Solved/Closed]
Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...
-
Free Publisher [Closed]
During installation the message for product key appears and the text is in French, even though it says English on the webpage which has the downloade ...
-
Nesting if() functions? [Solved/Closed]
Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...
-
Excel macro create new sheet copy & paste cells [Closed]
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
-
i'm not able to send emails [Closed]
Hello, i use bsnl broadband at home. should i reconfigure my account settings to send emails if my broadband provider initially was different from...
-
Word & Excel error [Closed]
Hello, In my system some of word & Excel file automatically renamed as some other format (Eg: SUPPORT.XLSX.gsjwsuk). If am open through again ...
-
automiatic email [Closed]
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
-
outlook e mails [Closed]
Hello, Cannot send messages but receive. Get message when sending. 0x80042109 Thank you Adriaan Configuration: Windows / Mozilla 11.0
-
I'd like to change a PDF file to word, excel and PowerPoint [Closed]
To whom it may concern I'd like to change a PDF document to excel, word and power point. Please help me soon as this is as a matter of urgency. ...
-
Number of Days between 2 dates [Closed]
Hello, i am trying to calculate the number of days between 2 dates i,e 09/08/1965-05/02/2007= 41 years and 181 days which is 15146 days Whe...
-
transfer data [Closed]
I am working on a spreadsheet and I need to transfer the ending balance on one page to beginning balance on another page, for the entire tenant list. ...
-
Copy data from one workbook to another workbook using vba [Closed]
Hello, Good Afternoon, I need some help to be able to complete the below task. I need to be able to copy data for 2 different tabs in an wo...
-
Outlook e mail problems [Closed]
I have a problem with my outlook e mail. Cannot send mails but receive mails. I receive the following message: 0x80042109
-
HELP HELP HELP Excel Formula [Closed]
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
-
Due Date Reminder With An Email to the filtered list [Closed]
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
-
Why dbx files do not opened [Solved/Closed]
As soon as I have not tried to open the file through Outlook. Out - walked into account. Downloaded the new version - nothing helped. Outlook does not...
-
Change date format using Excel Macro [Closed]
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
-
Comparing Excel sheets with only a few overlapping records [Closed]
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
-
Mtch formula required [Closed]
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
-
How to make a cell flash using Excel 2011 for Mac [Closed]
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
-
Find, copy, create a row under, paste, loop. [Closed]
Hello, I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like). What it sho...
-
Excel - Merge several worksheets into a single one [Closed]
I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge all these...
-
Major problems images into Word [Closed]
Hi all, At the moment I am having major issues with inserted images into word. Background: it concerns my PhD thesis of about 140 pages. In this do...
-
Cannot open PDF while Word docume [Closed]
Hi all, I have a problem with opening PDF files. If Word is closed, no problem. When Word is open and I click on a PDF file, it opens the document ...
-
I am looking for Outlook Express fix tool [Solved/Closed]
Hello everyone...How can i restore damaged .DBX file of OE? I am not able to see the mails. My 4 Gb data in inbox.dbx is corrupted of .dbx files by u...
-
Replace cell content in Excel 2007 [Closed]
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
-
macros or vba for data validation [Closed]
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
-
1 time data entry [Solved/Closed]
Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...
-
Add an X to cell if other conditions met [Closed]
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
