The discussions
Listing ignoring blanks and avoiding duplicates
I have a query but need to send a sample excel file for that. How do I attach a file as I do not see any link for that. Regards. jsexcel
If formula
Hello, I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time...
Excel: get value from sheet 1 to sheet 2
Good evening, I need help please about what I am wrong. I have Cells A6 to F6 in Sheet1 has formula in it and I was trying to get the value of tho...
Today function
Hi, i am using today function in excel, i don't want change the date, when i open other day, it should show the previous date. Thanks Bbbp
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...
Formula to count the duplication of a value in a range
Hello, I am looking for a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the ...
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...
=if(l9+m9>=40,10,) =if(d8>=5,-40,) how do i make this work
Hello, =IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work? Configuration: Windows 7 / Firefox 42.0
Positioning teams for tournament
Hello, I'm creating a spreadsheet for a netball tournament and want it to calculate the finishing positions (1st, 2nd etc) based on the points sco...
Macro to rename sheets based off cell value
Hello, I have a workbook that I copy each month with dated sheets I would like to be able to rename each sheet based on the date.
Spreadsheet
Hi everyone, I have a question regarding this problem. I want when I enter in one cell code example: C.1.1.2., C.1.1.3, C.1.1.4. ..., that my other...
Copying data one excel sheet to another with transposing columns
We have a spreadsheet with rows and rows of data. Let's say column 1 is name, column 2 is address, column 3 is phone number, column 4 is rep name. L...
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 $ ...
Subtotal
Hello, Im using subtotal and it isn't changing when i hide values. =SUBTOTAL(109,A42:GA42) Configuration: Windows 7 / Chrome 46.0.2490.86
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...
Copying rows when inserting a column
Hello, everyone I have a problem with my database I am inserting new columns when there is a new company added and the go between two existing columns...
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....
Connecting excel database to the company's website
Hello everyone and thank you for any help on this problem that I have. My boss just asked me to connect the excel database I am finishing up on cre...
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 ...
Macro to create list from master sheet
Hi! I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet...
Find which stock #s are on both spreadsheets
Hello, I have two excel spreadsheets. I want to know how I can find out which stock numbers are on both spreadsheets. Do I use VLOOKUP and if ...
Transfer of data to other sheet
If I put a name in cell AC4 then I want to transfer value of cell A4 & Y4 to other sheet. Can some some help me in this matter. Thanks Musharaf
Positioning in excel
I have aproblem with positioning in excel and i have been doing this but i have failed can you give me an assistance like by positioning them lyke 1s...
Excel multiple if conditions
Hi I have 9 different descriptions of trailer loads in Column D (they are programmed so I can choose them from a drop down list). Then in Column F ...
Bring back a value (customer id)
Hello, I need to bring back a value (customer Id) into Column J if column A from that workbook and Column A from another workbook are a match. T...
Conditional formating with if statements
I want to do conditional formatting. But my numbers change if a certain box is checked..... how do I accomplish this??? i.e. A regular clean would...
Return header if word within cell matches word within any array
Hello guys, I'm trying to classify a cell [G1] based on particular words found within 2 columns [D1 & E1]. This classification copies down from [...
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...
Excel macro
WPS require an automated process for adding new suppliers into the "Resource Management" workbook. There is data for three new suppliers (Agenda Corpo...
Formula for date comparison
Hello, Configuration: Windows 7 / Internet Explorer 9.0 I am looking for a formula that will compare two columns with dates. It would be co...
Cut copy paste option
Hello, I would like to request if user copy data from "ExcFileB" Sheet1 to "ExcFileA" Sheet1 then it always Pasted as Values. Is this possible i...
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...
Data validation formula changes to vba code
Hi The Below formula =IF(OR(D2="Best",D2="Worst"),FALSE,TRUE) used in Data Validation for Column E I would like to request that it could changes t...
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...
Enter data to run command button
Hello, How can I prevent a command button from running before data is entered into a cell? I have a workbook that refreshes data based on when a...
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
Formula - if (text), "text"
If a column has a number entered into it, the second column needs to auto populate with corresponding text. eg column I: User enters "22" co...
Lookup functions
I have a spreadsheet with various tabs including data which has been dumped in from various sources. Data includes: worked hours by department, and pr...
Conditional formatting of one based on the other cell.
Hello, I was wondering if there is a way I can say to excel without coding: 1)IF cell A1 is equal or greater [equal or less] than cell B1, then...
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 ...
Conditional formatting of one cell based on the other cell.
Hello, I was wondering if there is a way I can say to excel without coding: I have three cells A1, B1 and C1. If A1 value (which constatly chan...
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...
