Office Software Forum
- Excel (9,794)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
I can receive email but cannot send from Outlook 2007 Closed
Hi 2 days ago the outlook 2007 stopped sending emails and the following error was shown when I tested account settings: Send test e-mail message: ...
-
Convert Date into English Words in Excel Solved/Closed
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or ...
-
date to words Closed
Hello, sir please tell me in detail steps of converting date to words
-
How to replace * with / in all formulas in an excel sheet Solved/Closed
hi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...
-
time calculation (TimeXnumber) Solved/Closed
Hello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...
-
Transferring Data from one work sheet to another Closed
How can I transfer the final column totals from a rental data sheet to a specified place on another sheet in same book ?
-
Search similar entries Closed
Hi, I need to know, how to search similar entries in list of numeric entries. eg: Suppose I have numeric entries of 6 digits each having number...
-
Create a Macros that seemingly deletes rows at random Closed
I have a spreadsheet that is sorted by Facility, then Financial Class, and then Patient Type. I need to only have 0-2 rows of data for each Patien...
-
VBA copy value until reached a certain value Closed
Hello, I would like the following thing to do: I have one sheet in which I have a value from and a value to. For example from B4= 104 (from) B...
-
Ms Word Is Not Working please Help me Closed
Ms Word Is Not Working Its Showing windows connot access the specified device, path. or file. you may not have the appropriate permission to access th...
-
Need to fill values across Closed
Hello, I have a requirement for a macro wherein I need to select values(numbers) from the left(the first available number) and fill it across the r...
-
Fill in sale values in one sheet from another sheet based on day Closed
Hello, I have one workbook with a sheet that has a column that will have each day of the week for an entire month and the colums after will be cat...
-
Conditional formattingon Excel 2010 Closed
Can anyone please help me with this!! conditions are: If column A is between B+1 & B+2.5 then its green. If column A is > B+2.5 then its red. If ...
-
Transferring data from one worksheet to another Closed
Hello, I have a data dump where i need to run a macro which will segregate selected data to another worksheet: For e.g. Title Date/Time Resource...
-
Count a value change in cells Closed
Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change h...
-
Conditional Formatting based of another cell Closed
Hello, I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell...
-
How to create a file in makro and copy a row from other makro Closed
Hello, Please help me how to create a new excel file and copy data into this from other excel file. The new file filename will be a column.xls from ...
-
Even page numbers missing Solved/Closed
Can anyone help Header and page numbers missing on even pages!
-
Transferring Data from one spreadsheet to Another Closed
Suppose i have a file name tan.xls and another file names rule.xls! then i want to copy all data in tan.xls file in cell D2 - D22 to rule.xls file in ...
-
Conditional formatting help please Closed
I need some help that could possibly save me a huge amount of time. I'm new to conditional formatting and am working on a new method to help my staff...
-
trfing data from master wks to another wks Closed
Hi all...I would to get help from here as I trying to input my project data into my Master list. When we select won or lost under the status for proje...
-
replacing a field with value. Closed
Hello, I hope someone could help me with this issue, i have a field TN1 and want to copy the one TN1 and replace the first TN1 with 375 and then rep...
-
Enter time in a column by click Closed
I'm trying to enter the time in a column by clicking
-
If logical test value Closed
Hello, I am trying to use a formula to only add the value of a certain cell (filled with a time unit)(A1), if the date mentionned cell (filled wit...
-
Compare two cells Closed
Hello, I am looking for a formula that compares a number in a cell with another number in a different cell on the same spreadsheet and insert the sm...
-
COMPARISON OF TWO CELLS Closed
Hello, I need a formula that compares two cells on the same page an inserts the smaller of the two into a third cell. Configuration: Mac OS X ...
-
populating a work sheet from excel based Closed
Hello, I need your guidance please: I've got a tall order :) I hope you can help me! I am trying to have a new worksheet created from a templa...
-
Excel sheet automation need help Closed
Hello, Dear Concern i am a new user of Microsoft excel. i need help from you. my case is below. in a excel file i have 4-5 sheets with same tab...
-
If Function using date ranges for Annual Quarters Closed
I'm trying to make a formula that says If the start date falls within this quarter, Divide the Revenue by the POP (12 months) times either 1, 2 or 3 m...
-
Excel If Function using dates and calculating values Closed
Hello, I'm trying populate sales by quarter with rows of business opportunities. I have a column for "Revenue" then a column for "number of Months"...
-
Automatic Transfer and Removal Closed
Hello, My first post here. I have a spreadsheet that I am trying to get as automated as possible. What I am trying to do is have a line of 6 cells...
-
Copy an entire row n number of times EXCEL Closed
Hi, I need a macro in EXCEL to repeat entire rows n number of times where n is in the row to be repeated. I have tried using answers already here b...
-
Pivot tables and ordering of dates Closed
Hello, I have converted standard dates into just a month and year, using the formula I found on this site. I have also sorted my original table of...
-
Insert images in cells Closed
Hello, Would anybody know how to change this macro https://ccm.net/faq/14170-excel-a-macro-to-insert-pictures-in-a-worksheet so that images are in...
-
if cell has value copy to the next vba code Closed
I'm searching a lot of forums but i cant find exact solution for this. my problem, i'm looking for a macro which will copy any cell in column A if th...
-
notification in excel Closed
Hello, How can I get a notification or alert to remind me a an event , per date in cell, is date + 335 days?
-
Different Formulas Based Off of Font Colors Closed
I have a cell with a date that the font color is either black or green. I need another cell to recognize the color and use a specific formula to calc...
-
Outlook 2010 Send/receive problem. Can receive but cant send Closed
Hello, I used my computer to send and receive and it was working perfectly fine. However, i moved my computer back to my home from my office and...
-
Can't open a PDF from email Closed
Hello, I am currently running Windows 8.1 I have Microsoft Office loaded on my laptop I have also purchased and have installed Adobe Acrobat Pro...
-
Conditional formatting with range Solved/Closed
Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....
-
If formula using dates Closed
I have a spread sheet using projected dates for next training. I'd like to run an "if" formula that would fill the cell red when dates are past due (...
-
dell latitude d800 admin password Closed
Thank You
-
Macro for copying 1st 4 rows from 1 worksheet to other worksheet Closed
Hello, I have a set of agencies and each agency having a spreadsheet with some details. Every time the 1st four rows are copied and pasted in new...
-
IF/OR Formula Solved/Closed
Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...
-
Copy Data from Main sheet to another Sheet Closed
Hello, I have a document that has a quote on the first sheet. What I want to do is if the code in column C meets a certain criteria, it will auto...
-
Conditional formatting Closed
Conditional format A2 if either H2 or I2 is not blank.
-
Partial Match two columns of Data Closed
Hello, So I have a Column with the MPN and then another column with the Image location. The image contains the MPN as well as info, but the image c...
-
display value in a cell A7 which is refered to the value in A6 Closed
Hello, I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the...
-
Script Closed
Hi Joe here, Sheet 1 Data A B 1001 HE 1002 SHE 1003 HIS 1004 HERS When I type t...
-
How to save a data excel to non data spreadsheets to excel Closed
Hello, I have a question? How to save a data excel to non data spreadsheets to excel Configuration: iPad / Safari 8.0