I receive files every two weeks; the files have different fields one
includes: Vendor, Location, Supervisor Name, Employee Name, Account,
Trans Date, System, Current Start Date, Current End Date, Prev Start
Date, Prev End Date, Date Done. In another it includes: Vendor,
Location, Supervisor, Name, Rgn, CUST_ID, MTN, FEAT_CD, PKG_DESC,
FEAT_DEACT_DT, ReAdded, USER_ID, and Date Done. When I send my updates
I must retain the individual file format. I want to be able to
consolidate the records but then magically apply my updates to the
individual files (query??). With the data I find the employees name
when what needs to be is done I type in today’s date in “date done”. I
have to manually update the individual files which take 4hours a day. I
have other people completing what needs to be done with employee, to
avoid duplicate reporting after I have entered “date done” to the
individual files I delete the records from my consolidation. This also
helps me because I send a report everyday that tells how many are left.
The employees name can show up multiple times in different files and
different dates so I have set up a pivot table. This pivot table
displays employees name in a row and does a count of Trans Date but
because employees have trans dates with in different files have added a
field that includes the two week period where there trans occurred,
when I throw that in column and then do a sort it allows me to see how
many occurrences are left in older files. I’m wondering if there is a
way to compare the consolidation of the “completed” to the individual
files and apply the updates, only one field is being updated “date
done” which can include a date/text and for the other person receiving
the individual files I also color code my completions. Another thing I
have run into is space consumption. Thanks in advance
---
Message posted from
http://www.ExcelForum.com/
Similar Threads
