The discussions
Change a cell content according with the color of another cell
Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...
Pasting and deleting macro
Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...
Nestle fomula nightmare!!
Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...
Need help on excel macro
I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...
Edate in excel help
Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...
Excel for mac date formatting
Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...
Format excel data
Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...
Copy rows from one tab to another - if specific criteria in col
Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...
Formula
SolvedI need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
Help for time reminder in excel
Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...
Graduate number in a cell
Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...
Software for finanicial
how can i get a software for account system tally ,quickbook
Countif coloring of cells that were used.
Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...
I cant get rid of the false function
Hello, I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4))) It keeps saying false in the ce...
Microsoft word icon changed to unknown program
My Microsoft word (program) icon changed from the classic picture to the unknown programs icon. I am using windows 7 enterprise. Please help me how to...
Automatically copy contents from multiple shts to a summary sht.
Hello, I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all ...
Excel codes
Hello, I would like to be able to set up a spread sheet so when I type March on sheet1 in column A it copies the entire row onto sheet 2
Vba code
Hello, sir , i am trying to copy data from one row and paste that data into column of another sheet. this process is continuous till all row no...
Cell color count with a condition
Hello, I need a help. I need to count cells in a range having a specific color (In one column) & cells in a range having a text (In another co...
Conditional formatting based on two cell values
SolvedHi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...
Copying cond. format for entire row based on 1 cell to other row
SolvedI have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
Create separate worksheets/excel files
Hello, I need to create an excel file with the following I have a base file and a summary sheet I need to create separate sheets and rename them...
Macro to compare two excel file
Hi Team, I need excel macro to compare two excel file and highlight the difference in the respective cell with both the values in file 1 and 2 .
Drop down lists
SolvedHi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...
Excel combine worksheets into one
Newbie here, I have a question on how to do this in excel. I have lots of worksheets, 200+, each with different names, and I was wondering if its p...
Removing false value
SolvedHello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
Copy rows to other sheets based on value in column
SolvedAll, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...
Automatically save data to another excel sheet.
Hello, System Configuration: Windows / Chrome 57.0.2987.110 Please give me suggesstion & Advice to my query, Whenever I enter date in Ex...
Pdf file alwasy opening in word
SolvedHello, What to do to disable my attachment file in pdf to open in Word application?
How to calculate values using countif
I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...
Trying to create a multi-column formula.
SolvedHello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
Two excel sheets copy new data input on one sheet to new row on
Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...
Need to extract data from a column to another worksheet.
Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...
Excel problem
SolvedHello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
Recover user id of irctc
SolvedHello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101
Help with index match or vlookup
Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...
Password detail
how can i get the password of ms word installed in my system it keeps telling requesting for password dont know how to go about it can someone please ...
Excel find word in series of cells and add
SolvedHello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...
Highlight one value in a dropdown menu of three responses
SolvedHello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
Create new excel files based on the data in a column
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
Code to move rows into another sheet based on certain values
SolvedI'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
Count only cells containing 2 given words
Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...
My document was in pdf when i was trying to convert to word it b
Hello, my document was in pdf when i was trying to convert to word it became unreadable what can i do ? in Windows 7 System Configuration: Windows ...
Cell to populate if other column has any text
Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...
Change cell text based on another cell's color
Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...
Insert picture in excel macro which takes the file name refrence
Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...
Formula for text in a cell and then total the amount on text
Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...
Change value of subsequent cells once a condition is met
The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...
Vba to automatically insert subtotals in multiple worksheets
Good Day, I hope somebody can help me, I have an workbook with a main sheet ""2017 Sales" and 10 worksheets with the name of each individual sales Age...
Open workbook using following code
Private Sub CommandButton1_Click() Workbooks("Patch.xlsm").Activate Sheets("Site Name").Select S = Range("A1:A2") D = Range("B1:B2") E = Range("B...
