Office Software Forum

Ask a question
Results 4601 - 4650 of about 16,600
  • Finding Closest Data Match Closed

    I am looking for the some help doing the following. Assume each cell in Column B is the target cell, and the data in Column A is to be interigated...

    nsettlemire | Excel | Latest reply: nsettlemire Apr 28, 2015
    0 replies
  • After Pushing Command Button on Sheet1, Sheet 2 Auto. opens up. Closed

    Hello, I have created a workbook with several pages of Information. One of the pages sheet2 ("Order Form") will figure information. There is a ...

    Simpleminded... | Excel | Latest reply: MaxStart Apr 28, 2015
    1 reply
  • Counting the number of Times a Cell changes colors and Archive Closed

    Hello, Hello, I would like to count the number of times a cell goes green and archive it. How can I do this? Thank you for any help you can give. ...

    freygreer | Excel | Latest reply: MaxStart Apr 28, 2015
    1 reply
  • Auto. copy a row of data onto another sheet using conditions Solved/Closed

    Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...

    DON'T KNOW | Excel | Latest reply: Don't Know Apr 28, 2015
    8 replies
  • Auto populating multiple sheets Closed

    Hello, I have read some of the Qs and As and they are scary if you don;t know Excel. ! Is there not a simple formula for entering data into a sp...

    DumbUser | Excel | Latest reply: MaxStart Apr 28, 2015
    1 reply
  • macros to copy conditional data Closed

    Hello, I am beginner in macros and am trying a macro code which does the following. I have 2 sheets by name sheet1 and sheet2, sheet1 consists of...

    solo | Excel | Latest reply: TrowaD Apr 28, 2015
    1 reply
  • Amexxx1 Closed

    Hello, I don't seem to be able to run this simple code; I copy and paste but when trying to run in my General tab by pressing alt+F8, no macro is ...

    Amexxx1 | Excel | Latest reply: TrowaD Apr 28, 2015
    3 replies
  • Macro to Search for a word and put a code on the cell next to it Solved/Closed

    Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...

    A.E | Excel | Latest reply: A.E Apr 28, 2015
    2 replies
  • Archived Mails issue Closed

    Hello, If the archived file is over written and the data is lost then is there any way to recover my old mails? Please suggest as one my approx...

    Sumeet | Outlook | Latest reply: Sumeet Apr 28, 2015
    0 replies
  • Count if Based on Cell Color & Date Range in a Column Closed

    Hello, Any help on this would be greatly appreciated. I am trying to build a macro. That would look at a start date and end date manually entered...

    vj | Excel | Latest reply: vj Apr 28, 2015
    0 replies
  • Automated Data Insertion Closed

    Hello, I'm glad I have found this forum. On generic spreadsheets I can maneuver fairly well, but I believe I have stepped off a steep ledge here....

    j518 | Excel | Latest reply: j518 Apr 27, 2015
    0 replies
  • Macro which can be calculated every month Rent Closed

    I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are differ...

    VKumar2210 | Excel | Latest reply: xpcman Apr 27, 2015
    1 reply
  • VBA that Copies/Paste rows based on Amount Closed

    Hello, I have a spreadsheet that has our products. After the product is chosen then there are hundreds of options to choose from. I hav...

    Simpleminded... | Excel | Latest reply: SimplemindedDwight Apr 27, 2015
    0 replies
  • Can't open scanned document when broken up into 2 PDF's Solved/Closed

    When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...

    shujaaishak | PDF | Latest reply: thierryhauet Apr 27, 2015
    1 reply
  • search functionality,copy and paste Closed

    Hello, I am new to VBA and looking for a search functionality macro.I am looking for three steps;- There are three sheets,in sheet one i just cre...

    pinki | Excel | Latest reply: pinkipanchal Apr 27, 2015
    2 replies
  • Push data to new table Closed

    Hello Everybody! I am trying to build a tool for our Company which helps plan future collection and eventually should turn into a Gantt. So... i...

    MaozH | Excel | Latest reply: MaozH Apr 27, 2015
    0 replies
  • repair outlook express dbx file Solved/Closed

    has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...

    altairbishara | Outlook | Latest reply: ruudromein Apr 26, 2015
    2 replies
  • All my office apps are not showing its icon. Closed

    Hello, I am using Office 2013. Now I can only see the windows generic icon instead of the Office icon. I am using the Professional Plus 2013 full ve...

  • if cell contains Closed

    Hello sir, Actually I wanted to know is there any formula if column contain description like - qty box size 1kg - ...

    NITIN | Excel | Latest reply: NITIN Apr 25, 2015
    0 replies
  • Exam Layout Closed

    I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to start? I h...

    Dibble | Excel | Latest reply: Dibble Apr 24, 2015
    0 replies
  • How do I count the number of times a cell changes color Closed

    Hello, I would like to count the number of times a cell goes green and archive it. How can I do this?

    freygreer | Excel | Latest reply: freygreer Apr 24, 2015
    0 replies
  • Send data from Raw Data sheet to numerous Specific sheets Closed

    Hello, Trying to make a document in whcih my laboratory can track the reagents coming in. I have a source sheet, where all the recieved reagent...

    Steffan | Excel | Latest reply: vcoolio Apr 23, 2015
    1 reply
  • Copying data directly to a specific sheet Closed

    Hi there! I am trying to create a spreadsheet in which I can enter information on one sheet and it automatically carries across that info to the c...

    robsdyer | Excel | Latest reply: vcoolio Apr 23, 2015
    1 reply
  • Conditional Formatting Closed

    I am trying to set up formatting for five different colums as to when I click on the cell, it will give me a color based on the title. I have the cell...

    amarsh | Excel | Latest reply: amarsh Apr 23, 2015
    0 replies
  • A macro for creating multiple file from a source excel file Closed

    My source file containing different codes in column 11 and I require a separate file to be created from this source file by filtering the column 11 by...

    st | Excel | Latest reply: st Apr 23, 2015
    0 replies
  • date format Closed

    Hello, i have date format like 20131203 (year month day) i want to change it as 03.12.2013. please suggest Configuration: Windows 7 / Chrome 2...

    soni | Excel | Latest reply: kieferschild Apr 23, 2015
    1 reply
  • it can not find the files Closed

    Hi i installed your program to fix the corupted files the system can not find the files it dont show in the list how to do that???

    Artebronzo | Excel | Latest reply: Ambucias Apr 23, 2015
    1 reply
  • Count overlapping Days Closed

    Hello, I'm trying to count the # of days overlapping between 2 different ranges of days. I'm using a max and min formula and tried some if statement...

    patt7664 | Excel | Latest reply: patt7664 Apr 23, 2015
    0 replies
  • How to insert blank row with variable input in next column Closed

    Hello, I want to insert the row based on the input value in next column, for example. A 4 B 3 C 4 D 4 after A there should be 3 rows to be in...

    Srinivasan | Excel | Latest reply: Srinivasan Apr 23, 2015
    0 replies
  • A macro to name worksheets based on a list Closed

    Hello, btw how to name worksheet without creating new worksheets, i've already have data in each worksheet so i dont need to create a new one.. I ...

    nilam28 | Excel | Latest reply: nilam28 Apr 22, 2015
    2 replies
  • Microsoft 2007 Closed

    Hello, Hi I have xp pro on my computer, when I try to open any saved documents in what ever format in word, excel or publisher it comes up blank ...

  • Compare data between two Excels containing more than 200 columns Closed

    Hello, We are in the middle of a production migration and we need to compare two reports that are generated two weeks apart and find the fields th...

    ryan | Excel | Latest reply: ryan Apr 22, 2015
    0 replies
  • Macro for blanks Solved/Closed

    Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...

    Connie | Excel | Latest reply: vcoolio Apr 21, 2015
    3 replies
  • sum if Solved/Closed

    Hello, Pls help me find the formula for below situation I am trying to sum up 4 when a cell in the Column A contains End with XX7. Otherwise it...

    senthil | Excel | Latest reply: senthil Apr 21, 2015
    0 replies
  • space bar problem Closed

    Hello, my space bar shows dots instead of space in word 2007 Configuration: Windows 7 / Mozilla 11.0

    mahmoud100000 | Word | Latest reply: TrowaD Apr 21, 2015
    1 reply
  • Generate ID for cells containing same values Closed

    Hello, I am trying to generate the same IDs for cells containing same values and different IDs for cells containing different values I have for e...

    cris01 | Excel | Latest reply: TrowaD Apr 21, 2015
    1 reply
  • Copy Selected workbook/worksheet with specific data into another Closed

    Hi, I plan to copy selected workbook and sheets listed in the ListBox where it will copy data at cells(52, "R") into another workbook with sheets(...

    nurulfarahin | Excel | Latest reply: nurulfarahin Apr 21, 2015
    0 replies
  • How do I not get the sum of a column when it contains text? Closed

    Hello All, I have an excel file in which I am adding the numbers of a column, but sometimes the column I am summing may have text in one of the cells ...

    xrqexcel | Excel | Latest reply: RayH Apr 20, 2015
    1 reply
  • Date of birth in words Solved

    Hello, How can I enter date of birth in words in Excel?

    pinckroje | Excel | Latest reply: TrowaD Apr 20, 2015
    1 reply
  • Help with Formula to Find/Remove if same data in another cell Closed

    Hello, I am having some trouble determining a formula that would help me with my problem below. I have a large Excel sheet and am hoping you can ...

    Kristen | Excel | Latest reply: TrowaD Apr 20, 2015
    1 reply
  • converting macro into function Closed

    Hello, How to change the below macro into a function, so that, we could invoke this macro as =image() Sub Picture() Range("A6").Select 'This...

    Ram | Excel | Latest reply: TrowaD Apr 20, 2015
    1 reply
  • Re:Design Mode Coding Closed

    Hi there, I have an issue of auto transferring the data of the same category to 2 different sheet in the same folder. Please kindly advise! I need ...

    ANDYLAMSC | Excel | Latest reply: ANDYLAMSC Apr 19, 2015
    0 replies
  • Repair corrupt .PST & .OST files Closed

    What methods exist to repair corrupt Outlook 2003 .PST & .OST files besides using the scanpst and scanost utilities? An Outlook 2003 user frequentl...

    DarColl | Outlook | Latest reply: DarColl Apr 18, 2015
    0 replies
  • conditional statements Closed

    I am needing a formula to accomplish the following ... If student age is 21 on September 1st then make the cell green If student age is 21 after S...

    texasbear | Excel | Latest reply: texasbear Apr 17, 2015
    0 replies
  • Get value of last cell in column B from a closed workbook Closed

    Oh Dear - back again... Im trying to improve a macro I have been working on. It works as far as it goes, but I realsed that data needed to be input...

    BrianGreen | Excel | Latest reply: BrianGreen Apr 17, 2015
    3 replies
  • Re-Occurring Dates with Values Closed

    Hello, I am trying to calculate the months, quarters or semi-annual intervals between two dates, but then populate a value (numerical) in the calc...

    Phil | Excel | Latest reply: Phil Apr 17, 2015
    0 replies
  • If data exists, copy multiple cells into one cell Closed

    Hello, Excel 2010. I have several cells on sheet 1 that may or may not contain text. If they do, I want to copy that data from the group of cells ...

    Andrew | Excel | Latest reply: Andrew Apr 17, 2015
    0 replies
  • Conditional formatting cells A and B based on value in C Closed

    Hello, As you can see from picture: I want to fill with red colour cells A and B if value from C is equal with value from A. I want to do this wi...

    easyyu | Excel | Latest reply: easyyu Apr 17, 2015
    2 replies
  • Powerpoint 2003 gives error Closed

    Hello friends! I need help. Powerpoint 2003 gives the following error: "Powerpoint can't create the storage required for an inserted or linked obj...

    doleschall | PowerPoint | Latest reply: xpcman Apr 16, 2015
    1 reply
  • unable to open saved outlook .pst file from outlook Closed

    i get an error (cannot open .pst is not a program folders file). i tried everything that experts exchange offered. one of the ways was to run scanpst...

    afonsocunha | Outlook | Latest reply: afonsocunha Apr 16, 2015
    0 replies