The discussions
Averageif function using dates
Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...
Compare to columns in v lookup
Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155
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 ...
Copy data from another sheet if the condition is met
Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...
Transfer data if....
Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...
How to convert a numeric value into english words in excel 2007
Hello, Configuration: Windows XP / Chrome 43.0.2357.134 Sir, How to convert a numeric value into English words in Excel 2007 in software
Outlook.com
Hello, I have a email that I consider as voluntary work. Address is: ***@*** I would like to have a personal email that will not be affiliated ...
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...
Word icon
Hello, My word icon desapered from desktop how do I recover it?? Configuration: Windows / Chrome 46.0.2490.86
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...
Adobe reader error 0:104
SolvedOne of my users is having a strange issue. When she tries to open a PDF file from within Internet Explorer 8 using Adobe Acrobat Reader X (latest ver...
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...
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
Regarding office 2013
Is VISTA capable for microsoft office 2013 ? Plz answer me .
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.
Don't know what my mobile password is
ClosedHello, My one app is asking for my mobile password and I don't now what that is? Configuration: iPhone / Chrome 38.0.2125.102
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
Cannot load microsoft office
Hello, I have purchased Microsoft Office and I am trying to load it from my digital locker. I keep getter a certificate error even with the pro...
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...
Word 2007 download
how to download microsoft word 2007 without paying anything
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 formula
Hello, How do I put in a formula to search a worksheet and add the numbers up which is in the cell next to a name. Ie. I want to search for DS ...
