Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
COUNT IF AND COUNT A Closed
I need to count column C if cell equals "medicare" only on the same line column A has text. Column a is made up of names. I just don't need it to cou...
-
retrieve-replace range of rows from & to a sheet Closed
Hello, good morning all my friends. let me narrate my story first actually I wanted to upload my dummy file for reference..but I don't know ho...
-
Excel Macro to use set of product numbers to delete from List Closed
Hello All, I am looking to create a macro that will be using a set of product numbers that should not be listed in a master list that is located i...
-
macro Solved/Closed
I want to write a macro from the start, I have date of employee name and their attendance on a workbook and on the other workbook I have a calendar. N...
-
Excel help on IF formula Solved/Closed
I want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y, if cell L27 equals the work "expected" then do Sum of Cell a * b and i...
-
Macro to Extract from Different Workbooks & Multiple Worksheets Closed
Hi, i've been trying to figure out how to extract multiple data from different workbooks with multiple worksheets and paste them into a master shee...
-
combining two separate macros into one Solved/Closed
Hello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...
-
Reminder in Excel spreadsheet Closed
Hi Team, I am trying to put a reminder in excel spreadsheet, I tried one macro, but its not popping up. Can any one you please help me to get this ...
-
Copy data from worksheets to master sheet Closed
Hi, I have one input workbook with multiple worksheets(all are with same table format) and I have to look in to each worksheet and if there value t...
-
How to compare two different columns Closed
Hi, I have a sheet with Id numbers in column A and names in column B, for around 50 workers. In other sheet I have Id number in column A, names in ...
-
Date formatting in dd/mm/yyyy Solved/Closed
Hello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have i...
-
How to the text/word of a cell in excel 2010 Closed
Hi, I am working on creating an excel spreadsheet in which I want a series of names to be outputted if the condition of another cell is valid. F...
-
Macro to Search/Replace Text from another Column Solved/Closed
Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...
-
Rename a tap Closed
Hello, frist I'm so sorry for my mistake , pls forgive me I don't mean that . always thanks every one, I don't no how I do that! If you please...
-
Automatics mail with attachment to send using Outlook Closed
Hello all, I am very new to excel file so need help from this group. I have data (PDF and Excel), now i want to send automatics mail using Outlo...
-
Conditional format text cells based on a column with numbers Closed
Hello, So I have text cells describing what the numbers in the column next to it mean, however, I want the conditional formatting (data bars) to s...
-
EXCEL HELP Closed
Hello, Novice needs help I am trying to extract the contents of cells from several worksheets and summarize on one Header Summary Sheet So i...
-
Won't save passwords / usernames Solved/Closed
Hello, Computer won't save passwords / usernames, even when I ask it to and I have went into tools and everything was set as suppose to.
-
Macro to filter out text contents Closed
i have Column E filled with numbers, formulas and text. I would like to write a macro to filter out the cells with text contents. The text contents do...
-
urgent ansin excel Solved/Closed
a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...
-
Automatically Rename Cells Closed
Hi, i am using Excel 2010 ...quite poorly as my skills are basic. I am trying to work out how to Incrementally number worksheets automatically ie ...
-
Transfer data from one Excel worksheet to another automatically Closed
Transfer data from one Excel worksheet to another automatically. we have 8 employees that enter job quote information onto their individual worksheets...
-
Tables Closed
Hello, I am trying to extract the contents of cells from several worksheets and summarize on one Header Summary Sheet So i'm trying to generate...
-
macro to delete rows between named ranges in excel Closed
How do I delete all rows between named ranges? I have a scenario below Name Range 1 : SUBHEADER_001 (A1:E1). Displays Headers Name Range 2 : SU...
-
I need help in my project Closed
first see this picture http://img713.imageshack.us/img713/6725/d9i8.png now what i want is, after typing the '2' in B2, i press Enter, D2 will be ...
-
Downloading Word Doc's Closed
Hello, Can any one help me please. I am unable to download a word doc from my gmail and/or my aol account. I am able to download pdf's a excel do...
-
Popup reminder based on date and additional celll values Solved/Closed
Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...
-
PDF Converter to excel : Closed
Hi, I saw https://ccm.net/downloads/tools/5605-pdf-to-excel-converter/ product. This product is very good. Is this a free version available ?. ...
-
Macro to Search and Replace Text from another Column Closed
I receive an Excel file each month that has the following columns Group Name, DOS, Clinician Rpt Name, (rest of columns have patient information) ...
-
Download using windows 8 Closed
I am unable to download a word doc from my gmail and/or my aol account. I am able to download pdf's a excel docs. It is odd, sometimes it works and ...
-
macro to populate formula using Autofill Closed
i have 2 worksheets, A & B. In worksheet A, i have the data in cell F2, F3, F4. In worksheet B, i would like to refer worksheetA!F2 in Column G,...
-
Plotting multiple data Closed
Hello, How do I plot a table with multiple data like this: For May: Project 1 Project 2 Project 3 Item 1 5% ...
-
comparing the two excel sheet, what formula is required Closed
I have two excel sheets one column haveing the same numbers both the sheets, Now in same number I have alloted different compaines, now I need to ...
-
ms word Closed
after i move documents to my usb, then i cant open word documents anymore and also my microsoft office word does not open.
-
android tablet Closed
Hello, Is there a free download of Microsoft Office for android tablet? Have looked into different apps and their reviews and have had no positiv...
-
Help with a Formula 'Isblank refer to another cell" Closed
I need a formula that will give me number of days between two columns Which contain dates, if one or the other has no date populated it would then ref...
-
Averaging & Assigning Blank Cells a Specific Numeric Value Closed
Good day everyone. I'm sorry if this seems remedial, but I'm having trouble with a spreadsheet. Here's the gist of my problem: Within a row, I have se...
-
proportions?ratios? not sure Closed
I have an excel spreadsheet with four different money columns. I am trying to develop a formula that might create a comparison similar to what I thin...
-
Copy data from Master Sheet to Client Sheets Closed
Hello All Good Day I Need Some help from you that is i want to copy the data from Master Sheet to Client Sheets with Criteria Columns for your b...
-
How I convern number to spelling in excel Closed
Dear friend, This is my problem. Please solve it.
-
I would like to edit a PDF file Closed
Dear Sir I would to get editing PDF file software and making PDF software. please help and i hope your reply. Thank. Best regars, Kay Kay
-
Pull values from conditionally formatted cells - Excel 2013 Closed
hello, I have a large data set wherein I am trying to figure out where certain values fall and am applying a cell color using conditional formattin...
-
How to add a seperator / between fields, create function Closed
Hi, I am running a macro copying AA2:AA300 to B and copyiing AB2:AA300 to C this is done for 20 more columns going in B and C how can I add a line...
-
Comparing Columns Closed
Hello, I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000 custome...
-
Word Markup Area Solved/Closed
Hello, How do I turn off markup area in Word? Thanks!
-
Hide rows with zero value in Multiple sheets Solved/Closed
Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...
-
Populate rows on sheet1 based on values in sheet2 Closed
Hi, I need to populate rows in sheet1 -- S.No, Name , Address, Contact No. with the values present in sheet2 -- S.No, Name , Address, Contact No. ...
-
pop up alert Closed
Hello, I have created a worksheet with macro to enter current time by clicking on a cell. For example, double click on A1 to enter current time th...
-
Display Formula in Cell with values Closed
i need to display the used formula in another cell as it is with substituting the values. example: if A1=100, A3=200, B1=206 formula is =SUM(A1, ...
-
macro for copying sheet 1 into sheet 2 and then deleting data in Closed
i need macro for copying sheet 1 into sheet 2 and then deleting data in sheet 1 and sheet 3 plz help