The discussions

Generating alphanumeric code

Sir, Can anybody help me in writing vba code for excel to generate alphanumeric code having first entry as L,P,G,T(based on a condition), next four...

Last reply on 13 Jul 2015 by
TrowaD

Download windows office onto my i pad

Hi can i download windows office onto my I PAD

Last reply on 13 Jul 2015 by
Ambucias

Select portable office excel as a default program to open a file

Hi, I have Portable Office (excel & word) in "C/Program files" of my laptop. I also have a *.xls file in my desktop. I'm trying to choose a default...

Last reply on 13 Jul 2015 by
Me

Formula - if c2 is not blank, and b2 is blank, then copy c2 to

 Solved

Hi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...

Last reply on 12 Jul 2015 by
Eirualmac

Forgot privacy lock password

Hello, Can you please help me? The oroblem is that I forgot my password. How could I retrive my password somehow? Thankyou in advance.

Last reply on 11 Jul 2015 by
Ambucias

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Last reply on 24 Jun 2015 by
Computertech
Results 2951 - 3000 out of a total of 12,264