Office Software Forum

Ask a question
Search
Close
Results 4351 - 4400 of about 16,600
  • Auto Formatting [cell range] in multiple workbooks & sheets AD Closed

    Greetings Team, I need kind assistance to help creating a macro that can help my team in formatting their worksheets on 10s and 100s of workbooks i...

    ajaydwivediji | Excel | Latest reply: ajaydwivediji Jul 7, 2015
    0 replies
  • Creating a Macro Closed

    Hello, I am trying to create a macro that takes information from 6 separate sheets and pools them into one excel document. Essentially it would ta...

    Phil | Excel | Latest reply: Phil Jul 6, 2015
    0 replies
  • Excel Challenging - Please Help Closed

    Good Day Everyone. I'm stuck on the below situation and your help will be much appreciated. Let's call as: Worksheet] 1: WorkSheet]...

    gutoazuk | Excel | Latest reply: gutoazuk Jul 6, 2015
    4 replies
  • "no user access" to word 2007 docs???? Closed

    Hello, Running word 2007 on windows vista....after I wrote my docs and saved them to the desktop, I am no longer able to go back and open them up ...

    Crackup70 | Word | Latest reply: Ambucias Jul 5, 2015
    3 replies
  • Conditional Formatting Based on another cell Closed

    Hello, I'm trying to make a budget spreadsheet and want to format the cells if there is an omission. If a value has been entered into cell C3 ...

    Hannah | Excel | Latest reply: Mazzaropi Jul 4, 2015
    1 reply
  • word 2010 shows it is a dot.com file for some reason Closed

    Hello, I created a word doc and see the file, but when I try to open it, it comes up as a blank doc with no name. In the file listing, I see the file ...

    Sandy | Word | Latest reply: Ambucias Jul 4, 2015
    1 reply
  • Comparing two sheets Closed

    Hello guys, trying to do a spreadsheet at work for a stock take but a little bit more automated. The basic sheet is there but the csv that comes fr...

    Genaga | Excel | Latest reply: Genaga Jul 4, 2015
    0 replies
  • NEED AUTOMATICALLY CHANGED AMOUNT PERCENTAGE. Closed

    Hello, I need to help to ms excel sheet PERCENTAGE% 0.25 ENTER AMOUNT PERCENTAGE% 25,000.00 AUMATICALLY CHANGE 300000 AUMATI...

    KITTU | Excel | Latest reply: Mazzaropi Jul 3, 2015
    1 reply
  • Need macros solution, thanks in advance. Closed

    A B C D 887806009723 B00A3ZFW7I 887806009723 887806009730 B00A3ZFWUU 88780600973...

    Rakesh.Prakash | Excel | Latest reply: Rakesh.Prakash Jul 3, 2015
    0 replies
  • count if rows contains specific year Closed

    Hello, I need to count how many rows contains a date with a specific year, but with the following doesn't work: =COUNT.IF(D3:D3394;"*2014") I cha...

    Luke | Excel | Latest reply: Mazzaropi Jul 3, 2015
    1 reply
  • Microsoft Office Word 2007 picture paste Bug *same picture repea Closed

    I have found this BUG in Micrososft Word 2007, that I consider to be a SERIOUS ISSUE for Microsoft Office Suite. If you copy an image from a websi...

    amirz | Word | Latest reply: ac3mark Jul 2, 2015
    1 reply
  • Search string and copy row to another sheet Closed

    Hello, I am trying to use a macro which will look for a value in workbook1's column A and on finding that value, it will copy that whole row onto ...

  • Insert a row after "," in a cell Closed

    Hello, I have a 2 columns such as below: Name Rules John T3456,T4567,T6799 Cersei T5643,T4532 I would like to have a macro that...

    Nolwën | Excel | Latest reply: TrowaD Jul 2, 2015
    1 reply
  • Checkbox Closed

    I'm trying to use an Excel worksheet to take attendance. I've been able to find a solution using Apple's Numbers, but not so with Excel. Any ideas?

    Danny | Excel | Latest reply: TrowaD Jul 2, 2015
    1 reply
  • how to convert number to word in excel using formula Closed

    Hello, HOW TO CONVERT NUMBER TO WORD IN EXCEL USING FORMULA Configuration: Windows 7 / Chrome 43.0.2357.130

    JACK | Excel | Latest reply: TrowaD Jul 2, 2015
    1 reply
  • Copying text to different sheets based on criteria Closed

    Hello, I have a large speradsheet that records activity. I want to copy a row of items from one sheet to another if the status is 'done'. The if...

    Ronster444 | Excel | Latest reply: Ronster444 Jul 2, 2015
    2 replies
  • Excel macro copy cell based on date. Closed

    Hello, I got this kind of problem. Sheet1 for example cell A1 contains salesmen margin of a month and B1 contains drop list of months and Sheet2 has...

    Giedrius | Excel | Latest reply: Giedrius Jul 2, 2015
    0 replies
  • Apply a number to differentiate cells with same value Closed

    Hello, Can someone help me please? Here is my issue. So I have a long list of memberships. The issue I have is that I have one primary member that ...

    Excel newbie | Excel | Latest reply: xpcman Jul 1, 2015
    1 reply
  • Formula to sum information if it relates to certain text Closed

    Hi I am trying to analyse some data. In one column I have the description of the data and in another column I have the cost. The descriptions are all ...

    rachy88 | Excel | Latest reply: rachy88 Jul 1, 2015
    0 replies
  • apply a number to differentiate cell with same value Closed

    Hello, So I have a long list of memberships. The issue I have is that I have one primary member that has a spouse and 2 kids and each one needs a ...

    Excel newbie | Excel | Latest reply: Excel newbie Jul 1, 2015
    0 replies
  • A Macro to add data from sheet 2 to sheet 1 with repeating rows Closed

    Hi, i want to create macro that would take repeat rows from sheet 2 to sheet 1 X number of times e.g Sheet 2 would contain following data Code Des...

    Alibkh | Excel | Latest reply: Alibkh Jul 1, 2015
    0 replies
  • Macro for transferring data and automatically puts it in order Closed

    Hi all, There were so many topics to find macro's that i had to browse a lot but couldn't find what i was looking for on the moment so i thought i ...

    Dafydd | Excel | Latest reply: Dafydd Jul 1, 2015
    0 replies
  • how to convert date into words(english) in excel 2003 or 2007 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 Two Tho...

    sankar | Excel | Latest reply: sankar Jun 30, 2015
    2 replies
  • Input data from an input form to a permanent file Closed

    Hello awesome forum people! re: EXCEL worksheets Is there a way to be able to input data into a form on an EXCEL worksheet, containing Name, Addres...

    TimothyI | Excel | Latest reply: TimothyI Jun 30, 2015
    0 replies
  • Create Multiple Workbooks in a particular format from a Table Closed

    Hi, I want to create a macro wherein I can create multiple workbooks in a particular format from the data from a master table in a excel workbook. ...

    archmeister | Excel | Latest reply: TrowaD Jun 30, 2015
    1 reply
  • Error trying to populate new worksheet using macro Solved/Closed

    Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...

    AmitMehta96 | Excel | Latest reply: AmitMehta96 Jun 30, 2015
    2 replies
  • add string only if a text is present in a cell Solved/Closed

    Hello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...

    Deloro | Excel | Latest reply: Deloro Jun 30, 2015
    6 replies
  • FORMULA FORMATION HELP Closed

    Hi, I am just starting to understand Excel. I have a database that is used to enter our employee's time slip information, therefore, there is about a ...

    sweetiye_pie | Excel | Latest reply: sweetiye_pie Jun 30, 2015
    0 replies
  • combining 5 workbooks into one and removing duplicates Closed

    Hello, I have 5 address books saved onto separate spreadsheets and I would like to put them all together to make a master Address book. I would nee...

    1ExcelLearner! | Excel | Latest reply: 1ExcelLearner! Jun 30, 2015
    0 replies
  • Copy cell from another sheet where cell is value...? Solved/Closed

    Hi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...

    wzshop | Excel | Latest reply: wzshop Jun 30, 2015
    2 replies
  • macro for filling data from specific cell to another Solved/Closed

    Hi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...

    kayuf | Excel | Latest reply: kayuf Jun 30, 2015
    4 replies
  • Complicated if/then copy operation? Closed

    if (column range; eg, A8:A42) has any value, then Copy a cell (formula; in C2) two columns to the right of every cell in that column (A) that has a va...

    Spremo | Excel | Latest reply: Seth Jun 29, 2015
    3 replies
  • Rows And Columns Closed

    Hello, I have the ffg problem, i have a table as below: PN H1 H2 H3 H4 A AB AC AD AE B AB AD C AC AE D AB AC AE and I want it t...

    Siva | Excel | Latest reply: TrowaD Jun 29, 2015
    1 reply
  • Color cells if a corresponding cell is colored Closed

    Hello, I have columns a and z. If I color column z, say Z45, then A45 in column A should automatically be filled of the same color in z45. Not...

    Excel user | Excel | Latest reply: Excel user Jun 29, 2015
    0 replies
  • Nesting IF formula problem Closed

    Hello, I'm trying to set up a worksheet for student participation grades. Once I arrive at a participation average, I'd like to have a formula to...

    ESLmichael | Excel | Latest reply: venkat1926 Jun 29, 2015
    1 reply
  • Corrupt Outlook 2007 pst file Closed

    I am using Outlook 2007 on a Windows 7 system. Yesterday I needed to restore the system drive from a previous drive image, so I saved my Outlook pers...

    eliaschavera | Outlook | Latest reply: Ambucias Jun 28, 2015
    1 reply
  • Error: embedded Excel spreadsheet Solved/Closed

    Occasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...

    BrianGold654 | Excel | Latest reply: MatthewBon Jun 28, 2015
    1 reply
  • Lost BASIC11N.MSI Solved/Closed

    Hello, I cannot open MS Office Basic Edition 2003. I keep getting a message that says, "Missing BASIC11N.MSI file" I am missing the installer file. ...

    chocolateher... | Office Software | Latest reply: nuryev Jun 27, 2015
    6 replies
  • Excel -formula that excludes names if other colums have info Closed

    Hello, I have a list of 50 names in Column F, I used the Coutif formula to tally the total names in colum Q:5. ex. =COUNTIFS(F3:F1436,"=bill*"...

    SuckatExcel | Excel | Latest reply: venkat1926 Jun 27, 2015
    3 replies
  • Seeking macro for data copying Closed

    Hi everyone! I could use your knowledge, please! I'm creating a job tracking workbook, with a master sheet on Sheet1. Sheet2 is the blank worksheet...

    WSDalton | Excel | Latest reply: WSDalton Jun 26, 2015
    0 replies
  • Need to recover a pst file having a password. Solved/Closed

    Hello, I am in need of a soft utility which can be used to change/ recover the password set on a pst file in outlook. I have a user who has forgo...

    r.doyle31 | Outlook | Latest reply: r.doyle31 Jun 26, 2015
    3 replies
  • Excel Formulae - returning a zero value Closed

    Hello, I'm trying to set up an excel quotation sheet using the following formulae =SUM(B6*C6)+(D6*$E$3/1000) Cell E6 = the quantity Cell B6...

    Smudger1234 | Excel | Latest reply: Mazzaropi Jun 26, 2015
    1 reply
  • Macro that when name is entered creates copies of other sheets Closed

    Hello, I really appreciate anyone who can help. I have a Skills assessment Workbook where Managers are writing on Sheet 1 the names of their employ...

    joshualagan | Excel | Latest reply: joshualagan Jun 26, 2015
    0 replies
  • Add entries from a template to a masterlist Closed

    Hello, I have a excel template scorecard which I would like the answers from certain cells to record entries from the scorecard to a separate exce...

    Tami | Excel | Latest reply: vcoolio Jun 26, 2015
    34 replies
  • Email... outlook issues Closed

    Hello, I have just found out that a heap of my sent emails, have not actually been sent. They show in the sent box as having gone through ok. Also, ...

    Dianne | Outlook | Latest reply: Ambucias Jun 26, 2015
    1 reply
  • Master sheet to work sheets Closed

    I have an education master template and many other exact duplicate worksheets in a workbook. Each of the other worksheets is differentiated only by th...

    Wayvic | Excel | Latest reply: vcoolio Jun 26, 2015
    22 replies
  • How to Populate Multiple worksheets Closed

    I recently became the Treasurer of a VFW Post and am trying to find an inexpensive way to keep books that have been done by stubby pencil for years. ...

    dcg2122 | Excel | Latest reply: dcg2122 Jun 25, 2015
    0 replies
  • format cell Closed

    Hello, Can someone please help. Is there a formula to highlight a cell in a row in column P if it is not equal to the same row in column C. I wo...

    troubled | Excel | Latest reply: Mazzaropi Jun 25, 2015
    1 reply
  • Transferring Data Automatically in same Worksheet EXCEL Solved/Closed

    Hello, I'm finding a difficulty in transferring data from a number of cells to a table automatically. What I'm trying to accomplish here is that w...

  • Splitting spreadsheet by account number Closed

    Hello, I have a spreadsheet with around 500 accounts in. Each account contains a large number of rows of data. I would like to write a Macro so as...

    KarlOwen | Excel | Latest reply: KarlOwen Jun 25, 2015
    0 replies