The discussions

Excel 2010 doubt

 Closed

Hello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...

Last reply on 26 Sep 2016 by
ac3mark

Can't open my 2007 document

 Solved

Hello, 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...

46 replies Last reply on 24 Sep 2016 by
Amir khan

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 ...

3 replies Last reply on 23 Sep 2016 by
ac3mark

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...

5 replies Last reply on 23 Sep 2016 by
ac3mark

Not able to cut or copy attachment file

 Solved

Hello, 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...

17 replies Last reply on 22 Sep 2016 by
JonO

Formula question: "if" function with date

 Solved

I 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/...

2 replies Last reply on 22 Sep 2016 by
Kim

Highlight cells with text that match data validation menu

 Solved

I 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...

1 reply Last reply on 22 Sep 2016 by
Gamul1

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...

1 reply Last reply on 22 Sep 2016 by
Mazzaropi

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...

1 reply Last reply on 21 Sep 2016 by
ac3mark

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...

8 replies Last reply on 19 Sep 2016 by
vcoolio

Protecting a file with a password

How do I protect my Word file so that nobody can access without my permission in Windows 7

1 reply Last reply on 19 Sep 2016 by
ac3mark

Converting currency to words

His Please convert 178 318.45 into words

1 reply Last reply on 19 Sep 2016 by
TrowaD

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:...

1 reply Last reply on 18 Sep 2016 by
ac3mark

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? ...

1 reply Last reply on 16 Sep 2016 by
ac3mark

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...

1 reply Last reply on 15 Sep 2016 by
Mazzaropi

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...

3 replies Last reply on 15 Sep 2016 by
TrowaD

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) ...

1 reply Last reply on 15 Sep 2016 by
Mazzaropi

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...

1 reply Last reply on 14 Sep 2016 by
xpcman

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 ...

15 replies Last reply on 14 Sep 2016 by
vcoolio

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...

15 replies Last reply on 13 Sep 2016 by
tderby

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...

1 reply Last reply on 13 Sep 2016 by
Rthmanden

Validation code

Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0

1 reply Last reply on 13 Sep 2016 by
BunoCS

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...

12 replies Last reply on 12 Sep 2016 by
vcoolio

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 ...

3 replies Last reply on 12 Sep 2016 by
ac3mark

Macro to create new workbook and copy data

 Solved

Hello 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...

26 replies Last reply on 12 Sep 2016 by
Rthmanden

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...

3 replies Last reply on 12 Sep 2016 by
vcoolio

Ms publisher dot appears where a space should be

 Solved

When typing in MS Publisher a dot appears where a space should be. How do I get rid of the dots?

1 reply Last reply on 10 Sep 2016 by
Ambucias

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...

3 replies Last reply on 10 Sep 2016 by
dave22q

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 ....

1 reply Last reply on 10 Sep 2016 by
Ambucias

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...

1 reply Last reply on 9 Sep 2016 by
Mazzaropi

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...

1 reply Last reply on 9 Sep 2016 by
vcoolio

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...

1 reply Last reply on 8 Sep 2016 by
TrowaD

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

1 reply Last reply on 8 Sep 2016 by
Ambucias

.wps conversion to .docx

How do I open a .wps file then save it as a .docx file??

2 replies Last reply on 7 Sep 2016 by
ac3mark

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.

1 reply Last reply on 7 Sep 2016 by
ac3mark

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 ...

1 reply Last reply on 7 Sep 2016 by
ac3mark

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...

1 reply Last reply on 7 Sep 2016 by
ac3mark

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...

1 reply Last reply on 7 Sep 2016 by
xpcman

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...

1 reply Last reply on 7 Sep 2016 by
xpcman

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...

1 reply Last reply on 7 Sep 2016 by
Mazzaropi

Compare values in two columns and return the value from third

 Solved

Hello, 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...

11 replies Last reply on 7 Sep 2016 by
keshav

Place specfic text in cell based on text in an adjacent cell

 Solved

Hello 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 ...

5 replies Last reply on 6 Sep 2016 by
TrowaD

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!

1 reply Last reply on 6 Sep 2016 by
Mazzaropi

Phonelock forget the pasword.

 Closed

Hello, how am i going to open again my phonelock????? i have forgotten my password.. please help. cherry mobile CP1 Configuration: Windows 7 /...

Last reply on 6 Sep 2016 by
Ambucias

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...

1 reply Last reply on 3 Sep 2016 by
Mazzaropi

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...

4 replies Last reply on 3 Sep 2016 by
captainashish

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 ...

3 replies Last reply on 2 Sep 2016 by
ac3mark

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...

5 replies Last reply on 1 Sep 2016 by
pacchiee

How to send an email automatic when a cell is updated

Hello guys, I am imports coordinator I have a tracker created in excel worksheet which I use to track our shipments that arrive at port then proce...

1 reply Last reply on 1 Sep 2016 by
xpcman

Comparing data among excel sheets

Hello, I have three excel sheets with data regarding product numbers and their respective plants as well as another sheet (4th sheet) which is a t...

1 reply Last reply on 1 Sep 2016 by
TrowaD
Results 1801 - 1850 out of a total of 12,267