The discussions
Conditional formatting based on another cell
SolvedHello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...
Conditional formatting based on another cell
Solvedi want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible...
Excel: merge adjacent rows if they contain the same values
ClosedHello all, I am trying to speed up a task which I have do it manually with VBA: There is a table like below" Date;Name;ID;Text 20120...
Color cell
please help me how to apply colors in cell using with formula..
Problem in excl
=IF(Y9="adgaon kh","channi",IF(Y9="ambasi","channi",IF(Y9="changefal","channi",IF(Y9="channi","channi",IF(Y9="charangaon","channi",IF(Y9="chatari","ch...
Converting multiple rows to one with multiple colums
Hello everyone, Can anyone help me with converting the below example of data in Excel Many thanks in advance.
Help me to add particular cells
SolvedHello, 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...
Download office 365
I would like to download office 365 how?
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...
Macro/command button help
SolvedHello, 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...
Copy info from one excel sheet to another sheet
SolvedHello, 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 ...
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
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...
What type does it want? (vba question)
SolvedHello, 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 ...
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...
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...
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)... ...
Conditional formatting to hide 00:00 in column
SolvedHello, 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...
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...
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 "...
Help me on this formula to shorten
SolvedHello, 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...
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...
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...
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...
Prefix 0 to all records in a column
Solved/ClosedHello, 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...
Excel picture inserting macro help - urgent
Solved/ClosedDear 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...
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...
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....
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
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...
How to count different charecters
SolvedHello, 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...
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. ...
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 ...
Change date format
Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007
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...
How can i transfer data from one spread sheet to another?
SolvedHi, 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 ...
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...
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...
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...
2 macros in one sheet targeting same cells
SolvedThis 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...
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...
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="...
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 ...
Conditional formating to check text in another shell + numeric
SolvedI 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....
How do i copy database information to excel?
How do i copy information from a database to an excel sheet?
Help me to count 2 cells
Solvedhelo, 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...
Lock cells in excel
SolvedAfter 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...
Needs some help with a formula
SolvedHello, 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 ...
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...
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 ...
