Office Software Forum - solved topics

Ask a question
Results 1151 - 1200 of about 2,650
  • Solved
  • Excel 2010-VB Macro formula into many spreadsheets Solved/Closed

    Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...

    AnFey | Excel | Latest reply: AnFey Mar 3, 2014
    4 replies
  • IF function using dates Solved/Closed

    Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...

    Escalation | Excel | Latest reply: Escalation Feb 28, 2014
    2 replies
  • how do i change the result of a formula to normal text or values Solved/Closed

    Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...

    kelnasawa | Excel | Latest reply: kelnasawa Feb 26, 2014
    8 replies
  • Excel MMYY format in order Solved/Closed

    Hello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...

    nickkyh | Excel | Latest reply: nickkyh Feb 24, 2014
    5 replies
  • Excel formula help Solved/Closed

    Hello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...

    jgates | Excel | Latest reply: ac3mark Feb 19, 2014
    5 replies
  • if cost is 18.66 what would be 0.6% of it (calculation method) Solved/Closed

    and if basic pay 65000rs what would be the 2.5% of it(calculation method)

    nooblord | Excel | Latest reply: nooblord Feb 17, 2014
    5 replies
  • formulas Solved/Closed

    sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)

    Gmooney | Excel | Latest reply: Gmooney Feb 14, 2014
    2 replies
  • Copy data from current work to another Solved/Closed

    Hi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of rows.....

    Sushil Gaikwad | Excel | Latest reply: Sush Feb 14, 2014
    2 replies
  • Conditional formatting from another cell by range Solved/Closed

    Hey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is < 70%, Y...

    riboss | Excel | Latest reply: ac3mark Feb 13, 2014
    1 reply
  • Excel Formula Solved/Closed

    I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If nu...

    meesh97 | Excel | Latest reply: meesh97 Feb 10, 2014
    2 replies
  • code to move a row based on fix values and paste it Solved/Closed

    Hello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same shee...

    sonkar | Excel | Latest reply: sonkar Feb 8, 2014
    2 replies
  • simple macro Solved/Closed

    I am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...

    warnerjs | Excel | Latest reply: warnerjs Feb 7, 2014
    2 replies
  • fill amount from a cell if date is before end of month Solved/Closed

    Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example: If date in cell B5 (due date) i...

    hawkwms | Excel | Latest reply: hawkwms Feb 6, 2014
    4 replies
  • Macro to create email, and pick which email account to send from Solved/Closed

    I already have this set up how I want... Sub MakeMsg() Dim msg As Outlook.MailItem Today = Format(Now(), "mm-dd-yy") Set msg = Application.CreateIt...

    TomTom111 | Outlook | Latest reply: TomTom111 Feb 4, 2014
    2 replies
  • Find highest value and state its cell name Solved/Closed

    Hello, I have the following issue: in A and B: Marche 160,994 Puglia 463,251 Lombardia 405,626 Emilia- 542,009 Lombardia 451,468 ...

    Fessi | Excel | Latest reply: Fessi Jan 30, 2014
    2 replies
  • search for a string and if found, select that row? Solved/Closed

    I know this is a very simple question but I can't find the answer I need. I am using Excel 2007 but I can get to a computer with Excel 2010 if necessa...

    maybedog | Excel | Latest reply: maybedog Jan 29, 2014
    2 replies
  • How to add times in hour and minutes format Solved/Closed

    Hello In the first column I have start time, in the second finish time and the third column the time elapsed ie A minus B = C But if I add colum...

    Ambucias | Excel | Latest reply: Ambucias Jan 27, 2014
    19 replies
  • Formula:IF E18 = 1, 2, 3, 4 or 5 Then End Result = G18, G19 etc. Solved/Closed

    Trying to create a formula where I have a merged cell (E18) that if 1, 2, 3, 4 or 5 is entered I want the end result to equal the contents of G18, G19...

    wreidmetals | Excel | Latest reply: wreidmetals Jan 22, 2014
    2 replies
  • how do i add text to a drop down list Solved/Closed

    Good day how do i add text to a drop down list i created in excel Configuration: Windows XP / Chrome 24.0.1312.57

    Maxi84 | Excel | Latest reply: Maxi84 Jan 21, 2014
    2 replies
  • Excel help Solved/Closed

    I am tracking shipments of our product. When I enter the amount that shipped, I would like for that days date to appear in a separate cell and never c...

    Flashrunner | Excel | Latest reply: TrowaD Jan 20, 2014
    1 reply
  • Conditional formatting help Solved/Closed

    Hi, I have a spreadsheet with a column for employee hours. Anything over 9 hours is considered overtime and we are tracking how many employees are ...

    tinayat | Excel | Latest reply: tinayat Jan 16, 2014
    2 replies
  • Conditional formatting with "contain". Solved/Closed

    Hello...I am using Excel 2007. I can't get beyond the following: =ISNUMBER(SEARCH("campaign",A2))=TRUE This is what I'm trying to do...If cell A2...

    Tulsi17 | Excel | Latest reply: ac3mark Jan 15, 2014
    3 replies
  • MS Excel Number format error Solved/Closed

    Hello, I use Ms Execl in that I have a error it like this..... 1. when I type a number 400 in the cell an give Enter. It is not showing the exa...

    zac | Excel | Latest reply: Akoh Jan 15, 2014
    5 replies
  • Date format problem (5.8.14) Solved/Closed

    Hi. I'm using excel 2013 on Win7 Ultimate SP1. My problem is that I often type the dates with the help of decimals/periods. But I've learned thru goog...

    zopfan | Excel | Latest reply: zopfan Jan 14, 2014
    4 replies
  • Excel Date Format Solved/Closed

    Hello, when users enter a date in excel using this format 12.1.2008, I need the cell to automatically change the format to 12-Jan-08 thanks, mo...

    moses | Excel | Latest reply: zopfan Jan 13, 2014
    7 replies
  • i can't open my PDF attachment in my eamil Solved/Closed

    Hello, plz help me,i tried to open PDF attachment in my eamil but I could'nt .Configuration: Windows XP Internet Explorer 6.0

    7978 | PDF | Latest reply: max Jan 4, 2014
    11 replies
  • Help with text & number rule! Solved/Closed

    I wonder if anyone would know how to create the following rule in Excel: IF I enter a specific "text" in cell A, then Excel would insert a correspo...

    Alulus | Excel | Latest reply: Alulus Jan 3, 2014
    7 replies
  • Applying my macro to a range of cells... Solved/Closed

    I found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells....

    lorihohen | Excel | Latest reply: ac3mark Jan 3, 2014
    5 replies
  • date function Solved/Closed

    i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...

    gayathrialagu | Excel | Latest reply: venkat1926 Dec 24, 2013
    1 reply
  • corrupted office file Solved/Closed

    i have a problem that i lost my all data from my computer. then i apply recovery software to get this data , although i recover my data but after reco...

    julupapa | Open Office | Latest reply: julupapa Dec 17, 2013
    2 replies
  • Unique records Solved/Closed

    Hello, I am very new to excel macros, however, I want to make a macro that will provide unique records from three different excel sheets. I have...

  • convert the date format into general format Solved/Closed

    Hello, In excel 2003, how do I convert the date (3/21/2012) from date format into general format and still keep it show as 3/21/2012 instead of 40...

    hhchavez | Office Software | Latest reply: Bharath Dec 12, 2013
    4 replies
  • moving data from rows into columns for every Solved/Closed

    Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...

    Rick | Excel | Latest reply: Glitchdata Dec 10, 2013
    20 replies
  • Excel Macro: combine selected rows Solved/Closed

    Hello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...

    Steve | Excel | Latest reply: iietntech Dec 5, 2013
    6 replies
  • sum ifs function in excel Solved/Closed

    Is it possible to have a criteria range for a range of dates and have it add for a date less that the specified criteria? 11/1/...

    rtcorpuz | Excel | Latest reply: rtcorpuz Nov 28, 2013
    4 replies
  • Invoice No Solved/Closed

    Hello, After Long period i came here to ask some thing to my friends that is i want to raise the invoice as per the cell value i have given some e...

    sgmpatnaik | Excel | Latest reply: sgmpatnaik Nov 27, 2013
    6 replies
  • Bank Reconciliation Solved/Closed

    Hi Am trying to automate bank reconciliation Any ideas as what the code is. In the work book i have 12 worksheets for receipts and 12 worksheets ...

    MRafik | Excel | Latest reply: TrowaD Nov 26, 2013
    32 replies
  • Macro for linking two workbooks, comparing one document ID with Solved/Closed

    Hello, I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in ...

    Hyundai123 | Excel | Latest reply: Hyundai123 Nov 22, 2013
    2 replies
  • How to delete a line from Excel cell Solved/Closed

    Dear all How to delete a line from every cell in a column??

    mahfuz19 | Excel | Latest reply: mahfuz19 Nov 20, 2013
    4 replies
  • 2010 IF function help Solved/Closed

    I'm looking to combine a IF function for one cell with a date function in another. The aim is to have something like this: =IF(A1=2099,"James Jones...

    Kingantz | Excel | Latest reply: ac3mark Nov 18, 2013
    3 replies
  • Iam trying a lot to make the formula succes, but its not helping Solved/Closed

    Hello Ther!! Iam trying a lot to make the formula succes, but its not helping all people ther Kindly help me on the below formula it gives resu...

    luqmansyed | Excel | Latest reply: Kevin@Radstock Nov 17, 2013
    3 replies
  • will i lose my apps if i reset my ipod touch? Solved/Closed

    Hello, My sound does not work at all on my touch, ppl told me to reset my ipod, but im scared to lose all my apps. is there another way to get t...

    tclarke9909 | PowerPoint | Latest reply: idk Nov 16, 2013
    3 replies
  • Can't access Open Office or Documents Solved/Closed

    I can't get the Open Office o4, to open. I have Vista, home ed. And I can't view the documents that are in the Open Office file. What if I dleted O...

    salzar | Open Office | Latest reply: Ambucias Nov 11, 2013
    1 reply
  • Dating Problem! Solved/Closed

    Hi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...

    rbmastertitan | Excel | Latest reply: rbmastertitan Nov 8, 2013
    6 replies
  • Hide/Unhide an Autoshape or Picture in Excel Solved/Closed

    Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...

    madambath | Excel | Latest reply: jerangkung Nov 7, 2013
    6 replies
  • Nested And/IF Statments Solved/Closed

    Hello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...

    nelsojm | Excel | Latest reply: nelsojm Nov 4, 2013
    3 replies
  • Excel worksheet auto generator Solved/Closed

    Hello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...

    Chemopp | Excel | Latest reply: rizvisa1 Nov 1, 2013
    10 replies
  • Need help with lookup? or if? command Solved/Closed

    Hi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...

    nycm | Excel | Latest reply: nycm Oct 31, 2013
    3 replies
  • Compare cells of two columns excel 2007 Solved/Closed

    Hello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...

    Baruch | Excel | Latest reply: Rajen Oct 31, 2013
    5 replies

    I need a formula stating that if cell R7 is blank, then Q7 is yellow. So if anything is entered in R7 then the cell Q7 is no color

    KGRIFFITH | Excel | Latest reply: KGRIFFITH Oct 31, 2013
    6 replies