Needing to take a list of counts and add them to the next column over - date-based loading

[nscarritt]

I am trying to come up with a way of tracking our new hires and how many go to each solution, within a few orgs. I am given a list by HR and run a series of =countifs to break down the matrix. I have a fixed number of solutions, all to be counted within each of 4 orgs. Ultimately I want to have multiple columns within each of these orgs to represent our various start date cycles.

I am trying to figure out the easiest way to load each of 4 count column to the next empty column, within 4 columns in a new worksheet.

[Leith Ross]

Hello nscarritt,

Since you have sums for each of the categories and the four columns, link the sum to the cell on the other sheet. I used the following formulae on the "Count" sheet and drug them down each column.

Please Login or Register  to view this content.

[nscarritt]

Thank you! I didn't even think of that.. I will use that in the mean time.. but am hoping that there is also a macro type function that could be used?