Office Software Forum

Ask a question
Search
Close
Results 2601 - 2650 of about 16,600
  • Another Libra Base Question Closed

    Woe is me. Im going to cry :( I need to know how to do basic arithmatic with dates in Libre Base queries. All I want to do is find the number...

    BrianGreen | Office Software | Latest reply: BrianGreen Aug 20, 2016
    5 replies
  • help regarding a pricing sheet Closed

    Hello, I'm looking for help regarding a pricing sheet I'm trying to create on excel. I have my quantity in C5 = 2500 and cost in C15 = 75,000 if C...

    Kev1027 | Excel | Latest reply: Kev1027 Aug 19, 2016
    4 replies
  • Changing colour of cell once multiple other cells contain text Closed

    Hello, I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomple...

    VanessaR | Excel | Latest reply: fdibbins Aug 19, 2016
    1 reply
  • Count if formula Closed

    Hello, I have a Excel file where i have specific paths of the files and i Need a formula where it should reefr that cell path and Count the rows w...

    waseem | Excel | Latest reply: ac3mark Aug 19, 2016
    1 reply
  • format the color font depending on the value of another cell Closed

    Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell? I want my text in colum A B C to be the font ...

    SADY1106 | Excel | Latest reply: Mazzaropi Aug 19, 2016
    1 reply
  • VBA looping/range Closed

    Hello, im attempting to run this but I want to add in separate loops that search for certain keywords. currently this successfully will find one and m...

    camtognetti | Excel | Latest reply: camtognetti Aug 19, 2016
    0 replies
  • how do you custom sort data in a pivot table Closed

    Hello, I need to sort the largest amount in a pivot table how is this done ? Configuration: Windows 7 / Mozilla 11.0

    vfelts | Excel | Latest reply: vfelts Aug 19, 2016
    0 replies
  • excel formula to move a word from one cell to another Closed

    Hello, Hi what is the formula to move anything that begins with "other: " to the adjacent cell Advocate at Home Advocate at Home Other: Bria o...

    vfelts | Excel | Latest reply: vfelts Aug 19, 2016
    0 replies
  • Creating Remarks from grades Closed

    How do I create corresponding remarks against letter grades?

    Ssysie | Excel | Latest reply: Mazzaropi Aug 19, 2016
    1 reply
  • insert row based on criteria in EXCEL Closed

    hi friends, i'll get same data in two different sheet with a small changes, i will compare sheet one and sheet two, to create new sheet eg. (...

    raja | Excel | Latest reply: raja Aug 19, 2016
    0 replies
  • Creating a GANTT Chart with Calendar List of Tasks Closed

    Hello, Need help in creating a GANTT chart with a calendar function. For example, if according to the GANTT Chart Task 1 is due on the 25th of Octo...

    Oliver | Excel | Latest reply: Oliver Aug 19, 2016
    0 replies
  • Macro to make the same graphs on multiple sheets Closed

    Hello I have multiple sheets of data, all with the same formatting (although different numbers of data sets) formatted as a table. I am trying to ...

    Artemis | Excel | Latest reply: Artemis Aug 18, 2016
    0 replies
  • Insert 1 result if a cell contains one of several possibilities Closed

    Hi All, I am new to this level of excel - but what I need is a formula that does the following : Insert if an adjacent cell contains one of up ...

    Dan | Excel | Latest reply: Mazzaropi Aug 18, 2016
    1 reply
  • Copy values only when using a filter Closed

    Hello, VBA below, this is doing exactly what I want... however I can not get it to copy values only...not the formulas and a list which is in a co...

    Debs269 | Excel | Latest reply: vcoolio Aug 18, 2016
    3 replies
  • Problems using outlook after changing Gmail password Closed

    Using Outlook 2007. I have 2 email accounts which both worked fine. Yesterday I changed my password for both accounts through Gmail online. Account...

    Lamouline99 | Outlook | Latest reply: Ambucias Aug 17, 2016
    1 reply
  • Preparing a commission worksheet from an excel spreadsheet Closed

    Hello, I am a payroll specialist. Every two weeks I run a report for all employees who have funded loans. I copy that information into another w...

    mel | Excel | Latest reply: mel Aug 17, 2016
    0 replies
  • Macro Closed

    Hello, in excel 2013 I have column of cells a:2:a4955 of the cell.interior.colorindex = 3 then I need to return "red" I can't get his to work.

    KarenPostell | Excel | Latest reply: KarenPostell Aug 17, 2016
    1 reply
  • copy paste data from one sheet to another automatically Closed

    Hello, First of all thanks for your wonderful site. I have a large set of information on one sheet. Column b has the name of the sheets in the ...

    ssdgeek | Excel | Latest reply: ssdgeek Aug 17, 2016
    12 replies
  • Copy and paste Closed

    Hello, i haven't done much lately with VBA so need some help please Copying from Sheets("Input (2)") to Sheets("New Items Added") The rows o...

    Debs269 | Excel | Latest reply: Debs269 Aug 17, 2016
    0 replies
  • without key activation Closed

    Hi I have some problem in ms office 10 getting error code 0x8007007B Its product code activation error code How to activate ms office 10 without ...

    amolsankpal | Office Software | Latest reply: Ambucias Aug 17, 2016
    1 reply
  • Create Duplicate Sheet Closed

    Hi all, Is it possible to create a worksheet automatically in the same excel workbook. For e.g i have a sheet "1" with some content (includes f...

    MAasifkhan | Excel | Latest reply: PoulJ Aug 17, 2016
    1 reply
  • Auto-copy rows from one tab to another based on cell value Closed

    Hello! I'm really hoping this works to get a response because I am stumped. I've read a lot of sites and lot of similar posts but nothing seems to...

    Marissa Garrock | Excel | Latest reply: fdibbins Aug 16, 2016
    1 reply
  • Nested if functions using time values Closed

    Hello, I have an excel formula here, but it wont work. =IF(AND(G2>=TIMEVALUE("06:00:00"))*(G2=TIMEVALUE("00:00:01"))*(G2

    Dannnnn0710 | Excel | Latest reply: fdibbins Aug 16, 2016
    2 replies
  • Auto Fill in for List - based on another cell's value Closed

    Hi! I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different...

    seh09 | Excel | Latest reply: fdibbins Aug 16, 2016
    1 reply
  • Copying data from 1 sheet to another using a macro Closed

    Hello, I am trying to copy data from a specific cell on one sheet (Invoice) to the next blank cell in another sheet. My macro was working well in ...

    Jen | Excel | Latest reply: Jen Aug 16, 2016
    0 replies
  • Cut paste data into the left cell of the row below Closed

    Hello, I have a worksheet with hundreds of thousands of rows and its conditionally formatted to show 2 different colors. Here is a screenshot of ...

    Yathin | Excel | Latest reply: Yathin Aug 16, 2016
    0 replies
  • Pdf now in word document Closed

    Hello, I downloaded adobe reader and now all my PDF files is in word and not opening in pdf like it should be. Even my mail i cant open in pdf. Pl...

    Office | PDF | Latest reply: richmondmiles Aug 16, 2016
    1 reply
  • how could I do automatically find the price Closed

    Hello, I have question for Excel, it is small hotel booking system? If I have for example 6 rooms, and they have all different prices, i.e. 1...

    Damir | Excel | Latest reply: Mazzaropi Aug 16, 2016
    1 reply
  • Copy row if criteria is met macro Closed

    Hello, I am looking to make a macro that will copy the entire line from sheet 1 to sheet 2 if criteria from column H is met. Essentially if th...

    Ram | Excel | Latest reply: Ram Aug 16, 2016
    4 replies
  • Starting new sheet from info gained in sheet one Closed

    Hi I am trying to replace a hard cover book and a manually written piece of paper with the spreadsheet. I work in the building industry doing insu...

    RCJ1975 | Excel | Latest reply: RCJ1975 Aug 15, 2016
    0 replies
  • copy range of cells and paste them multiple times Closed

    Hi all, My VBA / Coding skills are basic and I've been googling to try to find an answer to my question to no avail. I'm trying to copy a range of...

    bm63081 | Excel | Latest reply: bm63081 Aug 15, 2016
    0 replies
  • Compare columns and create list of duplicates Solved/Closed

    Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...

    CarlosIRL | Excel | Latest reply: CarlosIRL Aug 15, 2016
    2 replies
  • Auto Generate a copy of a Template Worksheet and rename each Closed

    Hello, I am very new to Excel and VB and am trying to create a macro that will do the follow; 1. Create a copy of a template worksheet (named Tem...

    ChukieD | Excel | Latest reply: vcoolio Aug 15, 2016
    2 replies
  • Conditional Formating of cells Closed

    Hello, I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right t...

    Spike | Excel | Latest reply: fdibbins Aug 15, 2016
    1 reply
  • help need sample of master sheet Closed

    hi can give a sample of using excel in exam committee

    zead | Excel | Latest reply: zead Aug 14, 2016
    0 replies
  • Copy data from one sheet 1 to sheet 2 only if text Closed

    Hello, I have sheet 1 tracking a lot of different information (Client name, date in, date put etc...) for 2 machines. (Machine A & Machine B) N...

    Loo0105 | Excel | Latest reply: fdibbins Aug 14, 2016
    1 reply
  • need help to macro my invoice number Solved/Closed

    Hello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...

    Janit | Excel | Latest reply: ac3mark Aug 12, 2016
    6 replies
  • Alphabetical arrangement Closed

    What formula do you use to arrange items or values in alphabetical order in Excel?

    profebo1 | Excel | Latest reply: profebo1 Aug 12, 2016
    0 replies
  • Pivot table help Closed

    Hello, I really hope someone can help me out with this. I would like to know how can I get excel to automatically fill the data (I specified wi...

    dgname | Excel | Latest reply: dgname Aug 12, 2016
    0 replies
  • Excel Macro Copy if Criteria is met in a column Closed

    Hello, I have two sheets and the plan is after the "TotalScores" sheet is filled out, the second sheet "NOPA" will be filled with a macro. For...

    Ram | Excel | Latest reply: Ram Aug 12, 2016
    0 replies
  • search value error Solved/Closed

    HI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...

    Stu | Excel | Latest reply: Mazzaropi Aug 12, 2016
    3 replies
  • Selecting the different Range of cells based on values Closed

    Hi all, consider the Excel sheet A B C D 1 NAME CITY AGE CLASS 2 ALEX NEWYO...

    AKILSYED | Excel | Latest reply: ac3mark Aug 11, 2016
    1 reply
  • Information automatically updated Closed

    Hi, So I am creating a file for my boss on excel 2016 that I want to automatically update information from one table to the other without me havin...

    justahumblea... | Excel | Latest reply: ac3mark Aug 11, 2016
    1 reply
  • Need help with conditional formatting. Closed

    Hello, I need to have my spreadsheet enter a date that is 6 months (180 days) from an original date once it is entered. I have 2 columns - Date Pl...

    JessaSteele | Excel | Latest reply: Mazzaropi Aug 11, 2016
    1 reply
  • Searching and Replacing Dates Closed

    I need to search and replace dates. For example, in one row (representing one employee), all dates prior to 8/9/16 and replace those dates with 8/9/1...

    FranBacAero | Excel | Latest reply: TrowaD Aug 11, 2016
    1 reply
  • automatic numbering of invoices in excel Closed

    How do I create a macro for sequential invoice numbering in Xcel

    Steve | Excel | Latest reply: TrowaD Aug 11, 2016
    1 reply
  • Need a formula to compare two columns and return a value of 1 Closed

    Good Morning, I need a formula that will compare two different columns and then return a value of one if certain criteria are met. The criteria: ...

    alinville | Excel | Latest reply: TrowaD Aug 11, 2016
    3 replies
  • Once the value is one, change cell in the right column Closed

    Hello, I am in a struggle here :/. Let's say I have a table with 2 data columns. The first one is "phase", the second one is a "due date" which...

    Eucram | Excel | Latest reply: Eucram Aug 11, 2016
    0 replies
  • Invoice sequential numbering Closed

    Hello, excel macro auto invoice numbering

    Steve | Excel | Latest reply: Steve Aug 11, 2016
    0 replies
  • =IF(SEARCH("BP",Sheet1!B4),Sheet1!B3,"") Closed

    The value for false refuse to come up as a blank cell in my formula to find and copy a cell if it contains certain initials. why? =IF(SEARCH("BP",S...

    Stu | Excel | Latest reply: Stu Aug 10, 2016
    0 replies