Forum Discussion
Do a search/sort/sum in an excel workbook and put results in another workbook
- Just pouring through this now...it is perfect, thank-you!! still playing with how i can expand etc. YOU ROCK
D$4. is a reference to a cell toward the top of the summary sheet. The dollar sign keeps the reference to row 4 even if the column changes; it's called an "absolute reference". As I said in my earlier post, I was assuming that you'd have codes OTHER THAN 1, so created a way for those to be handled; hence the codes 2----
That said, the formulas' references to Cindy and so forth are references to a table name; some of the new ones that you created are called Table5, Table8, and so forth.
If I were doing this myself, unless there were compelling reason to have separate sheets for each source, I'd make them all a single database and have the summary still able to separate them different entities out by selection criteria. Having separate sheets--although cleaner for human beings to look at--actually gets in the way of a clean and simple Excel formula, as you're discovering. You need to write a different formula for each entity, rather than using one formula and referring to the names.....
If you're able to put all those billing hours into one table, regardless of source--just adding a column to identify whether it's Cindy or Allison or.....--let me know and I can show you that.