The discussions
Excel
Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...
Conditionally copy columns
SolvedHello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...
Find word on sheet1 move all adjacent column values to sheet2
Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...
Change a range dynamically - vba script.
SolvedHi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...
If formula
This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...
Date not showing up as a date???
Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...
Conditional formating
I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...
Macros code
My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...
Exchange inbox repair tool
Solved/ClosedHello, I have Exchange 2010 server that is being used to temporarily hold mailboxes. After a reboot the .edb file went from 276gb to 0kb. Of cour...
Macro for transferring data from one excel to different excel
Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...
Looking for help with a macro/vba for find/copy/paste
I have a lot of data in column A of a spread sheet. I would like to "search" for part of a string, and then copy the row of the cell with this data in...
Enter current time in a cell by clicking it
Hello, I followed the instructions and it works great. My problem is how do you turn it off with out deleting the visual basic entry? AJ Co...
If function date problem
Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...
Comparing two lists of names in excel and then sorting them
Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...
Can i accomplish this with conditional formatting or another way
Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...
Excel
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
Removing false in excel
Solved=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!
Increment a cell value - conditions applied
SolvedHello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...
Michelle
Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...
Want to copy sheet1 data to sheet2
Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...
Apply a negative until 0 is reached in excel
I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...
How to merge the data from 2 different sheets into 1?
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...
Rating from parameter lookup
SolvedHi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...
Free publisher
During installation the message for product key appears and the text is in French, even though it says English on the webpage which has the downloade ...
Nesting if() functions?
SolvedHey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...
Excel macro create new sheet copy & paste cells
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
I'm not able to send emails
Hello, i use bsnl broadband at home. should i reconfigure my account settings to send emails if my broadband provider initially was different from...
Automiatic email
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
Outlook e mails
Hello, Cannot send messages but receive. Get message when sending. 0x80042109 Thank you Adriaan Configuration: Windows / Mozilla 11.0
I'd like to change a pdf file to word, excel and powerpoint
To whom it may concern I'd like to change a PDF document to excel, word and power point. Please help me soon as this is as a matter of urgency. ...
Number of days between 2 dates
Hello, i am trying to calculate the number of days between 2 dates i,e 09/08/1965-05/02/2007= 41 years and 181 days which is 15146 days Whe...
Outlook e mail problems
I have a problem with my outlook e mail. Cannot send mails but receive mails. I receive the following message: 0x80042109
Help help help excel formula
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
Due date reminder with an email to the filtered list
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
Why dbx files do not opened
SolvedAs soon as I have not tried to open the file through Outlook. Out - walked into account. Downloaded the new version - nothing helped. Outlook does not...
Change date format using excel macro
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
Comparing excel sheets with only a few overlapping records
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
Mtch formula required
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
How to make a cell flash using excel 2011 for mac
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
Major problems images into word
Hi all, At the moment I am having major issues with inserted images into word. Background: it concerns my PhD thesis of about 140 pages. In this do...
I am looking for outlook express fix tool
SolvedHello everyone...How can i restore damaged .DBX file of OE? I am not able to see the mails. My 4 Gb data in inbox.dbx is corrupted of .dbx files by u...
Replace cell content in excel 2007
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
Macros or vba for data validation
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
1 time data entry
Solved/ClosedHello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...
Add an x to cell if other conditions met
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
Convert numbers to words in excel
please clarify my problem "convert numbers to words in excel"
Mm/dd/yy and dd/mm/yy and mm-dd-yy and dd-mm-yy in one column
Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...
Replacing duplicates
Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...
Due date reminder in excel to new sheet?
SolvedHello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...
Copying a row to another sheet with a trigger
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...
