The discussions
Macro code
Hi there. So I have a question. I want to create a macro that makes uses the list of name in cells B6:B60, E6:E60, B66:B119, and F6:F74 to make a tab ...
Compare two columns input value from another
SolvedHello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...
Highlight cell if another cell contains any text
SolvedHello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...
Microsoft outlook microsoft exchange is unavailable
Hello, I could not open Microsoft outlook at all, the error message a following: The connection to Microsoft exchange is unavailable. Outlook mu...
Help! my ms word icon has changed
Hi. I hope you can help me. About a week ago my Word doc icons suddenly changed on documents that I created or edited. Once edited or created, they ...
Excel help please
Ok here's what I want to accomplish. I want to be able to type the name of a medication: and the formulations automatically appear in the rows foll...
Auto row copy to another worksheet
I'm new to excel and need to set up a simple double entry bookkeeping system in excel. I need to know what formula to put into a cell to accomplish t...
Assign numerical value to cell based on text in another cell
Hello, I'm trying to solve an issue... Column A cells have a drop down which has 4 text options to choose from: Tier 1 Tier 2 Tier 3 Tier 4 ...
Cant figure out a formula
Hello, I need help figuring out a formula that will if two cells values match then the data in selected rows will go to one if that makes sense......
Microsoft outlook app
Hello, I am looking to see how I can stop my outlook app from syncing when on holiday, evenings, weekends etc. I have looked at help online bu...
How to save next data entry in next target range
Hello, I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click sav...
Create a macro which monitors the cell "c1" to be changed to "a"
Hello, I hope someone can assist with this In my workbook; I have two worksheets labeled "log" and "master" I want to create a macro which monitor...
Auto add or subtract between two cells
Hello, This is probably a very simple question. I am trying to auto add or subtract between two cells. example: if B1 is greater or less t...
Excel vba: application.filesearch error in running excel 2013
SolvedHello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...
Percentage
Hello, how do I figure out the mark up percentage when I have the cost and sell price. cost Q2 1.14 sell P2 8.04 what's the per...
How to stop rows underneath being affected by a filter
Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more row...
Simple multiplication gives wrong result
Hello, I am raja, In my excel 2010 when i am trying to multiply two cells of values 743.91 & 0.87 , the result is as given 646.88. But the actual...
Column with dates not sorting/formating
Hello, a column with dates is not sorting nor formatting. I have tried to do the suggested answer on the forum but to no avail. This is driving me cra...
Copy paste special into last row of another worksheet
SolvedHello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...
How to create student exams record and printout using ms excel
I wish to design student exams records using MS Excel afterward, I should be able to pull records of student using Matric_No and then print out the st...
Letter writing and printing
I downloaded this programme on the understanding it was a free version of Microsoft word but I don't see where to start a letter for printing ??
Multiple query in once button in same sheet
Hello all, I have created two separate queries in excel VBA. I have given two different buttons for both queries and both are running successfully...
Transfer names from general sheet to separate other sheets
Hello, So i have 3 separate sheets, the first is a general info sheet with names and other information on it, names are in column A. Each name is ...
Help for creating a macro
Hi all. I'm here to ask for ypur help. I want to create a macro, that opens a dialog box and leting you browse your computer and open a new excel file...
Complex nested if formula help...
Hi, I'm new to this excel lark, i rather like it but am stuck, please can you wise people help me... heres a pic of what I'm working on... s...
Show calculation on the first of the month
Hello, I have created a spreadsheet with various calculations. I have it divided as monthly items, however, I prefer that a certain calculation o...
Account formulas
Hello, i am raja, i am working on milk processing excel sheet(it contains parts annexure II to annexure X) to start new business. anyone can help m...
If statement that adds 1 for specific text
Hello, I have a spreadsheet that I have a column (I2-I48) that contains text for different ticket types. I am trying to create a formula that give...
Find the last blank cell
Hello, I am looking for a formula/method of finding a last blank cell in a column example column A 1 2 3 4 blank cell 1 2 3 ...
Oulook doesn't send emails, just receiving
Hello, tried all of the options you have posted here but the test message always cannot be send, feeling a bit desperate now already... maybe some...
Excel formula
Hello everybody! That seems so simple but I can't do it :( I would like to know the formula for this: If any text is found in cells T23 U23 V2...
Names matching
Hello, I have two columns A and B, in the both columns i have the names.i have to match the all the A columns names with the B column names and B ...
Microsoft outlook keeps sending the message
SolvedHello, I have Windows Vista with Office 2007. Microsoft Outlook has been working fine for 18 months but has suddenly developed a fault when sending e...
Roster management spread sheet.
SolvedHello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and night ...
Finalizing macro
Hello, I've tired to work with this MACRO but I am trying to combine the content in order for it to work yet I keep getting bugs. The purpose of ...
If certain 'type' is in col. k have whole row copy to new sheet
SolvedHello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if my ro...
Finding max value with criteria list
SolvedHello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S. E...
Change color of cells in excel based on data in other cells
Hello, I have a question for Excel 2010 Conditional Formatting. How can I change the color of a cell to red if the value in another cell is diffe...
Convert single column to rows, into matching rows
SolvedHi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel give...
Help with formatting
Hello, Hi everyone. I am looking to do some conditional formatting and I need some assistance. Can someone please help me to understand how I can ...
How to do conditional colour fill.
Dear CCM team I want to have cell colour of cell AL3 to green if AK3 > or = D3 and the colour should be red if it do not meet this condition. Kindl...
Excel error
Hello, I am working with MS Excel 2010. While inputting data in a four-sheet file, older data of one sheet keeps being replaced by newly added dat...
Vba code for excel
Dear Expert, Hope you will be in good health! This is Santosh from India (Gurgaon). I need your help to get images saved in the excel sheet o...
Need help with counting value formula
SolvedHello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want the v...
Extract data from one sheet to another
SolvedHello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1...
Cant open a file.
Hello, I have some problems not with excel, but with a .xlsx file , I tryed to copy ,but system writes , that file has wrong end ,and copied file do...
Copy a row from one worksheet to another, based on criteria
SolvedHi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas alread...
Cell updated when if condition is changed (macro)
Hello, Can anyone help me with a simple thing I cannot get done ? Using a macro, I want the value (integer) of a cell to be changed depending o...
Convert date of birth into words
if I write 11.07.1982 in A2 ,how to get the appearance like this Eleventh July Nineteen Eighty Two Thanks
Data transfer from all sheets to 1
Hello, please help me.. i am trying to make a production report & for that i have to copy data from numerous sheets to 1 sheet & then calculate. s...
