The discussions
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...
Macro for blanks
SolvedHello, 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...
Recover corrupted outlook express folders
SolvedI 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
SolvedHello, 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?
SolvedOh 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
SolvedHi 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?
SolvedDear 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...
Single quote - excel 2007
SolvedHi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...
Conditional formatting based on expiration dates
SolvedHello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...
Two criteria to check if a date in excel
SolvedDespite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...
Formula to add big number of day to date in excel sheet
SolvedDear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...
Using the last few characters on a different sheet
SolvedHi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...
Vlookup won't work
SolvedI am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...
Set cell value
SolvedHello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...
Vba copy sheet to new excel file + automated manual data entry
SolvedConfiguration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...
Excel formula
Solvedhello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...
Recover deleted emails in outlook express...
Solved/ClosedHi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...
Code visual basic
SolvedHello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...
Excell 2013 - conditional formatting using a formula- apply rule
SolvedHello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...
Excel formula display in cell
SolvedHello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...
How to open a prn file in office/word 2010
Solved/ClosedHello, How do you open a PRN file to see how it converted? I only want to open the document to see how it converted, not print it. I used Window...
Some cell date could not change
SolvedHello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0
Comparing data in 3 columns on a microsoft excel spreadsheet
SolvedWould be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...
Excel 2013 formula - maybe if formula?
SolvedI have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...
Wordnum help needed
SolvedHello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...
Cell format
SolvedHi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...
Text-to-text equals number
SolvedHi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...
Formula, blank cell
SolvedSorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...
Convert date into words(english) in excel 2003, 2007 or 2010
SolvedHello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...
Conditional formating is applied based on date in two cells
SolvedHi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...
Excel - help please! drop down and data filling
SolvedGood morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...
Trying to have the current date go into one cell (a1)
SolvedHello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...
A strange range question ...
SolvedHi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...
Adding a loop to macro to insert pictures
SolvedHello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
Change calculated to a hard date
SolvedI used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...
Recovering missing emails by restoring outlook identity from tim
Solvedhad a problem with Outlook 2011 client - emails went missing and not in deleted / purged folders if i restore outlook identity from a date i know h...
Problem recovering deleted item in outlook 2010
SolvedI try to open deleted item recovery in Outlook 2010 and attempts to recover any message and receives the following error message: "Outlook was unable ...
Opening ost files with outlook 2013
Solved/ClosedHow can one open existing ost files in Outlook 2013? I tried but I get a message that it is not an Outlook Data file.
Winxp outlook express lost inbox
SolvedI STILL HAVE ALL MY SENT ITEMS BUT ONLY SOME ITEMS FROM 2006 LEFT IN MY INBOX' PLEASE HELP.
Transferring numbers to new worksheet automatically
SolvedHello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...
Macro to create tabs and populate from other worksheets
SolvedI already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...
How to transfer lines of txt from one sheet to another sheet?
SolvedHello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
Computer show me the error message. (.pst file)
SolvedHello, After restore the .pst file back to hard disk, the computer show me the error message. How can i repair this file? Please help Best regards....
How to restore the telephone book from the wab file?
SolvedHow to restore the telephone book from the wab file? There is a file .wab, by the file size can be seen that the contacts are there but when opening ...
