Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search column for certain criteria and display results in a table
What I am wanting to do is have a macro or some sort of VBA code that
will search a certain column for certain criteria and output the results in a table on another sheet. I will give an example: I have a sheet, Sheet1, that contains columns labeled Branch, Project, Project Type, and Yards. In the Project Type column, I will have something like 4 options I will input on the cells. The options will be R for residential, C for commerical, CASH for cash jobs, and X for everything else. The Yards column will be a figure representing the total amount of Cubic Yards for each job. I need something that will search the Project Type column for each of the 4 options and total the amount of yards from the Yards column for each project type. So, if i have 10 jobs, it will search the 10 jobs, determine which kind each is by the Project Code, total the yards for each type and display the info in a table on another sheet. The table will display Residential, Commercial, Cash, and Other and the total amount of yards for each. Any help is MUCH appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search cells based on criteria and display results in a single col | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Search a column and display a value | Excel Programming | |||
search column and output results in new worksheet in a different o | Excel Programming | |||
Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) |