Patrick Niedermeyer
New Member
- Joined
- Apr 10, 2020
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Howdy ladies and gents.
It's been a while since I posted here, but I have another question I'm trying to answer. I have spreadsheets that output from a construction management software for employee time sheets. I'm building a macro that applies filters to project specific data, sorts by the Cost Code column, sums the hours in the column adjacent to the sorted Cost Code column, prompts the user for the labor rate assigned to each project and then sums up the total hours for each Cost Code and enters this summary in empty cells below the data. I'm stuck at how to sum the data according to the sorted cost code, and not sure how to display the summary.
1. What function sums a column and inserts a line below the group of data with identical labels?
2. How do I query the user for a multiplier then create a summary table below the data for each Cost Code sum?
It's been a while since I posted here, but I have another question I'm trying to answer. I have spreadsheets that output from a construction management software for employee time sheets. I'm building a macro that applies filters to project specific data, sorts by the Cost Code column, sums the hours in the column adjacent to the sorted Cost Code column, prompts the user for the labor rate assigned to each project and then sums up the total hours for each Cost Code and enters this summary in empty cells below the data. I'm stuck at how to sum the data according to the sorted cost code, and not sure how to display the summary.
1. What function sums a column and inserts a line below the group of data with identical labels?
2. How do I query the user for a multiplier then create a summary table below the data for each Cost Code sum?