The discussions
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...
How can i restore corrupt .edb?
Solved/ClosedHello, I have an exchange server with a .edb that is in a dirty shutdown state. I have 2 storage groups. The second storage group will not mount d...
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...
Allow rules wizard to work without exchange server?
Solved/ClosedHello, I no longer work for the company that had the Exchange server and I have my personal pop3 email coming into Outlook. When I try to use th...
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...
Copy row and insert n times
Solved/ClosedHello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...
Compare two worksheets and remove duplicated data from one
SolvedHello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
Search for matches from columns on separate sheets.
SolvedHello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
How to copy data between several sheets on vba
SolvedHi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
Values from one workbook to another
SolvedHello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
I am unable to send out hotmail from ms outlook
SolvedHello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...
Giving false with certain answers
SolvedHello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...
Range of cells depending on a condition.
SolvedHello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...
Outlook express emails disappeared - can i get them back?
SolvedA user opens his Outlook Express 6 (all windows updates up to date) this morning and finds that his inbox is empty. 200-odd messages that were there ...
Match cells in excel with all characters same except one
SolvedHi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...
Auto populate rows from master sheet to other sheets excel 2013
SolvedHello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...
Script which can check if a debit has a corresponding credit
SolvedHello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...
If functions with dates
SolvedHi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
Excel - compare data in two worksheets
Solved/ClosedHello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...
Unable to convert date in excel
SolvedI am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even w...
Using a comand button to open an external software?
SolvedHello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis Anchor f...
How to populate a version # change to a text sentence
SolvedHello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells t...
Dynamic database
SolvedHello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...
Sum different alphabets in an excel range.
Solvedsome one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...
Opening word 2007 docs with word 2010
SolvedSo I installed Office 2010, and removed Office 2007 from my computer (I had lost the product key, so it was in view-only mode, it's a long story) - ob...
