Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
IF formula for a range almost works, except with blank cells Solved/Closed
Apologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
-
Offline address book help for exchange 2007. Solved/Closed
Installed new copy of Exchange 2007. Keep getting following message: Offline address book definition is missing. Need help with this issue. Thanks.
-
Cannot browse - ftp ok, email ok, ping ok Solved/Closed
Hello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
-
Date format Solved/Closed
Hello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
-
if condition formula required Solved/Closed
Hello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
-
Excel Consolidation Tab Solved/Closed
Hi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
-
If cell A1 has text then cell B2 has today's Date Solved/Closed
Hello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
-
Excel - Repeat rows a specified number of times Solved/Closed
Hello, I'm aware of the post here https://ccm.net/apps-sites/software/1603-how-to-repeat-rows-a-specified-number-of-times-on-excel/ But I wo...
-
how to repeat rows by x number of times Solved/Closed
Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...
-
How to Repair Large Outlook 2007 PST on Windows 7 Solved/Closed
Hello, User running Windows 7, with Outlook 2007, 20 GB PST. User has two email account, 1 may be an IMAP, 1 may be POP, or both can be POP (I'l...
-
ROUNDING FUNCTION Solved/Closed
Hello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
-
VBA to refresh all pivot tables Solved/Closed
Hello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
-
Macro to add/remove rows based on highest # in group of cells Solved/Closed
I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
-
Copy specific cells to separate worksheets upon 2 conditions Solved/Closed
Hello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
-
adobe reader error message at opening .pdf file Solved/Closed
hello, I open my big .pdf file and Adobe Reader says: "The File is Corrupted or damaged hence cannot be opened". How to overcome such error mess...
-
PDF file not open Solved/Closed
i am getting the following error message when I open the pdffile "Adobe Reader could not open 'xxxx.pdf' because it is either not a supported file ...
-
Outlook archive file not opening Solved/Closed
I have Outlook 2007 which has a 4Gb archive pst file stored on a file server, there are other archive pst's that I can open but this one wont,...
-
problem with macro Solved/Closed
Hello, I have problem with macro. if I delet on of the samples data, the 4 parameters value (a,b,c ,d)will change while is 4 parameters based on the...
-
Copy certain cells when an option is selected Solved/Closed
Hello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...
-
Arrow key now working. Solved/Closed
Hi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?
-
How I Can Open Damaged Pdf Files? Solved/Closed
I have an issue with trying to open old PDF files in Adobe Reader 9 Standard. The files were created in 2000 and they need to be retrieved to be put ...
-
date format Solved/Closed
Hello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...
-
Help to insert a date using a macro in excel Solved/Closed
Hello, I have a spread sheet with four tabs. I have written a macro to copy the tabs and rename them but I need to be able change the date which u...
-
outlook 2007 corrupted .pst Solved/Closed
My Outlook 2007 cant open .pst file. IT appears file was corrupted. I ran scanpst, but it couldnt solve the issue. Does anyone know third party sof...
-
How to Hide and Unhide tabs according to cell criteria. Solved/Closed
Hello, I have an Invoice that has a Rent To Own Sheet and also an Order Form attached to it. On my the Order Form tab I have a data validation...
-
Excel VBA Format a Range Borders to Crossed diagonal lines Solved/Closed
Hello, please help me to format a range of cells like if in a range a1:c10 if any cell eg: c1 contains a value c then format diagonal lines wit...
-
Outlook 2007 data file repeatedly corrupt Solved/Closed
Looking for possible causes for corruption. Window 7 32 bit all updates, Office 2007 SP2 and all updates, POP3 mail account, 5.68 GB pst file, ...
-
Conditional Formatting: 3 range of numbers Solved/Closed
Hello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...
-
Reformatting a Date in Excel Solved/Closed
Hello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...
-
get a percentage in microsoft excel Solved/Closed
Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...
-
How to use name range..Please help to solve this issue.. Solved/Closed
Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...
-
Exam layout help Solved/Closed
Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...
-
Conditional formatting cell if every cell contains "YES" Solved/Closed
Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...
-
Compare 2 Sheets -> Summary differences Solved/Closed
For an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...
-
Conditional Formatting for a particular column Solved/Closed
Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...
-
copy & Paste based on specific condition Solved/Closed
Please provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...
-
How to search for a value in a range if found run a procedure. Solved/Closed
Hello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...
-
finding a date (N30) in a date range B5:B30 and returning A3text Solved/Closed
Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...
-
Auto. copy a row of data onto another sheet using conditions Solved/Closed
Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...
-
Macro to Search for a word and put a code on the cell next to it Solved/Closed
Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...
-
Can't open scanned document when broken up into 2 PDF's Solved/Closed
When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...
-
repair outlook express dbx file Solved/Closed
has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...
-
Macro for blanks Solved/Closed
Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...
-
sum if Solved/Closed
Hello, Pls help me find the formula for below situation I am trying to sum up 4 when a cell in the Column A contains End with XX7. Otherwise it...
-
Date of birth in words Solved
Hello, How can I enter date of birth in words in Excel?
-
recover corrupted outlook express folders Solved/Closed
I accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...
-
transfer data from one sheet to another automatically Solved/Closed
Hello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...
-
What cell is my data coming from? Solved/Closed
Oh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...
-
Transferring information from previous spreadsheet Solved/Closed
Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...
-
How do I resolve file corruption errors in powerpoint 2010? Solved/Closed
Dear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...
