Office Software Forum

Ask a question
Search
Close
Results 1151 - 1200 of about 16,600
  • Getting rows from one sheet to populate to another Closed

    Hi, I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically popul...

    Ninabella84 | Excel | Latest reply: ac3mark Nov 8, 2017
    1 reply
  • max(if..? Closed

    hello, i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i wa...

    M_me | Excel | Latest reply: M_me Nov 8, 2017
    1 reply
  • Outlook 2010 configure for Gmail Solved/Closed

    I have created an account and tried configuring through Outlook 2010. Though the test message is successful for sending and receiving, outlook is able...

    MadanKrishna... | Outlook | Latest reply: Ambucias Nov 8, 2017
    10 replies
  • Word 2013 repair Closed

    Hello, Word came up with an error message saying I had to 'repair' it so I followed the instructions and used Online Repair. I know it takes a lon...

    Allieg | Word | Latest reply: Ambucias Nov 7, 2017
    1 reply
  • Can you draw a picture in the Microsoft Word window? Closed

    Can you draw a picture in the Microsoft Word window? I need to draw a kitchen cabinet chart. but I don't know how to use graphic design software. I...

    AshleyMcKinnel | Word | Latest reply: Ambucias Nov 7, 2017
    1 reply
  • calculation using alphabet instead if number Closed

    Hello, Dear Sir, If I assumed A=1 B=2 C=3 D=4 F=5 G=6 H=7 I=8 J=9 K=0 For example Numeric column > 9949 = JJDK 9949 ...

    nazim | Excel | Latest reply: xpcman Nov 7, 2017
    1 reply
  • Copying formula by changing only one rule. Solved/Closed

    Hello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...

    shan_asa | Excel | Latest reply: shan_asa Nov 7, 2017
    2 replies
  • How to use index function to match from different worksheets? Closed

    hi there, please let me know how can i use index match from different worksheets. as i need to use index function for more than one worksheets...

    abhininan | Excel | Latest reply: abhininan Nov 7, 2017
    0 replies
  • Month and year format in forms in excel Closed

    Hello, Hello sir I am using forms to enter data. In form i used drop down list function to select particular month from pre-entered months from Nam...

    kishore.koka | Excel | Latest reply: kishore.koka Nov 7, 2017
    4 replies
  • Use a macro to copy a value from one sheet to another Closed

    Greetings, I'm looking for help modifying or creating a macro to copy the value of a specific cell on one sheet to a specific cell on another sheet. ...

    azibuck | Excel | Latest reply: azibuck Nov 7, 2017
    0 replies
  • Automatically creating sheets based on a Master sheet Closed

    I am looking for an easy way to create new worksheets, based on a master sheet. The master sheet is basically a calendar for a week. It has a Mond...

    Tricky_Micky | Excel | Latest reply: Tricky_Micky Nov 7, 2017
    0 replies
  • Need copy data from specific sheet/cell to another Closed

    I have a macro that successfully takes a value from one sheet, "Job", and copies another worksheet, "Entry", and names the sheet for the value in a ce...

    azibuck | Excel | Latest reply: azibuck Nov 6, 2017
    0 replies
  • excel Closed

    I have images on pdf of 10pages . I want to insert only 2 images ,which need select wrt to pages no

  • scheduling spreadsheet Closed

    Hello, I am trying to make a scheduling spreadsheet where I can input a persons name and shift on a master page and it will auto populate to an as...

    spamonstick | Excel | Latest reply: spamonstick Nov 6, 2017
    0 replies
  • What is an alternative function for SpellNumber in Excel? Closed

    if the function of ( SpellNumber) not available , then what to do

    Ahmed | Excel | Latest reply: Ahmed Nov 6, 2017
    0 replies
  • How to use the filter function on a column in Excel? Closed

    Hello, I'm having the same issue trying to use the filter function on a column. I have tried the solutions suggested, but none seem to work. Thi...

    Lynn | Excel | Latest reply: Lynn Nov 5, 2017
    0 replies
  • macro related showing in a fixed cell Closed

    Hello,greetings, I am running a macro, but it is showing in a fixed cell where initially the micro is created instead of in required cell. for ex: if ...

    Srinivas B | Excel | Latest reply: Srinivas B Nov 4, 2017
    0 replies
  • Autopopulating multiple sheets from main sheet by date Closed

    Hello, My name is Ana and I have a situation. Every day we have hunďreds of rows with diffrent info about our customers. On column H we have cells...

    Anabreha | Excel | Latest reply: Anabrega Nov 4, 2017
    4 replies
  • How to get a product key for Microsoft Office 2010? Closed

    how to get a product key on Microsoft Office 2010?

    Zdravkovska | Office Software | Latest reply: Ambucias Nov 3, 2017
    1 reply
  • Automatic add and sub Closed

    Hello, Hi everyone,I need help from u regarding excel formulas and workout basics.My question is..If i add particular row or column it should be a...

    Dinesh | Excel | Latest reply: ac3mark Nov 2, 2017
    1 reply
  • Looking to enter a name and then want it to be pasted in x numbe Closed

    Hello, Looking to enter a name and then want it to be pasted in x number of rows. Then enter a new name in the x + 1 row and want that pasted y n...

    mfinley | Excel | Latest reply: ac3mark Nov 2, 2017
    1 reply
  • VBA macro loop Closed

    Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...

    bjj127 | Excel | Latest reply: ac3mark Nov 1, 2017
    1 reply
  • How to compare 2 sheets in Excel? Closed

    Hello, I have to come 2 sheets sheet 1 Rev 0 Sheet 2 Rev 1 Sheet 3 diference between sheet 1 & Sheet 2

    9833918859 | Excel | Latest reply: 9833918859 Nov 1, 2017
    0 replies
  • Can't open documents with a W. Solved/Closed

    In my documents, I have some items with PDF and some with a W. When I try to open the ones with a W, I am asked to sign up with Word. How can I open t...

    Bob.C | Word | Latest reply: Bob.C Nov 1, 2017
    3 replies
  • compilation Closed

    Good day to all, I am looking for help and I have asked all the knowledgeable people at work to no avail. As per the uploaded picture, I am lo...

    Wade526 | Excel | Latest reply: Wade526 Oct 30, 2017
    2 replies
  • How to compare a range of data in Excel? Solved/Closed

    Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...

    shan_asa | Excel | Latest reply: shan_asa Oct 29, 2017
    4 replies
  • Ms Visio setup free download Solved/Closed

    i got a little challeng dowenloading free Ms visio setup could u send me please

    belaynew | Office Software | Latest reply: huda-rezk Oct 28, 2017
    2 replies
  • Transferring data from page to page and automatically sorting Closed

    I'm creating a grocery list in excel and I am struggling with one big part of it. - Page 1 is dedicated to meal planning, page 2 is an ingredient c...

    SmithFamily | Excel | Latest reply: SmithFamily Oct 28, 2017
    0 replies
  • How to use VBA to send emails from Excel? Closed

    Hello, I really need some help! I need to create a macro which will send emails to a specific email address within excel when a cell is updated. ...

    Tara B | Excel | Latest reply: Tara B Oct 28, 2017
    0 replies
  • Adding and subtracting using Vlookups Closed

    Hello, =IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ") I need to add in another vlookup to the formula but have tried a few...

    libseal | Excel | Latest reply: ac3mark Oct 27, 2017
    1 reply
  • Pictures insertion Closed

    Hello TrowaD, With this code, pictures are linking to the file and not inserting. i.e. If I send the file to someone in email they cant these picture...

    anjumargams | Excel | Latest reply: ac3mark Oct 27, 2017
    1 reply
  • How to use VBA to loop copy and paste Closed

    Hello, I have a formula in raw # 12 (E12: TNF12) and would like to paste this formula in the raw below (raw# 13) and then copy and paste its conte...

    maddalenamori | Excel | Latest reply: ac3mark Oct 26, 2017
    3 replies
  • How to migrate data to another table and use a search box? Closed

    Questions! I have a database-type table with names, numbers, addresses and what have you. I would like to make a second, single-rowed table that s...

    venn47 | Excel | Latest reply: venn47 Oct 26, 2017
    0 replies
  • Formula in numerical format changes to date format Closed

    Hello, Actually, there is a problem arose. In an excel sheet where ever I put a formula changed from number to date format. Don't understand the...

    Shaynam | Excel | Latest reply: Shaynam Oct 26, 2017
    0 replies
  • Excel VBA macro to split rows, then copy and past Closed

    good day, please i need vba code, that split one row to multiple rows and copy, paste it in another worksheet, and the source worksheet have about 100...

    bashir2015 | Excel | Latest reply: bashir2015 Oct 26, 2017
    0 replies
  • Date Format not reflected in sheet Closed

    Hello, Guys,, help.. How do I convert the date in excel? Now it shows mm/dd/yyyy. I've changed the Format to dd/mm/yyyy but the data did not chang...

    NHAZA | Excel | Latest reply: NHAZA Oct 25, 2017
    0 replies
  • Copy Paste Special Values Macro Closed

    Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and t...

    usrvl | Excel | Latest reply: ac3mark Oct 25, 2017
    9 replies
  • How to update data of Sheet2 in Sheet1 with Excel? Closed

    Hello, I have data in SHEET1 A1-5 A2-6 A3-9 I am entering data in SHEET2 A1 B1 C1 D1=SHEET1!A1-C1 I want to update this D1 value...

    bhupesh | Excel | Latest reply: ac3mark Oct 25, 2017
    1 reply
  • Use conditional formatting to highlighting cells based on Name Closed

    Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a sepe...

    Kirk_92 | Excel | Latest reply: ac3mark Oct 24, 2017
    1 reply
  • VBA for copying from data entry sheet to corresponding sheets Solved/Closed

    Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...

    OMCHABRIA | Excel | Latest reply: TrowaD Oct 24, 2017
    7 replies
  • How to extract data using VBA in Excel? Closed

    Hello, Need some help to create a VBA for Excel 2016.. Basically i have 2 workbooks. Workbook 1 is Master File. Workbook 2 is the monthly d...

    hui1122 | Excel | Latest reply: ac3mark Oct 20, 2017
    1 reply
  • Calculate a percentage when the values are text Closed

    I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. ...

    Duwop01 | Excel | Latest reply: ac3mark Oct 19, 2017
    1 reply
  • Copy Rows from one sheet to others based on a condition Solved/Closed

    Hello, I have a workbook for our teams budget that has 1 master sheet with 28 columns. The master sheet will be updated with more rows often (addi...

    EmrsnMktgAnyst | Office Software | Latest reply: TrowaD Oct 19, 2017
    6 replies
  • Very New ... Need some help. Closed

    Hello, I've created a spreadsheet for my cruise inventory thought it would help keep track as a new travel agent first time really using excel in ...

    TuhchKeys | Excel | Latest reply: TuhchKeys Oct 19, 2017
    0 replies
  • Excel Macro not working, any ideas? Closed

    Hello, I work at a university and no one here knows anything about Macros. I had a new computer built and lost all my Macros a previous coworker...

    elb5035 | Excel | Latest reply: elb5035 Oct 18, 2017
    0 replies
  • How to count the number of occurrences in a range Closed

    I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...

    STUDENTFJR | Excel | Latest reply: Mazzaropi Oct 17, 2017
    3 replies
  • Formula for Unique ID's following a predefined rule Closed

    Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...

    Zolliez | Excel | Latest reply: TrowaD Oct 16, 2017
    1 reply
  • Dates conversion Closed

    Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...

    Herodia | Excel | Latest reply: TrowaD Oct 16, 2017
    1 reply
  • Reformat date field to plain text Closed

    I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...

    Bunk | Excel | Latest reply: vcoolio Oct 15, 2017
    1 reply
  • How to find a product key for MS Office 2010? Closed

    HOW CAN I GET PRODUCT KEY OF MICROSOFT OFFICE 2010?

    ojie2380 | PowerPoint | Latest reply: Ambucias Oct 15, 2017
    1 reply