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
Bookmarks