Office Software Forum

Ask a question
Search
Close
Results 5801 - 5850 of about 16,600
  • Excel facing a problem with automation Closed

    Hi everyone, I am currently facing a problem with automation of Ms. excel for my work and would highly appreciate any kind of help in this case. ...

    Umer1991 | Excel | Latest reply: TrowaD May 6, 2014
    1 reply
  • Creating lists that are conditional on info in other cells Closed

    Hi there, I'm new here so I'll try and explain as best I can. This is probably really easy but I can't quite find the correct formula to do it, I ass...

    Vishk | Excel | Latest reply: TrowaD May 6, 2014
    1 reply
  • How to extract dates that a person is absent in a month? Closed

    How do I extract the dates that a person is absent during the month and the dates extract to be in a single cell? Thanks!

    Mango_68 | Excel | Latest reply: TrowaD May 6, 2014
    1 reply
  • Hide Rows Macro Closed

    Dear Sir i have some Record in Sheet1 Parts Name Parts Used in Section parts Used Quantity if my parts used Quantity is 0 then Row will H...

    akram786 | Excel | Latest reply: TrowaD May 6, 2014
    1 reply
  • Conditional Format Closed

    Hello, Configuration: Windows XP / Chrome 34.0.1847.131 Hello, I am trying to set a conditional format using different columns and I can'...

    minimolly | Excel | Latest reply: TrowaD May 6, 2014
    1 reply
  • Automate Data From Excel To The Website Closed

    Hello, I have an Excel Sheet which contains 3 columns(Docket Number, Resolution, time), and 100 rows and I Just Need to paste in a website, I need...

    vinay4125 | Excel | Latest reply: vinay4125 May 5, 2014
    0 replies
  • Add one month to all the date... Closed

    Hello, Sub Sample() Dim ws As Worksheet Dim lRow As Long, i As Long '~~> Change this to the relevant sheet Set ws = ThisWork...

    fireburn | Excel | Latest reply: ac3mark May 5, 2014
    5 replies
  • How to insert multiple conditions in a formula? Solved/Closed

    I have 2 cells, and I proceed like this with a formula and basically, if cell A2 meets a condition, then cell B4 shows the word "Good" =IF(A2>=100...

    doublewitt | Excel | Latest reply: doublewitt May 4, 2014
    2 replies
  • match the same no of data1 with data2 with respective qty and pr Closed

    data2 data1 partno qty price partno qty price 0411175858 4 411.00 0437160070 5 89.50 0...

    msg2012 | Excel | Latest reply: msg2012 May 4, 2014
    0 replies
  • Excel - Shortcut key print preview Solved/Closed

    Hello, What is the short cut in excel 2003 for print preview. Please give me solution. Configuration: Windows XP / Firefox 3.6

    CHITTI | Excel | Latest reply: Hafiz Pakistani May 4, 2014
    12 replies
  • Can you give me PDF-XChange Viewer Pro serial number? Closed

    Hello, Can you give me PDF-XChange Viewer Pro serial number? I will be very appreciated. Mr. Chao Configuration: Windows 7 / Chrome 34.0.18...

    ed5097 | PDF | Latest reply: Ambucias May 1, 2014
    1 reply
  • Multiple Results with simple criteria? Closed

    Hello! Here's what Tab A looks like: Cap Type 220 N 3993SNB34 180 N 7113038KH34/32 220 N WS450BKXL 100 N ED303BK38/32 180 N 874OG36/32 ...

    kaiwalls04 | Excel | Latest reply: Mazzaropi May 1, 2014
    1 reply
  • Insert word in cell based on value in another cell? Solved/Closed

    CONDITIONAL FORMATTING for cell A2: if value in cell C3 is > than 500, then insert word "alert" in cell A2 what would the formula look like? I ...

    doublewitt | Excel | Latest reply: doublewitt May 1, 2014
    2 replies
  • Conditional formatting of entire column Solved/Closed

    Hello, I have two columns in excel 2010 which are generated by sensors measuring the same thing. In theory the 2 columns should be the same...of c...

  • Round UP Formula for TIME Solved/Closed

    Hi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g. if column A is 1-Apr-...

    ravibangera | Excel | Latest reply: ravibangera May 1, 2014
    2 replies
  • Formula for percentage calculation Closed

    Needed a formula in A which will be then pulled down throughout the column. Wanted the result in A where B multiplied by C & D and deducting the val...

    XLFaith | Excel | Latest reply: Mazzaropi May 1, 2014
    3 replies
  • Formula Assistance Closed

    Excel..... I have a spreadsheet for shipping products. When I enter the amount shipped, I would like for that days date to appear in the next column...

    MudRunner | Excel | Latest reply: ac3mark Apr 30, 2014
    1 reply
  • Microsoft Office Accounting 2008 Closed

    Just become a member with Kioskea. I downloaded Microsoft Accounting 2008 from your website but need a product key. Can you help?

  • The value of a name Solved/Closed

    Hello, I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making ...

    Derrall | Excel | Latest reply: Derrall Apr 29, 2014
    2 replies
  • Excel Conditional Formula Closed

    Here is my need. I have a visit date that I want to prepare for 3 weeks in advance. So if I have a date of 5/23/14 for the visit I want a cell to show...

    kaustin | Excel | Latest reply: TrowaD Apr 29, 2014
    4 replies
  • how to find positions with repeated marks Closed

    Hello, Sir i have problem with finding positions of a class having equal marks can any body help me please. Configuration: Windows 7 / Interne...

    khan | Excel | Latest reply: TrowaD Apr 29, 2014
    1 reply
  • Adding rows based on Users selection Closed

    Hello, I want add rows with say Y1,Y2,Y3...Y10 based on what value the user selects from the drop down i.e. Say a user selects 5 then in the o...

    nitin | Excel | Latest reply: TrowaD Apr 29, 2014
    1 reply
  • Macro to copy worksheet based on criteria Closed

    I am fairly new to using macro's. I have 4 template worksheets and one input worksheet. Based on cell c4 in input worksheet I want to select either te...

    SDS007 | Excel | Latest reply: TrowaD Apr 29, 2014
    1 reply
  • how automate to search and move data from one excel to another Closed

    Dear Friends, I need a excel script to search columm A data from my lslpp-report and match the phrases in column A with the data from the lslpp raw...

    Jlytee98 | Excel | Latest reply: ac3mark Apr 29, 2014
    1 reply
  • Copy data from one work book to another Closed

    I am a beginner in excel so i need your help on this. The 2 work books in question are the links below. https://docs.google.com/spreadsheets...i...

    klaudieluv | Excel | Latest reply: klaudieluv Apr 28, 2014
    5 replies
  • Can the formula COUNTA / COUNT exclude 0 values? Solved/Closed

    If I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips

    doublewitt | Excel | Latest reply: doublewitt Apr 28, 2014
    2 replies
  • Drop down list opens new window Closed

    I would like to create an excel that has a first sheet with drop down selections $2m >$5m >$7m Depending which is selected a different excel she...

    bzg51n | Excel | Latest reply: TrowaD Apr 28, 2014
    1 reply
  • Populate cells based on criteria... Closed

    Hello, A B C D E F ...

    fireburn | Excel | Latest reply: TrowaD Apr 28, 2014
    19 replies
  • Transfer data into Invoice Solved/Closed

    So I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used dur...

    semperfi90 | Excel | Latest reply: semperfi90 Apr 28, 2014
    10 replies
  • If Functions Closed

    Hello , I am able to create multiple if functions ( =IF(Site1!H2="y",Site1!G2,IF(Site1!H3 ="y",Site1!G3,IF(Site1!H4="Y", Site1!G4, IF(Site1!H5="y"...

    kilown | Excel | Latest reply: Mazzaropi Apr 28, 2014
    3 replies
  • Inserting a row when the value of a field changes Solved/Closed

    I was using this code as a start but can't seem to mak it do exactly what I want. Sub InsertRows() Dim r As Long, mcol As String, i As Long '...

    kkautz | Excel | Latest reply: KKautz Apr 28, 2014
    2 replies
  • Format cell color based on date range Solved/Closed

    Hi, this is my first post. I'm glad to be a member of this forum. Based on conditional formatting, how can I select a cell and have the backgroun...

    doublewitt | Excel | Latest reply: doublewitt Apr 27, 2014
    4 replies
  • concatenate cells losing comma formatting Closed

    Hello, I am trying to concatenate multiple number values into 1 string text, but I am losing the Comma formatting. Here is an example of 3 valu...

    meesh97 | Excel | Latest reply: Kevin@Radstock Apr 26, 2014
    2 replies
  • formating cells Closed

    i am trying to change the colour of a cell based on the value of two other cells in Excel 2010. for example if R1 is the same value as C6 how do...

    shopkeeperrob | Excel | Latest reply: Mazzaropi Apr 25, 2014
    1 reply
  • Simple Point of Sale Closed

    I have a relatively simple task that I'm hoping I can accomplish in excel. I'm putting on a college fundraiser selling four items and I have a list...

    pembrokecollege | Excel | Latest reply: Mazzaropi Apr 25, 2014
    1 reply
  • VBA to put formula into cell Closed

    Hello, In a effort you keep you guys challenged. And obviously improve my VBA writing skills...I really appreciate all the responses I have had up...

    Debs269 | Excel | Latest reply: ac3mark Apr 24, 2014
    1 reply
  • Excel Closed

    Description: 1. I have an excel workbook containing multiple sheets (about 28-33) eg. Book1 and the worksheets are labelled eg. 01-March DS, 02-Marc...

    Activetransport | Excel | Latest reply: Activetransport Apr 24, 2014
    2 replies
  • VBA Macro to export data to a new workbook Closed

    Hello all, Trying to create a macro in VBA but getting some problems starting with it. If you can help it would be great! Going to summarize wha...

    lmcpinho | Excel | Latest reply: TrowaD Apr 24, 2014
    1 reply
  • VBA - criteria lookup and the removing formula from cell Closed

    Hi, Could someone help... I have written some code but cant get it to do exactly what I want, and think I have over complicated the problem. Ce...

    Debs269 | Excel | Latest reply: Debs269 Apr 24, 2014
    4 replies
  • Filtering data from 1 sheet to another Solved/Closed

    Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and tasks ...

    mmtmacros | Excel | Latest reply: mmtmacros Apr 24, 2014
    2 replies
  • If row is checked copy it onto next available row on 2nd sheet Closed

    Hi Excel Folk and Friends of Michael, I have sheets and sheets each day of potenital 'buys' - when I get one I like I have to copy it onto another sh...

    JamesRugg | Excel | Latest reply: venkat1926 Apr 23, 2014
    1 reply
  • If formula using dates and texts Closed

    I want to write a formula which will show either Q1, Q2 Q3 or Q4 depending on the date I the next cell (written as 01/01/2014).

    Maxbats | Excel | Latest reply: Mazzaropi Apr 22, 2014
    1 reply
  • Using a selected criteria to copy cells into new sheet Closed

    Hello, I have written a spreadsheet that is basically a dashboard for data... I have hit a small snag as usual the business wants to over compli...

    Debs269 | Excel | Latest reply: Debs269 Apr 22, 2014
    2 replies
  • To show blank record when no data while copying Solved/Closed

    Hello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet ,th...

    AK | Excel | Latest reply: venkat1926 Apr 22, 2014
    4 replies
  • add value to one cell if multiple other cells have any value Solved/Closed

    Hello, I'm trying to create a spreadsheet where: if A1 has any value, 10 is added to the total sum in G1 if B1 has any value, 20 is added to t...

    alonsy | Excel | Latest reply: alonsy Apr 21, 2014
    11 replies
  • How to auto merge same value cells. (H\V) Closed

    Hello, I want to merge same value cells in both rows and columns. for example i'll be having: | 2 2 2 2 2 3 3 3 3 3 | 2 2 2 2...

    iJihad | Excel | Latest reply: iJihad Apr 21, 2014
    0 replies
  • Change content of one cell based on content of another Closed

    Hi! I'm looking for guidance on a formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the...

    stlellen | Excel | Latest reply: ac3mark Apr 18, 2014
    1 reply
  • Collect data from drop-down list from multiple workbooks. Closed

    Hello! I have a question. Let say, I have workbook 1 (WB1), workbook 2 (WB2) and workbook 3 (WB3). All basically are the same workbook, just that ...

    Natasyamn | Excel | Latest reply: Natasyamn Apr 17, 2014
    4 replies
  • How to go to a particular cell while input its content in a box Closed

    Hello Trowa & Experts, I have an excel data sheet with columns 250 odd. Column headers have numbers like 100,101,102,103 and so on till 250 plus....

    vinaymaithani | Excel | Latest reply: ac3mark Apr 17, 2014
    3 replies
  • Filtering and copying data from one sheet to another Closed

    Hello, Problem statement: I have data pertaining to projects, milestones and tasks in sheet1. I want this data to be filtered on the basis of miles...

    mmtmacros | Excel | Latest reply: mmtmacros Apr 17, 2014
    0 replies