Office Software Forum

Ask a question
Search
Close
Results 4951 - 5000 of about 16,700
  • 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

    sinjin | Excel | Latest reply: cmarzahn Feb 20, 2015
    1 reply
  • 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,...

    T | Excel | Latest reply: cmarzahn Feb 20, 2015
    5 replies
  • 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...

    Stella1977 | Excel | Latest reply: cmarzahn Feb 20, 2015
    1 reply
  • 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 ...

    Firoz.Tex | Excel | Latest reply: cmarzahn Feb 20, 2015
    1 reply
  • 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...

    Ashish | Excel | Latest reply: cmarzahn Feb 20, 2015
    1 reply
  • 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...

    calebz | Excel | Latest reply: cmarzahn Feb 20, 2015
    1 reply
  • 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 ...

    Theusernamee... | Word | Latest reply: Ambucias Feb 20, 2015
    3 replies
  • 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 ...

    CatherineGPR | Excel | Latest reply: CatherineGPR Feb 19, 2015
    0 replies
  • 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...

    Manoj | Excel | Latest reply: vcoolio Feb 19, 2015
    1 reply
  • Excel tutor Closed

    Hi forum I am new here and I need excel tutorial, can anyone help?

    Royaldee | Excel | Latest reply: Ambucias Feb 19, 2015
    3 replies
  • 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 ...

    ArashMan | Excel | Latest reply: RayH Feb 19, 2015
    3 replies
  • 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...

    Sophie | Excel | Latest reply: cmarzahn Feb 19, 2015
    1 reply
  • 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 ...

    Wiebes | Excel | Latest reply: vcoolio Feb 19, 2015
    1 reply
  • 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...

    Jen | Excel | Latest reply: ArashMan Feb 18, 2015
    2 replies
  • 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 ...

    Amit Patel | Word | Latest reply: amol Feb 18, 2015
    3 replies
  • date to words Closed

    Hello, sir please tell me in detail steps of converting date to words

    amol | Excel | Latest reply: Computertech Feb 18, 2015
    1 reply
  • 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...

    DG83 | Excel | Latest reply: DG83 Feb 18, 2015
    4 replies
  • 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...

    ArashMan | Excel | Latest reply: ArashMan Feb 17, 2015
    4 replies
  • 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 ?

    Malvan | Excel | Latest reply: Malvan Feb 17, 2015
    0 replies
  • 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...

    arpit.rastogi | Excel | Latest reply: TrowaD Feb 17, 2015
    1 reply
  • 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...

    Bdemaray21 | Excel | Latest reply: Bdemaray21 Feb 17, 2015
    0 replies
  • 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...

    Venivid | Excel | Latest reply: Venivid Feb 17, 2015
    0 replies
  • 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...

    Bosvaibhav | Word | Latest reply: Bosvaibhav Feb 17, 2015
    12 replies
  • 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...

    Deepu | Excel | Latest reply: Deepu Feb 17, 2015
    0 replies
  • 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...

    Bdotp | Excel | Latest reply: Bdotp Feb 17, 2015
    0 replies
  • 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 ...

    Ak | Excel | Latest reply: Ak Feb 17, 2015
    0 replies
  • 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...

    Anoymous | Excel | Latest reply: Anoymous Feb 17, 2015
    0 replies
  • 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...

    MindTwister | Excel | Latest reply: MindTwister Feb 16, 2015
    2 replies
  • 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...

    Delightful2k4 | Excel | Latest reply: TrowaD Feb 16, 2015
    1 reply
  • 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 ...

    Csongi | Excel | Latest reply: TrowaD Feb 16, 2015
    3 replies
  • Even page numbers missing Solved/Closed

    Can anyone help Header and page numbers missing on even pages!

    drumgora | Word | Latest reply: drumgora Feb 16, 2015
    2 replies
  • 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 ...

    Alazeem | Excel | Latest reply: Computertech Feb 16, 2015
    1 reply
  • 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...

    lb_028 | Excel | Latest reply: vcoolio Feb 14, 2015
    1 reply
  • 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...

    kai1401 | Excel | Latest reply: vcoolio Feb 14, 2015
    14 replies
  • 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...

    hogs | Excel | Latest reply: hogs Feb 13, 2015
    0 replies
  • Enter time in a column by click Closed

    I'm trying to enter the time in a column by clicking

    dbrumm | Excel | Latest reply: dbrumm Feb 13, 2015
    0 replies
  • 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...

    Robert | Excel | Latest reply: Robert Feb 13, 2015
    0 replies
  • 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...

    w1ll1am | Excel | Latest reply: w1ll1am Feb 12, 2015
    0 replies
  • 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 ...

    w1ll1am | Excel | Latest reply: w1ll1am Feb 12, 2015
    0 replies
  • 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...

    melissa | Excel | Latest reply: TrowaD Feb 12, 2015
    3 replies
  • 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...

    Joni | Excel | Latest reply: Joni Feb 12, 2015
    0 replies
  • 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...

    JohnnyhH | Excel | Latest reply: JohnnyhH Feb 11, 2015
    0 replies
  • 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"...

    JohnnyhH | Excel | Latest reply: JohnnyhH Feb 11, 2015
    0 replies
  • 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...

    evandaviscruz | Excel | Latest reply: evandaviscruz Feb 11, 2015
    0 replies
  • 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...

    Tom97836 | Excel | Latest reply: Tom97836 Feb 11, 2015
    0 replies
  • 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...

    Simon | Excel | Latest reply: Simon Feb 11, 2015
    0 replies
  • 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...

    pepi1943 | Excel | Latest reply: ac3mark Feb 11, 2015
    1 reply
  • 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...

    zois27 | Excel | Latest reply: zois27 Feb 11, 2015
    0 replies
  • 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?

    tch68 | Excel | Latest reply: tch68 Feb 11, 2015
    0 replies
  • 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...

    jpcedotal | Excel | Latest reply: jpcedotal Feb 11, 2015
    0 replies