The discussions

Please help resolve this

Hello, =IF(B1=Sheet2!A1,C1=Sheet2!B1) i have a cell in sheet 1 need to write the price from sheet 2 when I put a certain text in sheet 1 Conf...

4 replies Last reply on 11 Apr 2015 by
vcoolio

Can not open any documents in word

Hello, I would like to open files and not able to open in MS Word Configuration: Windows / Chrome 41.0.2272.118

1 reply Last reply on 10 Apr 2015 by
xpcman

Macro for deleting everyother six rows starting with row 7.

Hello, I am trying to use the macro function to delete six rows, skip six row, then delete six and so on. Can you help me? Configuration: Windo...

1 reply Last reply on 9 Apr 2015 by
TrowaD

Microsoft outlook pst file cannot repair

Experts, I have a user, who has left the company, however the manager of the department needs to view this user's outlook pst file. The pst file i...

1 reply Last reply on 9 Apr 2015 by
Computertech

Conditional formart

Hello, i have like four colums like below Name Age DOB Status AAA 23 XXXX Active BBB 25 xxxx ...

1 reply Last reply on 9 Apr 2015 by
venkat1926

Input repetetive data

Hello, I have to input 100 + truck weights, number plates, ticket nrs and loading times. I was wondering if any one had an easy to use template ...

1 reply Last reply on 8 Apr 2015 by
MaxStart

What cell is my data coming from?

 Solved

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

4 replies Last reply on 8 Apr 2015 by
BrianGreen

Complicatied find and copy cells to new sheet macro help

Hi I am new to excel macros and trying to sort out a large sporting club file. Basically what I want to do is copy all player information from team "X...

1 reply Last reply on 7 Apr 2015 by
MaxStart

Conditional formatting with dates

I am trying to fill cells in a column which contain a date that has already passed. I go to 'Conditional Formatting', choose 'Manage Rules' and click...

1 reply Last reply on 7 Apr 2015 by
MaxStart

Conditional formula - what if

I need to create a what if statement for a workbook. Example below... here's what I need, if Column B has the words "Left Blank" I need for it to ...

1 reply Last reply on 7 Apr 2015 by
MaxStart

Set up a count loop

Hello, How do i set up a count loop Configuration: Windows 7 / Chrome 41.0.2272.118

2 replies Last reply on 7 Apr 2015 by
TrowaD

About comments.

Hello, I have a data in A1 cell and certain information of this data is in other sheet. Now i need a pop-up comments when mouse just moves near...

3 replies Last reply on 7 Apr 2015 by
TrowaD

Transferring information from previous spreadsheet

 Solved

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

17 replies Last reply on 7 Apr 2015 by
skreechy

Excel- a macro to copy data from one sheet to another

Hello, Could anyone help me with this. I am trying to write a macro with following criteria. 1. Every week a set of data is entered into she...

1 reply Last reply on 7 Apr 2015 by
vcoolio

How do i resolve file corruption errors in powerpoint 2010?

 Solved

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

3 replies Last reply on 6 Apr 2015 by
montesquinto

Single quote - excel 2007

 Solved

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

8 replies Last reply on 6 Apr 2015 by
FLAWLESSVW

Conditional formatting based on expiration dates

 Solved

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

2 replies Last reply on 6 Apr 2015 by
BC

How to convert ost file to pst file?

 Closed

Hello, We only have the OST file and no longer the PST file for outlook 2007 application. Can you please send me some easy to use and reliable sugg...

1 reply Last reply on 5 Apr 2015 by
stefanobolivar

Two criteria to check if a date in excel

 Solved

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

13 replies Last reply on 5 Apr 2015 by
vcoolio

Formula to add big number of day to date in excel sheet

 Solved

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

3 replies Last reply on 4 Apr 2015 by
mgkimmel

Using the last few characters on a different sheet

 Solved

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

2 replies Last reply on 3 Apr 2015 by
BrianGreen

How can data automatically go into a calendar created on excel?

Hello, I created a calendar on excel to collect past, present and future data but I wish to run it automatically. I know how to link data from on...

1 reply Last reply on 3 Apr 2015 by
RayH

Excel question

Hello, I am looking for a formula for excel: I have three tabs, how to make one cell automatically return to "1" within the first tab; and the cel...

1 reply Last reply on 3 Apr 2015 by
RayH

Conditional formating

I have a spread sheet with 2 columns; In column 1(one) I am tracking Employees. in column 2 (two), I track the employees position. When a position i...

3 replies Last reply on 3 Apr 2015 by
RayH

Vlookup won't work

 Solved

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

2 replies Last reply on 2 Apr 2015 by
Cookie5

Adding one day to a date

Hello, I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too,...

1 reply Last reply on 1 Apr 2015 by
tripped

Error message when sending an email to a specific address

Hello, When I send an email to a couple of addresses, from Outlook, I receive the following message: "Delivery to the following recipients was abo...

5 replies Last reply on 1 Apr 2015 by
Ambucias

With the help of name we can get the data one sheet to another

Hello, with the help of name we can get the data one sheet to another sheet in excel in pdf Configuration: Windows XP / Firefox 12.0

1 reply Last reply on 31 Mar 2015 by
TrowaD

Please help, counta and countif same formula

Hello, Please help me, I am trying to accomplish is this: I would like to count the text in Range (B1:b5) excluding duplicates, however only i...

1 reply Last reply on 31 Mar 2015 by
TrowaD

Autogenerate worksheets from a list of names... adding names?

Hi, I'm trying to auto-generate worksheet from a list of names. Reading other questions in the forum I found the solution for this questions. But I ...

1 reply Last reply on 30 Mar 2015 by
TrowaD

Not showing save as dialogue box.

I am an office assistant. Every time I have to spell the numbers in words. I got a solution from net that a function can be added to the function libr...

1 reply Last reply on 30 Mar 2015 by
TrowaD

Set cell value

 Solved

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

1 reply Last reply on 28 Mar 2015 by
MaxStart

Vba copy sheet to new excel file + automated manual data entry

 Solved

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

4 replies Last reply on 28 Mar 2015 by
MaxStart

Ms office 2010 save as message shows

Hello, When working on a network shared file in MS Office 2010 , file opens quickly but when saving file shows Saving as massage comes & takes 40-50...

1 reply Last reply on 27 Mar 2015 by
Ambucias

Excel formula

 Solved

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

4 replies Last reply on 27 Mar 2015 by
Nic

I need a macro that can extract data

Hello, I need help with creating a macro that can automatically copy data from different worksheets and put it into a master worksheet for a repor...

26 replies Last reply on 26 Mar 2015 by
vcoolio

Recover deleted emails in outlook express...

 Solved/Closed

Hi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...

2 replies Last reply on 26 Mar 2015 by
joseph.robinson

Code visual basic

 Solved

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

2 replies Last reply on 26 Mar 2015 by
mcculloch1dj

Compare range of cells and get the result of a third cell

Hello, i have a file with 3 columns, i need to compare each cell of the first 2 columns and of it match print the data that in the third column th...

1 reply Last reply on 26 Mar 2015 by
TrowaD

Copying a conditional format to other cells...

Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....

1 reply Last reply on 26 Mar 2015 by
TrowaD

Excell 2013 - conditional formatting using a formula- apply rule

 Solved

Hello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...

2 replies Last reply on 26 Mar 2015 by
Manos

Excel formula display in cell

 Solved

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

6 replies Last reply on 25 Mar 2015 by
rc

About open office

Hello! How I,m donwloading full version Open office

1 reply Last reply on 25 Mar 2015 by
xpcman

Gorandhaka

Hello, i want to open new account Configuration: Windows 7 / Chrome 41.0.2272.101

1 reply Last reply on 25 Mar 2015 by
BunoCS

Day of week and date in same cell, autofill rest of month?

Hello, Is it possible to put day of week and date in the same cell in Excel 2004, and then autofill down for the rest of the month? I have tried ...

1 reply Last reply on 25 Mar 2015 by
venkat1926

How to open a prn file in office/word 2010

 Solved/Closed

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

10 replies Last reply on 25 Mar 2015 by
Aduka

Macro code to copy and past in new sheet last row of data

Hello, I'm trying to write a simple macro to copy in one sheet a selected amount of column data (which varies by size each time) and then paste the...

1 reply Last reply on 24 Mar 2015 by
vcoolio

Convert to mm/dd/yy to dd/mm/yyy

Hello, Pls help how to change mm/dd/yyy to dd/mm/yy in excel. Configuration: Windows / Chrome 41.0.2272.101

1 reply Last reply on 24 Mar 2015 by
TrowaD

Day of week and date in the same cell, then autofill rest of mon

Hello, I would like to know how to put the weekday and date into one cell, as in: Wednesday, 4/1. Then I want autofill to fill the rest of ...

1 reply Last reply on 24 Mar 2015 by
TrowaD

Find and replace a specific number

Hi All, I am new to this, so I hope somebody can help. I have a code CF|0612|1-12 in cell A1. That code is the code for an apartment block we...

1 reply Last reply on 24 Mar 2015 by
TrowaD
Results 3151 - 3200 out of a total of 12,258