Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



stanleydgromjr has an addiction to Excel

stanleydgromjr stanleydgromjr is offline

Valued Forum Contributor

Visitor Messages

Showing Visitor Messages 1 to 4 of 4
  1. VBA Noob
    03-28-2009 05:53 PM
    VBA Noob
    stanleydgromjr, Please keep all posts in thread please
  2. abertrand
    03-20-2009 12:10 PM
    abertrand
    Hello,

    I've been working on updating the spreadsheet/macro that you helped me with a few months ago.

    http://www.excelforum.com/excel-prog...p-by-date.html

    We added an extra column to the "output" tab right at the beginning as the new column 'A', along with more information of the same format. I also added a piece of code that adds the date that was searched to the "schedule" tab. Other than that no changes I am aware of, but for some reason it only displays one line in the schedule tab and then stops. I have tried playing with the code and nothing seem to help or hurt. Any ideas?

    I greatly appreciate all the help you have been. I have posted the updated code on the forum page that I pasted to this message.
  3. bobbylan
    11-25-2008 10:58 AM
    bobbylan
    =AVERAGE(C4:L4)
    =SUM(C7:L7)
    =SUM(C10:L10)
    =AVERAGE(C13:L13)
    =AVERAGE(C16:L16)

    I think these are the formulas you are looking for? I'm sorry that I'm not very knowledgeable about Excel. I still need a better explanation of what you mean show changes between sheet 1 and 2 please. Thank you.
  4. codyaaron2
    10-14-2008 08:06 AM
    codyaaron2
    How do you create a macro? I tried but it does not seem to work. Here is what I am trying to do.

    =ROW(A1)&"F"

About Me

  • About stanleydgromjr
    Biography
    Retired Information Technology Manager
    Location
    Northeast Pennsylvania, USA
    Interests
    Hiking, Ballroom Dancing, Wood Carving, Programming
    Occupation
    Retired Information Technology Manager
    My Microsoft Office Version
    Excel 2003, 2007.
  • Signature
    Have a great day,
    Stan

    stanleydgromjr
    Windows Vista Business, Excel 2003 and 2007

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: Today 04:32 PM
  • Join Date: 10-10-2008

Friends

Showing Friends 1 to 1 of 1