SPClements
New Member
- Joined
- May 7, 2015
- Messages
- 1
Hi folks, I'm managing multiple budgets in excel. this works fine at the budget level but am unable to get an overall picture of where each employee is charging their time on a two year budget cycle (i.e., is one person listed on two cost centers in a single month). My idea was to link the excel sheets to MS access and run a crosstab query on each employee. First though I need to convert the excel sheets into a normalized table. I've posted an example of one of the budgets at the link below-they are all a similar format. After conversion I'd like to have a table with column headings "category" "position number" "month" "amount". Hope this makes sense-any input or easier ways would be appreciated-thanks in advance for your time.
https://drive.google.com/file/d/0ByK3XP5e4RdCck1jY1d2d2VrUVE/view?usp=sharing
https://drive.google.com/file/d/0ByK3XP5e4RdCck1jY1d2d2VrUVE/view?usp=sharing