The discussions

How to view pst files damaged ?

Hello, Sit the second day of being connected Autluk 2010 Old pstshnik from other computer. Pst weighs 38 gigs. Take it with yesterday's 14 with a br...

1 reply Last reply on 10 Jul 2015 by
janhonover

Macro that copies a worksheet, renames it and copies data

I am trying to create a macro that when I select an option from the dropdown list in cell E3 it creates a copy of another sheet in the workbook. ...

1 reply Last reply on 9 Jul 2015 by
TrowaD

Transfer data and then apply formula

 Solved

Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...

3 replies Last reply on 9 Jul 2015 by
Hydro

Copy formulas across workbook

 Solved/Closed

Hello, I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. Can ...

9 replies Last reply on 8 Jul 2015 by
1234551

Outlook 2007 gets hung.

Hello, We have a small office with 5 users, all using Office & Outlook 2007 on Win7 PCs. At various times, we all seem to encounter the same proble...

8 replies Last reply on 8 Jul 2015 by
ghayden

Cannot open the files in ms word from mail attachment

i bought a new PC and cannot open the file attachment from my mail inbox. so please kindly need your help. thankyou

1 reply Last reply on 8 Jul 2015 by
Computertech

Command button (vba) to update a record.

Hello, I have created a userform for searching & adding records to a worksheet, but as I am completely new to VBA I am stuck. I wish to create a bu...

5 replies Last reply on 8 Jul 2015 by
iceberg51

Convert date into words(english) in excel 2003 or 2007

Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Twenty Tw...

1 reply Last reply on 7 Jul 2015 by
xpcman

Macro to copy/paste specific range every 3 rows

 Solved

Hello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...

2 replies Last reply on 7 Jul 2015 by
Isa

Need urgently to find a macro in excel report across sheets

 Solved

Hi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...

6 replies Last reply on 7 Jul 2015 by
moisdois

Change cell by clicking on another cell

Hello, I'm looking for a Macro/Formula to change value of a cell to (the row of the original cell I click on - 2). Is this possible? Cheers al...

5 replies Last reply on 7 Jul 2015 by
TrowaD

Excel challenging - please help

Good Day Everyone. I'm stuck on the below situation and your help will be much appreciated. Let's call as: Worksheet] 1: WorkSheet]...

4 replies Last reply on 6 Jul 2015 by
gutoazuk

"no user access" to word 2007 docs????

Hello, Running word 2007 on windows vista....after I wrote my docs and saved them to the desktop, I am no longer able to go back and open them up ...

3 replies Last reply on 5 Jul 2015 by
Ambucias

Conditional formatting based on another cell

Hello, I'm trying to make a budget spreadsheet and want to format the cells if there is an omission. If a value has been entered into cell C3 ...

1 reply Last reply on 4 Jul 2015 by
Mazzaropi

Word 2010 shows it is a dot.com file for some reason

Hello, I created a word doc and see the file, but when I try to open it, it comes up as a blank doc with no name. In the file listing, I see the file ...

1 reply Last reply on 4 Jul 2015 by
Ambucias

Need automatically changed amount percentage.

Hello, I need to help to ms excel sheet PERCENTAGE% 0.25 ENTER AMOUNT PERCENTAGE% 25,000.00 AUMATICALLY CHANGE 300000 AUMATI...

1 reply Last reply on 3 Jul 2015 by
Mazzaropi

Count if rows contains specific year

Hello, I need to count how many rows contains a date with a specific year, but with the following doesn't work: =COUNT.IF(D3:D3394;"*2014") I cha...

1 reply Last reply on 3 Jul 2015 by
Mazzaropi

Microsoft office word 2007 picture paste bug *same picture repea

I have found this BUG in Micrososft Word 2007, that I consider to be a SERIOUS ISSUE for Microsoft Office Suite. If you copy an image from a websi...

1 reply Last reply on 2 Jul 2015 by
ac3mark

Search string and copy row to another sheet

Hello, I am trying to use a macro which will look for a value in workbook1's column A and on finding that value, it will copy that whole row onto ...

1 reply Last reply on 2 Jul 2015 by
TrowaD

Insert a row after "," in a cell

Hello, I have a 2 columns such as below: Name Rules John T3456,T4567,T6799 Cersei T5643,T4532 I would like to have a macro that...

1 reply Last reply on 2 Jul 2015 by
TrowaD

Checkbox

I'm trying to use an Excel worksheet to take attendance. I've been able to find a solution using Apple's Numbers, but not so with Excel. Any ideas?

1 reply Last reply on 2 Jul 2015 by
TrowaD

How to convert number to word in excel using formula

Hello, HOW TO CONVERT NUMBER TO WORD IN EXCEL USING FORMULA Configuration: Windows 7 / Chrome 43.0.2357.130

1 reply Last reply on 2 Jul 2015 by
TrowaD

Copying text to different sheets based on criteria

Hello, I have a large speradsheet that records activity. I want to copy a row of items from one sheet to another if the status is 'done'. The if...

2 replies Last reply on 2 Jul 2015 by
Ronster444

Apply a number to differentiate cells with same value

Hello, Can someone help me please? Here is my issue. So I have a long list of memberships. The issue I have is that I have one primary member that ...

1 reply Last reply on 1 Jul 2015 by
xpcman

How to convert date into words(english) in excel 2003 or 2007

Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Tho...

2 replies Last reply on 30 Jun 2015 by
sankar

Create multiple workbooks in a particular format from a table

Hi, I want to create a macro wherein I can create multiple workbooks in a particular format from the data from a master table in a excel workbook. ...

1 reply Last reply on 30 Jun 2015 by
TrowaD

Error trying to populate new worksheet using macro

 Solved

Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...

2 replies Last reply on 30 Jun 2015 by
AmitMehta96

Add string only if a text is present in a cell

 Solved

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

6 replies Last reply on 30 Jun 2015 by
Deloro

Copy cell from another sheet where cell is value...?

 Solved

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

2 replies Last reply on 30 Jun 2015 by
wzshop

Macro for filling data from specific cell to another

 Solved

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

4 replies Last reply on 30 Jun 2015 by
kayuf

Complicated if/then copy operation?

if (column range; eg, A8:A42) has any value, then Copy a cell (formula; in C2) two columns to the right of every cell in that column (A) that has a va...

3 replies Last reply on 29 Jun 2015 by
Seth

Rows and columns

Hello, I have the ffg problem, i have a table as below: PN H1 H2 H3 H4 A AB AC AD AE B AB AD C AC AE D AB AC AE and I want it t...

1 reply Last reply on 29 Jun 2015 by
TrowaD

Nesting if formula problem

Hello, I'm trying to set up a worksheet for student participation grades. Once I arrive at a participation average, I'd like to have a formula to...

1 reply Last reply on 29 Jun 2015 by
venkat1926

Corrupt outlook 2007 pst file

I am using Outlook 2007 on a Windows 7 system. Yesterday I needed to restore the system drive from a previous drive image, so I saved my Outlook pers...

1 reply Last reply on 28 Jun 2015 by
Ambucias

Error: embedded excel spreadsheet

 Solved/Closed

Occasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...

1 reply Last reply on 28 Jun 2015 by
MatthewBon

Lost basic11n.msi

 Solved

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

6 replies Last reply on 27 Jun 2015 by
nuryev

Excel -formula that excludes names if other colums have info

Hello, I have a list of 50 names in Column F, I used the Coutif formula to tally the total names in colum Q:5. ex. =COUNTIFS(F3:F1436,"=bill*"...

3 replies Last reply on 27 Jun 2015 by
venkat1926

Need to recover a pst file having a password.

 Solved

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

3 replies Last reply on 26 Jun 2015 by
r.doyle31

Excel formulae - returning a zero value

Hello, I'm trying to set up an excel quotation sheet using the following formulae =SUM(B6*C6)+(D6*$E$3/1000) Cell E6 = the quantity Cell B6...

1 reply Last reply on 26 Jun 2015 by
Mazzaropi

Add entries from a template to a masterlist

Hello, I have a excel template scorecard which I would like the answers from certain cells to record entries from the scorecard to a separate exce...

34 replies Last reply on 26 Jun 2015 by
vcoolio

Email... outlook issues

Hello, I have just found out that a heap of my sent emails, have not actually been sent. They show in the sent box as having gone through ok. Also, ...

1 reply Last reply on 26 Jun 2015 by
Ambucias

Master sheet to work sheets

I have an education master template and many other exact duplicate worksheets in a workbook. Each of the other worksheets is differentiated only by th...

22 replies Last reply on 26 Jun 2015 by
vcoolio

Format cell

Hello, Can someone please help. Is there a formula to highlight a cell in a row in column P if it is not equal to the same row in column C. I wo...

1 reply Last reply on 25 Jun 2015 by
Mazzaropi

Transferring data automatically in same worksheet excel

 Solved

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

1 reply Last reply on 25 Jun 2015 by
TrowaD

Send email from different account

Hello, So i have the following: Outlook.com email address work email address Microsoft Outlook I have set up my work email address to auto...

1 reply Last reply on 24 Jun 2015 by
Computertech

Conditional formatting

Hello, I have created an excel database with all of the football games I have been too. In one column I have the home score and the next the away sc...

1 reply Last reply on 24 Jun 2015 by
Mazzaropi

In one cell more value and another cell less value i need to com

Hello, in one cell more value and another cell less value i need to come automatically higher value in that particular cell if there is formula li...

1 reply Last reply on 24 Jun 2015 by
Mazzaropi

Rupees into words

Hello, PLEASE CONVERT MY INDIAN RUPEESINTO WORDS RS 10423859/-

1 reply Last reply on 24 Jun 2015 by
Computertech

Need value as per given criteria

 Solved

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

6 replies Last reply on 23 Jun 2015 by
Mazzaropi

If then formula with date

I have a spreadsheet that is tracking when a task is completed in Column C and then generating the next due by date in the next row column A so you kn...

3 replies Last reply on 23 Jun 2015 by
TrowaD
Results 2951 - 3000 out of a total of 12,260