The discussions
Issue in excel
Hello, i am unable to change the date format in excel... actually it show 42625 but while "F2: 9/12/2016 can you please help me to resolve the iss...
Excel dates
ClosedHello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116
Excel 2010 doubt
ClosedHello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...
Can't open my 2007 document
SolvedHello, i can't open my docx word document.i'm running office 2007 and i'm clickin all my word documents and getting the same response "the file is no...
Conditional formatting based on specific expiration date
Hello, I have a spreadsheet that tracks training my employees take. The cells include the dates (mm/dd/yyyy) that the courses were taken. Most of ...
Search then validate given values against given sheet.
I have two worksheets. One sheet is called "Valid" and contains values in the following cells: A1= 1234 A2= 123 A3= 12345 A4=123456 The other...
Not able to cut or copy attachment file
SolvedHello, I am not able to cut or copy any attachment file in outlook 2003.In a new message,i attached a file(pdf,xl,doc etc) i want to copy tha...
Formula question: "if" function with date
SolvedI am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/...
Highlight cells with text that match data validation menu
SolvedI see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation. I have an Excel sheet tha...
Change cell colour based on other cells text
Hello, I really need help on this one as I can't work it out. I need to change the colour of a cell if that cell and the previous 12 cells do not c...
Keep drop down/ data validation with macro
Hello, I searched around a lot and could not find an answer to this: I need to replace values in a cell with a macro while keeping the "Data Valida...
Command button to move data from one sheet to another
Hello, I have a report with a data sheet and a data removed sheet. The data sheet is from column A:AC. In column Q I have different statuses tha...
Protecting a file with a password
How do I protect my Word file so that nobody can access without my permission in Windows 7
Converting currency to words
His Please convert 178 318.45 into words
I forget my gmail account password
Hello, I forget my gmail account password recovery email id password also same so I can't open my both accounts. please help me Configuration:...
Can't read pdf converted to word
Hello, i went to open my documents which is prepared by pdf in to word and the created word documents are not readble please help how i can solve it? ...
Formula to find out all the master id's
Hello, My first columns is a Master ID which is unique for every row. My 5th column is the item name where item name's do get repeated. I need a...
Copy potential data from one sheet to another if condition met
Hello all, thanks for taking the time to read this, I have a very specific formula request, or at least a request for direction on how to write/lea...
Need to match two values and return another value
I have two spreadsheets in which I need to match two values and return another value. So, in my case, if Column C and Row 24 match (in spreadsheet A) ...
Compare data and summarize on seperate sheet
Hello, Each month I download a 1,000+ line of Part Numbers with inventory qty and value to an excel tab. I want to compare the part numbers to se...
Search/transfer patient data
Hello, If anyone could help me, it would be greatly appreciated. Ok I have a spreadsheet with different patient names. If they are inpatient then ...
If then formula question
Hello, If you have a value in cell a that equal 42:15 (42 hrs and 15 min) and in another cell you want it to look at that cell, determine if the hou...
Pop up reminder vba
hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have pop...
Validation code
Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0
Another copy from master to specific sheets
Hello everyone, First post here and I am not, by any means, an excel expert (my husband thinks he is, which is why I'm here, lol). So here is my qu...
Macro for looping charting data keyed from two columns
Hello and thank you anyone for reading this. I have a quandary that is beyond my VB skills and am looking for any help possible. I need to find a ...
Macro to create new workbook and copy data
SolvedHello I am looking for macro to copy rows based on partial cell content of a column. I have an excel spreadsheet called "arc.xlsx" from which I wou...
Macro to move data between sheets on condition
Hello, I am a beginner to using Macros in excel. I understand there are lots of things on here, and the internet in general, telling you how to cre...
Ms publisher dot appears where a space should be
SolvedWhen typing in MS Publisher a dot appears where a space should be. How do I get rid of the dots?
Hotmail account in outlook express
Hello, i can't access my hotmail account using outlook Express from last 3 days .when i click send / recv the error comes on the screen Unable t...
Adding picture to word
Hello, SIR, WOULD YOU PLEASE GUIDE ME TO SOLVE MY PROBLEM PLEASE ? THE MSOFFICE WORD HAS BLANK PAGE FOR TYPING IN WHICH WE CAN CREATE DOCUMENT ....
Excel date formula (if)
Hello, I'm in need of some assistance with an excel date formula. I'm need to look at 2 cells in the same row which contain dates or may be NULL...
Copying data
Hello, I presently have stock sheets with details of suppliers, items, quantities held-in stock and on display, price, etc. Whenever I reduce the q...
If and and functions request for help
Dear all, I am trying to learn more on how to use Excel and set some basic plannings on it. Unfortunately, I'm not good enough and for some special...
Outlook keep on sending many mails from outbox
Hello, my outlook keep on sending many mails from outbox untill i delete it in the out box. how can i resolve this problem
.wps conversion to .docx
How do I open a .wps file then save it as a .docx file??
Short cut between 2 sheet
can someone show me a short cut how to transfer a date or number from sheet 1 to sheet 2.
Chart out a grid using excel
How can I build a grid using an existing excel sheet that already has the cell references and the name. This document has four groups each containing ...
Unable to access emails
Hi Wonder if you can help, i recently switch mobile phones and am unable to access my hotmail account due to forgetting my password. When i run thr...
Conditional formating
i have a row of initials: MM MM MM MM LL LL LL BB XX XX MM CC CC CC, each pair is a column these correspond to booking dates, so if the initial next...
To get notification in outlook from excel
hi iam using excel for my work and i am trying to manage due dates ie if a due date is arrived it shoud be be notified in outlook as notification with...
Conditional formatting between 2 different columns
Hello, If someone can please help me. I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers depending o...
Compare values in two columns and return the value from third
SolvedHello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need...
Place specfic text in cell based on text in an adjacent cell
SolvedHello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I ...
Change format of a cell when another cell is not null
How do I highlight a cell or row when another cell contains anything? Thanks!
Phonelock forget the pasword.
ClosedHello, how am i going to open again my phonelock????? i have forgotten my password.. please help. cherry mobile CP1 Configuration: Windows 7 /...
Conditional formating
Hello, I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should turn r...
Outlook 2010 not starting in normal mode, bt working in safemode
Hello, I m facing issue with outlook. my laptop is having w7 pro 64 bit & ms office home & business 2010. Outlook is not starting in normal mode...
Outlook 2016 able to receive email but not send
Hello, i have outlook 2016 i am able to receive email but not send i repaired the pst. i even restored to a previous version i also did a quick ...
Find duplicate rows and copy content of one cell to new sheet
Hello, I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are ex...
