The discussions
Add string only if a text is present in a cell
SolvedHello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...
Copy cell from another sheet where cell is value...?
SolvedHi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...
Macro for filling data from specific cell to another
SolvedHi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...
Error: embedded excel spreadsheet
Solved/ClosedOccasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...
Lost basic11n.msi
SolvedHello, I cannot open MS Office Basic Edition 2003. I keep getting a message that says, "Missing BASIC11N.MSI file" I am missing the installer file. ...
Need to recover a pst file having a password.
SolvedHello, I am in need of a soft utility which can be used to change/ recover the password set on a pst file in outlook. I have a user who has forgo...
Transferring data automatically in same worksheet excel
SolvedHello, I'm finding a difficulty in transferring data from a number of cells to a table automatically. What I'm trying to accomplish here is that w...
Need value as per given criteria
SolvedHello, There is a range given on one column and on the other column there are points. Ex: 200 - 180. 10 points 179 - 160. 9.5 points 159...
Adobe reader could not open because it is either not a supported
SolvedHI i HAVE WINDOWS 7 AND WINDOWS XP AT OFFICE while opening one PDF file I am getting this error messege. Adobe Reader could not open because it is e...
If formula for a range almost works, except with blank cells
SolvedApologies 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.
SolvedInstalled 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
SolvedHello, 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
SolvedHello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
If condition formula required
SolvedHello, 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
SolvedHi 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
SolvedHello, 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/ClosedHello, 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
SolvedHi 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/ClosedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedI 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
SolvedHello 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
Solvedhello, 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
Solvedi 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
SolvedI 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,...
Copy certain cells when an option is selected
SolvedHello, 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.
SolvedHi, 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?
SolvedI 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
SolvedHello, 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
SolvedHello, 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
SolvedMy 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.
SolvedHello, 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
SolvedHello, 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
SolvedLooking 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
SolvedHello, 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
SolvedHello, 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/ClosedHello, 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..
SolvedHello, 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
SolvedHello, 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"
SolvedHello, 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
SolvedFor 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
SolvedHello, 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
SolvedPlease 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.
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedWhen 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/Closedhas 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...