## The discussions

### Help me to add particular cells

Solved

Hello, i want to sum particular cells when a number consists in a cell eg:- =IF(\$B\$81:\$BH\$81=7=TRUE,SUM(\$B\$77:\$BH\$77),0) it calculates a...

2 replies Last reply on 15 Dec 2014 by
mathew munna

### Download office 365

I would like to download office 365 how?

1 reply Last reply on 14 Dec 2014 by
xpcman

### Conditional formatting

Hello, I'm trying to create a table for a field trip. Essentially, I want the students name highlighted based on their homeroom teacher. There are...

1 reply Last reply on 13 Dec 2014 by
Mazzaropi

### Macro/command button help

Solved

Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...

12 replies Last reply on 13 Dec 2014 by
vcoolio

### Copy info from one excel sheet to another sheet

Solved

Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...

2 replies Last reply on 12 Dec 2014 by
sstanger

### To check first letters of two columns are equal

Hello, could you please tell me how to check whether first letters of two columns are equal

1 reply Last reply on 11 Dec 2014 by
TrowaD

### How to auto copy

Hello, My workbook contains about 1000 sales entries on sheet 1 . Some customers paid in full, but some other don`t. I will put a * beside the cus...

5 replies Last reply on 11 Dec 2014 by
TrowaD

### What type does it want? (vba question)

Solved

Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...

3 replies Last reply on 11 Dec 2014 by
TrowaD

### Comparing two columns

I have two columns both of which contain list of names.i want to get the output as true if the names are somewhat similar eg dane john and dwayne john...

4 replies Last reply on 11 Dec 2014 by
TrowaD

### Fix the last date

Hello, my target is 3900 but daily target is 50, how to fix last date for closing of my target. please define formula with examples Configurati...

1 reply Last reply on 9 Dec 2014 by
TrowaD

### Conditional formatting???

Hello, If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)... ...

1 reply Last reply on 9 Dec 2014 by
TrowaD

### Conditional formatting to hide 00:00 in column

Solved

Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...

4 replies Last reply on 8 Dec 2014 by
Sharky9000

### Coping & pasting data in first blank cell in same worksheet

Hello, I would like the vba code for a macro ( using a form button) that copies data from cell:M1 to A13:A30 depending on which is the first blan...

1 reply Last reply on 8 Dec 2014 by
TrowaD

### Conditional formatting based on checkbox

Hi, I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "...

1 reply Last reply on 8 Dec 2014 by
TrowaD

### Help me on this formula to shorten

Solved

Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...

5 replies Last reply on 6 Dec 2014 by
mathewmunna

### How to copy data from one spreadsheet to all others

Please, does anyone have a macro to copy data from a specific range on a standard sheet (ideally with formatting) to all but one other sheet active in...

3 replies Last reply on 6 Dec 2014 by
rizvisa1

### Copy data based upon cell value

Hello, Need help on copying data from file1.xlsx into multiple .xlsx file based upon column G values. The file1.xlsx contains... Column F Column...

6 replies Last reply on 6 Dec 2014 by
rizvisa1

### Excel macro for copy row to another workbook.

Hello, New-ish to excel and I'm helping improve systems at the work place. The issue is I want to be able to copy a row. e.g. | New | 12345...

1 reply Last reply on 5 Dec 2014 by
vcoolio

### Prefix 0 to all records in a column

Solved/Closed

Hello, I want to prefix 0(zero) to all records in a particular column of an excel sheet.Please let me know how to do it. Thanks for your time, Mano...

6 replies Last reply on 5 Dec 2014 by
Hassan

### Excel picture inserting macro help - urgent

Solved/Closed

Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro which ta...

25 replies Last reply on 4 Dec 2014 by
jackcluseau

### Change of password security notification

I established an @ live.com email account for a non-profit for which I volunteered. I will no longer be addressing the correspondence from this email...

1 reply Last reply on 4 Dec 2014 by
xpcman

### Conditional formatting on excel 2010

Hi, I am trying to figure out the correct method in which to apply a formula in conditional formatting. The first row contain the document names....

1 reply Last reply on 4 Dec 2014 by
TrowaD

### How autofill data from sheet1 to sheet2 in different order.

When we type numbers in any sequence in sheet1 but they out come countinusely in sorting sequence in sheet2

1 reply Last reply on 4 Dec 2014 by
TrowaD

### Multi percentage calculation

Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I attac...

4 replies Last reply on 4 Dec 2014 by
Winndixie

### How to count different charecters

Solved

Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...

5 replies Last reply on 4 Dec 2014 by
mathewmunna

### Pdf files into source safe seems to corrupt them

I have about 40 pdf files, that are accessed and viewed by the application. I am having a problem. Basically adobe reader displays a blank document. ...

1 reply Last reply on 2 Dec 2014 by
Ambucias

### Check if input number is minimum and display a pop up dialogue

Hi, I am novice VBA developer. I am trying to write a macro which does following. 1.When a user enter a particular value into cell 2.Check if ...

2 replies Last reply on 2 Dec 2014 by
Murali

### Change date format

Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007

1 reply Last reply on 2 Dec 2014 by
ac3mark

### For progress billing

Hello, how can i automatically know the percentage area of a accomplished tiles by simply counting the tiles Configuration: Windows / Chrome 3...

1 reply Last reply on 2 Dec 2014 by
ac3mark

### How can i transfer data from one spread sheet to another?

Solved

Hi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data ...

5 replies Last reply on 30 Nov 2014 by
elizatex23

### Finding data in different excel sheets with month-sort by vba?

Hello, I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a tabl...

2 replies Last reply on 29 Nov 2014 by
polarstorm

### Automatically moving rows from sheet 1 to sheet 2

My document has several sheets, but what I'd like to do is create a VBA to automatically move a row to sheet 1 from sheet 2 when I have selected 'Acti...

1 reply Last reply on 29 Nov 2014 by
vcoolio

### Repair corrupt excel file

I have an excel 2003 workbook that will not open. The file is huge. I have tried the repair utility within Excel but it still will not open. Has an...

1 reply Last reply on 29 Nov 2014 by
alvarsson52

### 2 macros in one sheet targeting same cells

Solved

This is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to automatically...

2 replies Last reply on 28 Nov 2014 by
chester4207

### Lock flag ignored:how is this possible?

Hello, Cells C4 and D4 are empty cells, and both are locked in Format Cells->Protection-> Locked. I go to Tools-> Protection-> Protect Workshee...

1 reply Last reply on 28 Nov 2014 by
rizvisa1

### Help me on this formula to shorten

Hello, please help me out to shorten this formula.. =IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="...

1 reply Last reply on 28 Nov 2014 by
Mazzaropi

### Copy rows from activesheet and create and paste in new sheet.

Hey guys I have a workbook with +-5000 rows of rooms in different buildings. I want use the column BUILDING_CODE and copy all the rooms that have ...

2 replies Last reply on 27 Nov 2014 by
heyxarno

### Conditional formating to check text in another shell + numeric

Solved

I have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition . 1....

3 replies Last reply on 27 Nov 2014 by
vcoolio

### How do i copy database information to excel?

How do i copy information from a database to an excel sheet?

2 replies Last reply on 26 Nov 2014 by
Mazzaropi

### Help me to count 2 cells

Solved

helo, please help me to count 2 celles A1 Is either 0 or 2, A2 is either 0 or 2 IF A1+A2=0 A3 should be 6, IF A1+A2=2 A3 Should be 3 if A1+A2...

2 replies Last reply on 26 Nov 2014 by
mathewmunna

### Lock cells in excel

Solved

After setting up VB to lock cells in Excel I now need to lock additional cells. I currently have the following script (kindly given by rizvisa1) which...

2 replies Last reply on 26 Nov 2014 by
MartynP

### Needs some help with a formula

Solved

Hello, Configuration: Windows XP / Firefox 33.0 Okay, here is a problem I've been dealing with for over an hour now. This should be easy, but ...

5 replies Last reply on 25 Nov 2014 by
dgcasey

### An outlook express store file is damaged.

Hello everyone. Can you help me! Whenever i open express outlook error is showing up and i cant receive or send mails. It's written that outlook expr...

1 reply Last reply on 25 Nov 2014 by
ac3mark

### Excel help with macro

I have an excel workbook with 4 Sheets. Sheet 1 (summary) is a ledger. Sheet 2 = Bob Sheet 3 = Bill Sheet 4 = Bart Column D in the ledger ...

7 replies Last reply on 24 Nov 2014 by
ac3mark

### Numbers & symbol ü (new challenge)

Solved

i need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1 Condition is H1 may contain any numbe...

5 replies Last reply on 23 Nov 2014 by
mathew

### Copy data on condition from one sheet to another

Hello, I have 15-16 sheets.. AND I ENTER data in sheet1 & sheet2 .. i want a code that can copy data from sheet1 / sheet2 to sheet3 or any other s...

1 reply Last reply on 22 Nov 2014 by
rizvisa1

### Message boxes

Hello everyone, Does anyone know if it is possible to format a basic message box (just font and colour)? Or is it a case of "what you see is what y...

2 replies Last reply on 22 Nov 2014 by
vcoolio

### Printing the same worksheet changing a cell with data populated

How do you print the same worksheet repeatedly, changing a cell with data populated from a table?

1 reply Last reply on 22 Nov 2014 by
rizvisa1

### Copy data from one sheet to other sheet.

Hi guys! I have a problem coping data from one row within a specific range, example A2, B2, C2, D2, E2 and so on up to P2, and copy that data to diffr...

1 reply Last reply on 22 Nov 2014 by
rizvisa1

### Excel auto create sheet and populate

Hey Everyone, I'm looking to create the following; I have a list of employees who will be working on an event. The event is broken up into stages,...

1 reply Last reply on 22 Nov 2014 by
rizvisa1
Results 3501 - 3550 out of a total of 12,262