The discussions

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 ...

3 replies Last reply on 3 Jun 2015 by
Mazzaropi

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...

1 reply Last reply on 2 Jun 2015 by
TrowaD

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...

1 reply Last reply on 2 Jun 2015 by
TrowaD

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...

1 reply Last reply on 1 Jun 2015 by
TrowaD

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...

1 reply Last reply on 1 Jun 2015 by
TrowaD

Copy specific cells to separate worksheets upon 2 conditions

 Solved

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...

3 replies Last reply on 1 Jun 2015 by
vcoolio

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 ...

2 replies Last reply on 1 Jun 2015 by
angieanguk

Corrupt powerpoint file recovery

 Closed

Are 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...

Last reply on 1 Jun 2015 by
Alice_Phoebe

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...

2 replies Last reply on 31 May 2015 by
kc_74074

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

1 reply Last reply on 30 May 2015 by
Ambucias

Powerpoint 2003 corrupt problem

 Closed

How 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.?

Last reply on 29 May 2015 by
judepate

Adobe reader error message at opening .pdf file

 Solved

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...

2 replies Last reply on 29 May 2015 by
caseysutton

Pdf file not open

 Solved

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 ...

2 replies Last reply on 29 May 2015 by
conorrose

Outlook archive file not opening

 Solved

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,...

2 replies Last reply on 29 May 2015 by
jaycehead

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...

2 replies Last reply on 28 May 2015 by
Sunny

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 /...

1 reply Last reply on 28 May 2015 by
TrowaD

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...

1 reply Last reply on 28 May 2015 by
TrowaD

Copy certain cells when an option is selected

 Solved

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...

14 replies Last reply on 27 May 2015 by
vcoolio

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...

1 reply Last reply on 27 May 2015 by
ProblemMe1

Arrow key now working.

 Solved

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?

2 replies Last reply on 26 May 2015 by
belle07

How i can open damaged pdf files?

 Solved

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 ...

2 replies Last reply on 25 May 2015 by
HaSw8

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...

1 reply Last reply on 25 May 2015 by
vcoolio

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...

1 reply Last reply on 23 May 2015 by
Ambucias

Date format

 Solved

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...

2 replies Last reply on 23 May 2015 by
Mazzaropi

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...

1 reply Last reply on 23 May 2015 by
InformatiWeb

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 ...

1 reply Last reply on 23 May 2015 by
InformatiWeb

Help to insert a date using a macro in excel

 Solved

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...

3 replies Last reply on 22 May 2015 by
Matt

Outlook 2007 corrupted .pst

 Solved

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...

2 replies Last reply on 20 May 2015 by
MalcolmHop

How to hide and unhide tabs according to cell criteria.

 Solved

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...

1 reply Last reply on 20 May 2015 by
vcoolio

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...

1 reply Last reply on 20 May 2015 by
vcoolio

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...

2 replies Last reply on 20 May 2015 by
mathewmunna

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...

1 reply Last reply on 19 May 2015 by
TrowaD

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...

1 reply Last reply on 19 May 2015 by
TrowaD

Convert number to word in excel

Hello, please suggest me the way to convert number to word

1 reply Last reply on 19 May 2015 by
Computertech

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 ...

1 reply Last reply on 19 May 2015 by
vcoolio

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...

1 reply Last reply on 19 May 2015 by
linomileto3

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

2 replies Last reply on 17 May 2015 by
eladeb

Excel vba format a range borders to crossed diagonal lines

 Solved

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...

4 replies Last reply on 17 May 2015 by
MaxStart

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...

1 reply Last reply on 17 May 2015 by
vcoolio

Change numeric to word in excel

how to change numeric to word in excel

1 reply Last reply on 16 May 2015 by
Computertech

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...

1 reply Last reply on 15 May 2015 by
ac3mark

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...

1 reply Last reply on 15 May 2015 by
ac3mark

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...

1 reply Last reply on 15 May 2015 by
ac3mark

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...

1 reply Last reply on 15 May 2015 by
MaxStart

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...

1 reply Last reply on 14 May 2015 by
vcoolio

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

3 replies Last reply on 12 May 2015 by
ac3mark

Outlook 2007 data file repeatedly corrupt

 Solved

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, ...

1 reply Last reply on 12 May 2015 by
cyrilcrozier

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 ...

3 replies Last reply on 12 May 2015 by
TrowaD

How restore outlook address book?

 Closed

i 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 ...

Last reply on 11 May 2015 by
brito9112

Macros, button that copies data from certain cells into table

Hello, I am trying to create a "database" table on one sheet to record data that was calculated on another sheet. The issue is the data calculated...

1 reply Last reply on 11 May 2015 by
vcoolio
Results 3051 - 3100 out of a total of 12,268