consolidation

Hi All, I'm looking for some ideas/conceptual help. We have a resource tracker following capturing the usual, sickness, holiday, absent kind of details but we're tracking for 150+ staff based in 10 teams in seperate locations. These teams have designated team leaders who are responsable for...

I have two main tables: ACTUAL and BUDGET The Actual Table collects information as checks are writen and distributes the amounts to the proper column. It works ok. I also have a Budget Table which collects information with a single budget amount per Account. See below. (The structure...

Hi, I have 85 workbooks in the same folder with a sheet in each workbook called "Budgets". Its the same template in each workbook with different data. I need to create a Summary master file of all my budgets so in the end I will have 1 Workbook with the 85 copies of the "Budgets" Worksheets...

Hi Folks, I have a somewhat complex formatting problem that I've separated into two parts. 1. I would like to take a master list and search a column for DISTINCT values. For each distinct (value), I would like a new worksheet created with (value) as its name. Then I want to take each row that...

Im using the consolidate function in Excel 2007. I have a table that does'nt have numbers, just text. Therefore, I do not require a count or sum or anything like that. The consolidated table I created gives me the pulled pulled, but under everyline, it the consolidated table performs a count...

Hi, I'm looking for help with what seems to be a very popular topic around here. I've done extensive searching and still have questions about the best way to approach this. I've got approx. 500 product data sheets, which are in .xls format. They have an image of the product at the top, and...