The discussions
Excel formula
SolvedHello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
Scroll mouse in listbox
SolvedHello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...
Copy a 'template' sheet onto multiple other sheets
SolvedHello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...
Add sheets to combobox
SolvedHello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...
Conditional formatting on multiple criteria
Solvedhi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
Comparing columns in excel 2010
SolvedHello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
Set rows height also exception in range
SolvedHello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
Comparing rows on two worksheets and pull data into a new sheet
SolvedMy requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
Remove (shape) straight line
SolvedHello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
Home button
SolvedHello, I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1" Thanks & Regards Configuration: ...
Next and previous button and de-activate at last sheet
SolvedHello, I would like to request to create a button on Sheet that will click which goes to next sheet and this button also de-activate when it g...
A macro to create new spreadsheet and copy data
Solved/ClosedHello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...
Showing the $ value difference
SolvedHello, I am using Excel 2016.. and need some help. I am doing a budgeting sheet and cant figure out how to do the following; Column A - Budget $ ...
Tell excel where to look
SolvedHello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then l...
Excel: if date =, then enter a value
SolvedI am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...
Adding two non-adjacent cells (number and text)
SolvedHello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....
Drawback of copy and clear code
SolvedHello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...
How to extract target value from other cell
SolvedHello, I would like to request that Suppose this line of code is working for Column B MsgBox "You entered is Invalid" this will show the m...
Excel is automatically changing dates to a numeric code
SolvedHello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...
Protecting your formulas in multiple worksheets
SolvedHello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...
Fix the code
SolvedHello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...
Date format changes when editing it
SolvedHi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...
Copying entries from multiple sheets to new sheet, then summing
SolvedI run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...
Merge two macros of 2 diffrent workbooks
SolvedHello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...
Remove or clear data
SolvedHello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...
Multiple if in data validation
SolvedHello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2
Conditional copy of cells with corresponding values
SolvedI have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...
Count formula (need help)
SolvedHello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...
Using if function with dates
SolvedHello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...
Macros editing
SolvedHi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...
Refer only one column from named range
SolvedHello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
Lookup relevant value from table
SolvedHello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...
Copying dates in excel
SolvedHello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...
If statement
SolvedHi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...
Copy data from 1 workbook to another based on sheet tabs
SolvedGood day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
Link data from one cell to another
SolvedHello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
Excel:print one enlarged page to multiple pages
SolvedHello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101
Entering current time in specific cells
SolvedHi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...
Comparing two columns with other two columns in excel 2003
Solved/ClosedDear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...
Excel - shortcut key for print view
SolvedHello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5
Create worksheets with names from a list
SolvedHello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...
File attachment
SolvedHello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...
Check info on two different cells...
SolvedHello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...
Auto transfer data as i marked
SolvedHello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
Counting action under condition of theyr value, and month when..
SolvedHello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
@if formula
SolvedHello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
Conditional formating a column
SolvedHello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
Copy cells based on conditions
SolvedHello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
Copying data from workbook to workbook using button
SolvedHello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
Change color to different cells based on another cells text.
SolvedHi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
