Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Moving data from one sheet to another Closed
Hello, I need to move a date if 21 days great than today Configuration: Windows 7 / Internet Explorer 10.0
-
Need help with date and if statement newbie Solved/Closed
Hello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...
-
IF Function help Closed
Hello, I am working on a spread sheet whereby one cell contacts REV and RP and I then want the amount linked to that row to become a negative figure...
-
numeric value to word. Closed
How I can create any amount in word format from numeric format automatically or using the formula function in MS Excel Sheet? Kindly showing easy ...
-
How to interchange the date format Closed
Hello, I have my date format as 01.02.2015 but when we replace the . with / it shows as 01/02/2015 which is 02-Jan-2015. I want to show it as 01-F...
-
if cell ="text" =Other text Closed
Hello, I'm looking for a formula that will help me do the following: If cell contains "Other (please specify)" that value of that cell needs to...
-
Office-Word is messing up, or...? Closed
For the last five months as I type a document, random letters are appearing in the words. These are not self-made typos, (I thought it at first) they ...
-
Data Match Closed
I have 2 workbooks, one with raw data the other used for reporting. The workbook with the raw data has 2 columns one being publication number and the ...
-
data is not appear in drop dawn list in filter Closed
Hello, i have some data rows almost 2000 there is black rows between every row. filter did not showing whole data in drop dawn so i can remove empty...
-
Excel tutor Closed
Hi forum I am new here and I need excel tutorial, can anyone help?
-
the DATE that i enter the DATA Closed
Hello, is that possible to know the date that i enter the data in a cell. for example i enter the data in cell B1 today and i want this date in C1 ...
-
Generating New Document Closed
Hello, I have an internal budget and I would like to use macro to generate another workbook with specific information from that budget with formul...
-
If formula to identify data outside a timeframe Closed
Hello, I have a excel report that contains data including a date created and inception date. I would like to run a formula that will tell me if the ...
-
Shortcut/Keys in Excel Closed
Hi! I'm Jen..I know how to use the Excel, however, I haven't use it for years now and my Job now is Secretary so I will be encountering Excel, Word, P...
-
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...