Office Software Forum

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

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

    Dlec | PDF | Latest reply: Computertech Feb 10, 2015
    1 reply
  • 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....

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

    Trainer2010 | Excel | Latest reply: Trainer2010 Feb 10, 2015
    0 replies
  • dell latitude d800 admin password Closed

    Thank You

    bcb123 | Word | Latest reply: akoh.john Feb 10, 2015
    2 replies
  • 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...

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

    ad1959 | Excel | Latest reply: vcoolio Feb 10, 2015
    3 replies
  • 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...

    mayi1986 | Excel | Latest reply: venkat1926 Feb 10, 2015
    1 reply
  • Conditional formatting Closed

    Conditional format A2 if either H2 or I2 is not blank.

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

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

    lokesh | Excel | Latest reply: TrowaD Feb 9, 2015
    1 reply
  • Script Closed

    Hi Joe here, Sheet 1 Data A B 1001 HE 1002 SHE 1003 HIS 1004 HERS When I type t...

    jotowill | Excel | Latest reply: TrowaD Feb 9, 2015
    1 reply
  • 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

    Nikkie | Excel | Latest reply: RayH Feb 9, 2015
    1 reply
  • Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy Closed

    Hello, I'm looking to convert the following excel format of "Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy. Thanks in advance for your answers. j...

    jtijerino | Excel | Latest reply: venkat1926 Feb 9, 2015
    1 reply
  • Identify same values in Column A Closed

    Hello, I have an excel sheet with too many rows. But in Column A, I have many values which starts with XYZ. I have to identify them and need to use...

    Dali | Excel | Latest reply: venkat1926 Feb 9, 2015
    1 reply
  • Inserting different photos into cells- macro Closed

    Hi, I am not a super savvy programmer, but looking for a Macro that might automate inserting a photo (so user selects image) and then re-sizing the ph...

    darcyjane | Excel | Latest reply: RayH Feb 8, 2015
    1 reply
  • how we can convert number to word in excel Closed

    how we can convert number to word in excel?

    chamak77 | Excel | Latest reply: RayH Feb 7, 2015
    1 reply
  • Need to create a macro Closed

    i have no clue on how to create a macro.i need to copy all items in sheet 1 rows to columns in sheet 2 every time its updated. sheet one will change ...

    bettyjk | Excel | Latest reply: vcoolio Feb 6, 2015
    2 replies
  • Shape not showing Text in excel Closed

    I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!

    umer007 | Excel | Latest reply: RayH Feb 6, 2015
    1 reply
  • Retrival of email login data Closed

    Hi guys - I wonder if you could help with a friends problem? He was using Windows XP and Outlook Express to access his emails. Then tragedy struck...

    BrianGreen | Outlook | Latest reply: Ambucias Feb 6, 2015
    2 replies
  • Macro for opening a new Word document from My Templates item Closed

    Hello, I am using Mac Office 2011. I regularly need to create new Word documents, using a customized template I created. Usually, I have to go...

    ybiancheng | Word | Latest reply: Computertech Feb 6, 2015
    1 reply
  • If Function Closed

    Hello, I'm having a bit of a trouble working the If Function in excel. Here's my problem: My manager asked me to find the commission fees to cha...

    Jen | Excel | Latest reply: vcoolio Feb 6, 2015
    1 reply
  • Number that turns in to date. Closed

    Hello, hi I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ? Configuration: Windows 7 / C...

    Zet | Excel | Latest reply: vcoolio Feb 6, 2015
    1 reply
  • How to repeat a row 4 times, while increasing sequence Solved/Closed

    Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...

    Stumped.. | Excel | Latest reply: OldCoder Feb 6, 2015
    2 replies
  • Using one cell to refer to many Closed

    Hello, I'm trying to do something I'm not sure is possible. I have a spreadsheet to keep track of receipts and group items by category. In one column ...

    Underwater | Excel | Latest reply: Underwater Feb 5, 2015
    2 replies
  • Creating a task reminder for all tasks for that day Closed

    I'm hoping someone will be able to help me. I need to attempt to create a task reminder pop up that will list all tasks that need to be done today. An...

    mhurd | Excel | Latest reply: mhurd Feb 5, 2015
    4 replies
  • Converting rows of data in notepad to columns Solved/Closed

    Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

    Need help | Excel | Latest reply: Philgood_FR Feb 5, 2015
    2 replies
  • Excel Closed

    Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...

    Popo | Excel | Latest reply: TrowaD Feb 5, 2015
    1 reply
  • Problem with formula using ISBLANK Solved/Closed

    Hello, I am using the ISBLANK function to execute formulas in my spread sheet. If I use a formula to add or subtract, such as =IF(ISBLANK(D13)...

  • conditionally copy columns Solved/Closed

    Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...

    GMHerbs | Excel | Latest reply: GMHerbs Feb 4, 2015
    2 replies
  • convert Nov-11-2014 to dd/mm/yyyy in Excel Closed

    Hello, I need assistance, Need to convert the following date of "Nov-11-2014" to dd/mm/yyyy Configuration: Windows 7 / Firefox 35.0

    jtijerino | Excel | Latest reply: jtijerino Feb 4, 2015
    0 replies
  • find word on Sheet1 move all adjacent column values to sheet2 Closed

    Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...

    feeders | Excel | Latest reply: feeders Feb 4, 2015
    1 reply
  • Change a range dynamically - VBA script. Solved/Closed

    Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...

    BrianGreen | Excel | Latest reply: BrianGreen Feb 4, 2015
    5 replies
  • logging Closed

    I have a form that we have to manually insert data into. And I would like to log the data in a sperate workbook of list of 200 people. Logging it i...

    acastle | Excel | Latest reply: acastle Feb 4, 2015
    0 replies
  • copying info Closed

    Hello, How do I get information in one cell to two there sheets with out copy and paste. The info in the cells are the same on all three sheets bu...

    CDUB | Excel | Latest reply: CDUB Feb 4, 2015
    0 replies
  • If formula Closed

    This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...

    Brandonw409 | Excel | Latest reply: pijaku Feb 4, 2015
    1 reply
  • details to another worksheet fr main worksheet using macro Closed

    Hi, I trying to input my project data into my Master list. When we won or lost the project, the data will auto disappear and transfer to the Won list ...

    kai1401 | Excel | Latest reply: kai1401 Feb 4, 2015
    0 replies
  • Date not showing up as a date??? Closed

    Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...

    phaney | Excel | Latest reply: BrianGreen Feb 3, 2015
    5 replies
  • Ms. Closed

    working with several worksheets in one notebook, how do I get amounts from sheet 1 plus sheet 2 plus sheet 3 etc. to total to the final total sheet? ...

    4536057 | Excel | Latest reply: 4536057 Feb 3, 2015
    0 replies
  • Conditional Formating Closed

    I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...

    Mscrystal | Excel | Latest reply: xpcman Feb 3, 2015
    1 reply
  • Macros code Closed

    My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...

    Gokulcgs | Excel | Latest reply: TrowaD Feb 3, 2015
    10 replies