Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
need to match two values and return another value Closed
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 Closed
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 Closed
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 Closed
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 Closed
hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have pop...
-
validation code Closed
Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0
-
Another copy from Master to specific sheets Closed
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 Closed
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 Solved/Closed
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...
-
Macro to move data between sheets on condition Closed
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 Solved/Closed
When 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 Closed
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 Closed
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) Closed
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 Closed
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 Closed
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 Closed
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 Closed
How do I open a .wps file then save it as a .docx file??
-
short cut between 2 sheet Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Solved/Closed
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...
-
Place specfic text in cell based on text in an adjacent cell Solved/Closed
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 ...
-
Change format of a cell when another cell is not null Closed
How do I highlight a cell or row when another cell contains anything? Thanks!
-
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 /...
-
Conditional formating Closed
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 Closed
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 Closed
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 Closed
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...
-
How to send an email automatic when a cell is updated Closed
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...
-
comparing data among excel sheets Closed
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...
-
Finding the @ character within a text, cell range Closed
Hello, I can't seem to find anything that's specific to what I'm looking for. I'm trying to find a formula that will tell me the following: ...
-
Adding points from one sheet to another Solved/Closed
Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned x po...
-
date issue Closed
if my year is only 1991 and i am trying to input the date by default 01-01-1991 in excel how? Am just doing manually 1-1-1991 and the system automat...
-
create a registration log Closed
Hello, I am trying to create a registration log for a campground. It would be of great benefit if I could copy the registration info to subsequent ...
-
Excel - A Macro to move data from rows to columns Closed
Excel - A Macro to move data from rows to columns Thanks to Venkat1926 for this tip! This Macro is working well for me, but with the exception of...
-
copy data of 1 sheet to another if criteria matched Closed
Hello, 1 have 3 sheet master, damage & shortage. in master sheet if i enter in n column damage then full row should be copied in sheet damage also...
-
How to stop today function date changing every day in Excel Closed
Hi, I am using this formula on my work sheet in cell (M7), and I have 13 sheets for each month in this workbook and I dragged the formula till cel...
-
trying to create an order sheet Solved/Closed
Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...
-
creating an order Closed
Hello, I have a multi sheet database where each sheet represents a vendor. I'd like to transfer the information from the row, Column A, B, C, to my ...
-
Exporting data Solved/Closed
Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...
-
Conditional formatting Closed
Hello, Can I use conditional formatting to change a number from positive to negative based on the text in another cell? For example, I have a fil...
-
add data inputed from one sheet to anther Closed
I'm trying to do an inventory control spreadsheet where I can put the data (ex, inventory in hand, use, buy, etc and it will be saved in another sheet...
-
PDFCreator won't open .ps files Closed
Hello, I downloaded PDFCreator so I could look at some postscript files, but it won't open any of them. PDF Architect just says the file is unsupp...
-
Conditional format to highlight cell based on date Solved/Closed
hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...
-
formula that will make a specific text into a number Closed
Hello, I need formula that will make a specific text into a number example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, ...
-
Conditional Formatting Closed
Hello, if i type "T" in one Cell i want to be fill colour to entire row how can it possible Configuration: Windows 7 / Chrome 53.0.2785.80
