Working on temp solution to consolidate two line code reports - Jobber 1 and jobber 1 .... but the forst try we found how bad the data is when you get it formatted ( see post from a while back) --so we have data on non-formatted format.
This example shows a could of errors - if you compare the original to the FIXED version-- we have changed some titles and shifted the TOTAL line so it matches the sub/line data -- try to work with this in excel will drive you NUTS. These reports have to be cleaned up and de-bugged - then working in excel will be MUCH EASIER
Click to expand the samples
No comments:
Post a Comment