I'm hoping I can get some assistance... I'm truly not familiar with
much
VB (almost none) and I'm trying to get excel to do something
that, based on what I'm reading, is possible... I just need some
assistance.
I'm trying to combine a lot of one sheet workbooks into one master
workbook. I've found this reference to help:
http://www.rondebruin.nl/copy3.htm
But, I can't seem to make it work (because I don't understand
VB
enough to know if I'm entering the stuff correctly?)
To try and simplify... what I'm trying to do is this:
I've created a tracker for about 300 employees to keep record of phone
calls that are received. The columns that matter for data a
Account Number / Disposition / Reason / Other Reason
These are the only things the agents will be entering that matters...
of these 4 boxes... 2 are drop down boxes with prefilled information.
The information they will be entering will begin in row 7... columns
F, G, H and I. The tracker only has rows for data up to row 49 - same
columns. (Not all rows would be filled - most likely only about 20
rows or so but I provided extra, just in case).
Each rep will receive a blank tracker to save - which can be saved
into one folder so they're all together in the same location - but,
they'll still be a bunch of indivdual files. What I need to do is
have one database that houses all the information that people collect
- so that I will be able to determine how many calls were received
and, of those calls, how many were each "reason" code. The auto-
filtering I can figure out... but, can someone help me with figuring
out how to make these workbooks all compile into one with the range
that I need?
Oh - if you're going to just put the code - can you tell me where it
is that I need to "title" the page or whatever - because I'll end up
just copying it exactly as you have it - so that's where I get messed
up. I don't know what is supposed to be what I call it and what
should be left alone. If you tell me what I should title the pages,
I'll gladly do that!!
Thanks for any assistance!!!! :)