+ Reply to Thread
Results 1 to 2 of 2

Help with macro to auto populate summary sheet Excel 2007

  1. #1
    Registered User
    Join Date
    10-23-2011
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Help with macro to auto populate summary sheet Excel 2007

    I have been creating a spreadsheet which calculates a reduction in parking on-site by use (retain, restaurant, residential, etc). It evaulates parking reduction for each hour of the day and does this for every month. The problem that I have is in creating a summary sheet.

    The uses on site run horizontal across the columns. The time of day runs vertical. I have the amount of parking for all of the uses totaled from each row in a total column. I know that I can use the MAX function to search the total for the greatest number of spaces in each month and enter that figure on the summary sheet.

    What I would like the spreadsheet to do is to populate the rest of the information on that row. For example, if the parking peak is 1000 spaces at noon. This value is in cell F12. I would like for the summary sheet to search through column F and locate that the max number is at F12. Then I would like it to enter that value in the summary sheet. After that I would like to enter the rest of the values from row 12 (the time of day from A12, the number of retail, restaurant, and residential from B12:D12) in the summary sheet.

    It should be something that is not locked into a cell at F12. Sometimes the parking peak might be F2 or F20. The macro should adjust according to where the peak number. I think that it could be a HLOOKUP or some kind of IF function. I don't know.

    I can send more information if needed.

    Thanks,
    Amy

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Help with macro to auto populate summary sheet Excel 2007

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1