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