Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Excel 2007 and 2010 forum. See all tags in the site
  • Help with figure this issue

    (A) has a list of charges received and (B) is the category on each charges and (C) is the insurance that charged (A). now I am trying to get the average of Charges (A) per categories (b) for all the insurances (C). Some of the charges are not on the same rows which makes it even harder for me. Someone...
    Posted to Excel 2007 and 2010 (Forum) by Jerry on Mon, Aug 4 2014
  • Excel lookup and sum

    I have two tables in excel, 1 for daily entry of overtime and other one is for total monthly overtime calculation. I need a formula to add overtime for each employee in a daily basic from the 1st table to second. For example Mr. Bala have worked 4 hours extra in 1st of january, so i need the value 4...
    Posted to Excel 2007 and 2010 (Forum) by Shameer on Wed, Jan 22 2014
  • sum number of cells dynamicaly based on current month in excel spreadsheet

    Month JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Planned 78 9 8 2 2 3 1 2 3 2 7 4 Completed 4 0 0 0 0 0 0 0 0 0 0 0 I need to add the planned/completed row upto current month in excel. For ex. if currunt month is march then sum will be 78+9+8 =95. How can I set a formula to obtain the solution....
    Posted to Excel 2007 and 2010 (Forum) by Shameer on Wed, Jan 15 2014
  • Excel UserForm

    Hi, I have a user form that uses several command buttons that launches specfic sheets in my workbook. The code below works well with that task. What I want to do is which I am not sure if this is possible is for the command button for that sheet to display the name of the tab since the users has control...
    Posted to Excel 2007 and 2010 (Forum) by m66dragon on Wed, Sep 18 2013
  • Moving rows from a spreadsheet with a remote button into another spreadsheet

    I have this spreadsheet I want to use daily for tracking parts, each day we will start a fresh spreadsheet for a total of 30/31 spreadsheets in the workbook depending on the month, I would like to move items that have not arrived to the following day spreadsheet without cutting and pasting from day to...
    Posted to Excel 2007 and 2010 (Forum) by Readthis on Tue, Jul 30 2013
  • Tables and Excel Mobile

    Has anyone else tried inserting a table using the Excel Web App on a PC?Laptop and then tried to insert data in the table using the Excel phone App on Windows Phone 8? My experience is that it doesn't work but I'd like to exchange info on this with someone else in case my expectations are not...
    Posted to Excel 2007 and 2010 (Forum) by PaulC on Tue, Feb 19 2013
  • Re: autoexpand the Excel 2010 formula bar to display as much of the cell contents as possible

    Peter, Thanks for all the help, but I'm still running into a problem. I'm trying it out in a specific workbook rather than my personal, until I'm sure I can get it running okay. Okay, here's what I've done (apologies in advance; I don't see how to wrap my code): In a standard...
    Posted to Excel 2007 and 2010 (Forum) by jomili on Thu, Apr 5 2012
  • NOT VALID HYPERLINK IN EXCEL 2010 UNDER OS WINDOWS7 -- %20appears in the address

    Hi, since I changed my PC , I have Excel 2010 instead of previously installed Excel 2007 and W7 instead of WIN XP. An Excel document containing several hyperlinks pointing to my C drive is not working anymore. When I clik the hyperlink the following error message is returned by Internet Explorer 8 :...
    Posted to Excel 2007 and 2010 (Forum) by FANTASIA on Fri, Jan 6 2012
Page 1 of 1 (8 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.