The discussions
How to match 2 lists to get the unique entries
I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...
Calculate formula based on values for two dates
Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...
Conditional formatting help
Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...
Combining rows
Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...
Conditional formatting based on range ofcells in different sheet
Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...
Replacing a value using lookup table
Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...
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...
Check if cells are blank or zero help please
I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...
Corrupt powerpoint file recovery
ClosedAre there any tools available to recover a corrupted PowerPoint file? My wife had spent about a week putting one together and (luckily) when done pres...
Help creating an automated sheet
I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I w...
How to recover my email
Hello, How to Reinstall my outlook & how to Recover my Emails Please Urgent Rply Thanks Configuration: Windows XP / Firefox 38.0
Powerpoint 2003 corrupt problem
ClosedHow do I repair a PPT file that has the error message: The file may be corrupt, in use, or of a type not recognized by PowerPoint.?
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,...
Based on date copy data and move total net down
How to move total net etc down based on the data filled above based on date If guest stay 2nd night second night data must me filled below first...
Change the cell color if the text in cell changes
Hello, How do I conditionally format in excel (i.e. change the cell color if the text in cell changes?) Thanks, JC Configuration: Windows 7 /...
Give a text cell a percentage value
hello everyone; i am doing an evaluation report (checklist) and the output will be used as values for evaluate the service itself, soi created a sele...
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...
Ms office icon problem,
Hello, I have some problem with MS-Office Icon, word, excel, powerpoint all are in same icon, i m using win 8 and office13. so how to do this in w...
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 ...
Single cell in my "work area" tab to be copied to a cell in the
Hello, I believe this is somewhat easy/straightforward but I don't know how to handle. I have a work book with multiple tabs. One of the tabs (spr...
Unable to send mail from gmail id to yahoo.
Hello sir/madam, i have my gmail ***@***, i m unable to send mail from gmail id to Yahoo. can u please help me..... reply ***@*** Configurati...
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...
Emails have stopped coming through after my account was hacked.
Hello, My emails have stopped coming through to my tablet. There is a lot of bubbling sound which I do not understand. Configuration: iPhone...
Repair microsoft outlook
some how lost a file that causes this to not open after computer being on for a while. If i restart computer it works. I do not have the micro office ...
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...
Vba
Hello. Asking for anyone who could please help me. I am an Environmental Science major with only one basic computer class from 2001. I have 2 major pr...
How to import a range of cells from a different worksheet
Hello, Please help me to import a range of cells depend on the output cells generated on different worksheets on a page-2(in my folder the differe...
Data consolidation
Hi Team I have a set of data in Sheet 1 ( Data vs value ) . I want to consolidate the value according to its data in the same sheet. This can be d...
Letters and numbers
Hello, Could someone please help. Is there a formula to convert A12812001 into 5/8/2015. A =2015 and 128 = the day. The rest of the numbers do...
Convert number to word in excel
Hello, please suggest me the way to convert number to word
How do i populate worksheet tabs via a formula or macros?
Hello, I have a list of fifty different names I need to enter on the tabs of 50 worksheets (all on the same workbook). Is there a macros formula ...
Problem with outlook express.
Hello, I am using Outlook Express and when im trying to send emails i get this error: "An unknown error has occurred. Account: 'Scoil Eimear', Ser...
Change yyyymmdd format to mm/dd/yy in excel
Kindly give me guide to solve the change yyyymmdd format to mm/dd/yy in excel Santosh Mane
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...
How can i pull multiple information from a data sheet
Hello, I have a data sheet with hundreds of Packaged Products that have specific items in each one, and what I am trying to do is on another sh...
Change numeric to word in excel
how to change numeric to word in excel
Copying or importing large documents from ms word to corel draw
Pls I am presently trying to copy a large document from Ms word to Corel draw...pls how do I copy it in the fastest way possible..? Thanks and God ble...
Date format
Hello, I am using office 2013. However for some data dump I am getting date format for dates between 1to12 , however for dates 13 onwards it turne...
Moving the shape
Hello, i'm trying to moving the shape to page number 2 ,,, how i can do it ? my code is Option Explicit Sub Document_Open() Applicat...
Copying conditional formatting to other rows automatically?
Hi folks, Could somebody good with excel please have a look: I have a problem. I want to color the whole row with conditional formatting. For e...
How to get multiple tables from sheet 1 and transfer to another
Hello, i am trying to transfer data from one sheet to another. i have drivers so i want each initial to have its own table. can someone help me with t...
Its about excel macros
Hello, I need to saveas some excel cell range as text file how to do it Any help will be appreciated Thanks in advance
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, ...
Compare two excel sheets in the same workbook
Guys ! I need your expert advise .I'm working on a crusie ship and at the moment I'm trying to compare 2 voyages (Passenger Lists) which has the same ...
How restore outlook address book?
Closedi have taken an image backup of my PC, and formated it. re-installed the windows and all the other applications. now i'm trying to restore some data ...
