Office Software Forum

Ask a question
Search
Close
Results 2651 - 2700 of about 16,600
  • 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
  • Nested If Statement not working Solved/Closed

    Hello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...

    Mimi | Excel | Latest reply: Mimi Aug 10, 2016
    2 replies
  • Macro - pictures to excel acc to name Solved/Closed

    Hi, I have an issue - I checked all forums I could, but with office 2013 and changed excel functions, I got lost. My excel has pictures names in...

    Northimn | Excel | Latest reply: Northimn Aug 10, 2016
    2 replies
  • Pull just the description from old spreadsheet to new spreadshee Closed

    Hello, I have two spreadsheet one (new) that has parts and pricing. I have an old spreadsheet that has same parts and old pricing and descriptions....

    Sunshine | Excel | Latest reply: Sunshine Aug 10, 2016
    0 replies
  • copy data from monthly workbooks paste in a single workbook Closed

    Hi Team, I want a Macro which can assist on the following time consuming task: I need to copy data from monthly workbooks (each having only 1 sh...

    peerreh | Excel | Latest reply: peerreh Aug 10, 2016
    1 reply
  • Please explain this Excel macro so I can adapt it for my own Closed

    Hello, I have practically 0 knowledge about macros but I need to complete this task. I found this question that is similar to mine https://ccm.net...

    muddakinjaz | Office Software | Latest reply: ac3mark Aug 9, 2016
    1 reply
  • Unable to fill formula in the range which has been set. Closed

    Hello, I have created vba to creatable from the consolidated data in a sheet1. After a table structure is created, the macro will populate the val...

    AgniArul | Excel | Latest reply: ac3mark Aug 9, 2016
    1 reply
  • help on running two code auto when opening Excel workbook Closed

    Hello guys i need some help about merging two or more code on vba i used this code and it helps for only one code: Private Sub Workbook_Open() ...

    Saeed1373 | Excel | Latest reply: TrowaD Aug 9, 2016
    1 reply
  • conditional formatting. Closed

    Hi, I have prepared a master sheet in which we enter the data. There are different sheet in the same file which will use the same data but not simult...

    hmnanavati | Excel | Latest reply: TrowaD Aug 9, 2016
    4 replies
  • copying a name range Closed

    Hello, Am struggling here and i need help please. I have defined a name range in the name box and it is B20:B30 and given it a name: Data. some...

    Saif | Excel | Latest reply: Saif Aug 9, 2016
    0 replies
  • Comparing two sheets for mismatch Closed

    sheet1 abcd 18383 91939 82838 3828 ...... cdef 29832 82738 28392 2938....... xywz 23872 237 28 27382 6727...... sheet2 cdef 2983...

    excelraj | Excel | Latest reply: excelraj Aug 9, 2016
    0 replies
  • Formula please! Closed

    Hello, Can you help me with this data. What formula can I use? If 18:00 to 18:59 = 1 If 19:00 to 19:59 = 2 If 19:00 to 19:59 = 3 If 20:00 to...

    thepishoner | Excel | Latest reply: fdibbins Aug 8, 2016
    4 replies
  • copy rows of data based on cell value Closed

    Hello, I have a spreadsheet with multiple tabs and I want to copy entire rows based on the value of a column - for example I have a column named Acc...

    Jean | Excel | Latest reply: Jean Aug 8, 2016
    0 replies
  • Automaticaly populate activity sheets from master sheet. Closed

    Hi all, I am a volunteer working for an organization helping veterans. We run several activities as part of their rehabilitation and re-integration b...

    Jacko | Excel | Latest reply: vcoolio Aug 8, 2016
    3 replies
  • If function help Newbie Closed

    Ok here goes doing a very large spreadsheet and need some help with the if function If column a says A1 or B2 or C2 then columns D F G or what ever ...

    Michael32744 | Excel | Latest reply: fdibbins Aug 7, 2016
    3 replies
  • copy excel datas from different work books to a common work book Closed

    Hi Techies!!! I have a challenging task...can any one share me one VB code for copy excel data? Below are my requirements 1) Source files ma...

    salim | Excel | Latest reply: salim Aug 7, 2016
    0 replies
  • Suddenly unable to send emails Solved/Closed

    I am able to receive emails just fine. Going to the webmail server on the web I can both send and receive emails. I've tried adjusting settings on my ...

    DaveBHastings | Outlook | Latest reply: DaveBHastings Aug 7, 2016
    4 replies
  • Outlook 2007 cannot connect Closed

    Hello, I m Satish, Tried to setting outlook, but cannot connect, all trial email messages are pending in out box. I tried all your above sug...

    Satish | Outlook | Latest reply: rorymacmahon Aug 7, 2016
    3 replies
  • I want false value from cell Closed

    Hello, i am try to apply a formula with =iferror but after that shown false value in cell but i did not want that in cell. i need just blank ,,, ...

    Rana Asif | Office Software | Latest reply: Rana Asif Aug 7, 2016
    0 replies
  • Type a value in a cell based on another cell Closed

    Please Help me with this one i need to make vba to do that if ("A1") between 0 , 2.4 than ("B1")= 15 else if ("A1") between 2.5 , 2.9 than ("B1")=...

    Concorde | Excel | Latest reply: fdibbins Aug 6, 2016
    1 reply
  • Need help with an IF Statement that refrences dates and values Closed

    Hello, I have a spreadsheet that has a bunch of maturity dates and corresponding return values. What I need to do is create an if statement that s...

    zacharywsull... | Excel | Latest reply: fdibbins Aug 6, 2016
    1 reply
  • Conditional formatting several cells risk register Closed

    Hi. I have a risk register where i want to apply conditional formatting depending on the probability (column b) and consequence(column c) I have a...

    oyvinols | Excel | Latest reply: fdibbins Aug 6, 2016
    1 reply
  • vlookup or if Closed

    Hello, I really hope you can help. I have become very rusty on Excel. I am trying to create the formula where one cell content is checked agai...

    Gemma` | Excel | Latest reply: fdibbins Aug 6, 2016
    1 reply
  • Excel application virtualization client could not launch the app Closed

    My Excel software is not working.Error:The application virtualization client could not launch the application you required.There was problem sending ...

    Purushottam.... | Excel | Latest reply: Purushottam.Kulkarni Aug 6, 2016
    0 replies
  • Formula want to know (urgent) Closed

    There is a two values, i.e 200 & 300 in two cell. Now we want the values which is in between that figure in different cell means value should not exce...

    Shankar | Excel | Latest reply: Mazzaropi Aug 4, 2016
    1 reply
  • Conditional formatting based on two cells (date and comment) Solved/Closed

    Hi guys and dolls, I am hoping one of you clever people might be able to help me... I am trying to highlight a cell when 1. a date has passed ...

    jayelpe | Excel | Latest reply: jayelpe Aug 4, 2016
    2 replies
  • Macro to get the highest value in a table Closed

    A B C 10 1 apple 10 1 b...

    francis | Excel | Latest reply: TrowaD Aug 4, 2016
    1 reply
  • examination result Closed

    Hello,the are 38 pupils in the class,the position of the child is 31st,,number on roll 38 This is her result scores 63 :B :22nd :good 33 :D- :33rd ...

    give | Excel | Latest reply: TrowaD Aug 4, 2016
    1 reply
  • help me with this one please Closed

    I like to display all the documents with "john salvatus" name. but only if the text in column C has "Overdue" in it and the column K has a null value....

    JhunTan | Excel | Latest reply: TrowaD Aug 4, 2016
    1 reply
  • date of birth convert to word Closed

    dob 23/03/1985 the dob display another cell Twenty three March Nineteen thousand Fifty Eight

    anil | Excel | Latest reply: anil Aug 4, 2016
    0 replies
  • Automatically send cells to different excel file Closed

    Hello, I have created Subject wise mark sheet for single class students... Now i need to automatically generate each and every student entire subj...

    Sofi | Excel | Latest reply: Sofi Aug 4, 2016
    0 replies
  • If multiple cells contain value then add value Solved/Closed

    Trying to think of the best way to sort this problem! . I have a spreadsheet with a list of customers that have purchased a vehicle. Along side in...

    Robert Bell | Excel | Latest reply: Rob Aug 3, 2016
    2 replies
  • Type a value in a cell based on another cell Closed

    Hello, i need to make vba to do that if ("A1") between 1 , 2 than ("B1")= 15 else if ("A1") between 2 , 3 than ("B1")= 10 else if ("A1") betwee...

    Concorde | Excel | Latest reply: Concorde Aug 3, 2016
    0 replies
  • Which free software for pc Closed

    can i get a softwere free for my pc if yes which one and how

    miracleboyz | Excel | Latest reply: Ambucias Aug 3, 2016
    2 replies
  • Excel - Formula For Copying/Moving A Huge Range in Excel Closed

    Hi everyone, Please, I need some help with Excel worksheet. I have a huge excel worksheet with cell values spreading 50000 Rows and 900 Columns My ...

    davemacleod | Excel | Latest reply: davemacleod Aug 2, 2016
    3 replies
  • how to transform data from columns to rows??? Closed

    Hi i have some data like this: 1 2 3 4 Cell 1 1/11/1900 0:00 5/9/2015 12:40...

    Saeed1373 | Excel | Latest reply: Saeed1373 Aug 2, 2016
    0 replies