taking multiple excel documents and grouping the data into a single spreadsheet.

For all I know this posting needs to be moved, but that can be figured out later, right now, I need a little help...

So, where I work we keep a call log of who's called in, what they wanted and how we helped. At this time that's handled with a word document, but my boss would like to move away from that method and I said excel should do what we're looking for and be able to integrate data from these spreadsheets into a master spreadsheet...we have 4-6 people who need to make these call logs and then to compile them all up into one grand sheet that the boss on her computer...is this really possible? And, how?

Hi, welcome to the forum

Depenmding on exactly what you are capturing (and how), and what you intend to do with it, this is probably do-able.

Thanks for the title change

Can you provide a few (clean) samples of what you are working with, and what you expect?

Yes, I saw the PM and have changed my post #2

I did a simple copy/paste from word to excel, then cleaned it up a bit. See if this is heading in the right direction?

The reason I added the date and name columns is because, when you start pulling these into a master WB, that info will probably be needed.

Plus, the way I see this working, is that you just keep entering data, 1 below the other, month after month, to build up a big database. Doing it this way, you will definitely need a data and name attached to each record.

How did you forsee this working for, say, January (or any "next" month)

would it be making it too complicated to have a new sheet each day,

indeed it would - think about it...within just 1 year, you would have 365 worksheets x 4-6 files. How would you ever find anything you wanted?

Again, I suggest that you have 1 table with ALL data entered into it, and, at MOST, have 1 WB per month.

How many records do you thing you will create in 1 day, anyway?

In the winter, between 5 and 10, but in the summer, easily, 50 or more...

even at 100 per day, that is still less than 40 000 records...small by some excel database standards

I think multiple worksheets are fine, as long as the boss's workbook makes sense...

You need to get away from thinking of the end product 1st. Consider the data entry 1st, THEN work on what the output needs to look like (ask any of the experts here)

Now, take another look at that sample I uploaded, will that suite your input needs? (remember, keep it simple)

If so, can you populate it with some sample data, that would cover a few days and a few months?

Attached is a sample of what I am suggesting.

- I put all 3 sheets of data into 1 sheet
- I have put (just to play with, and show you what is possible) Service Provided in C1 and the month/Year in F1
- change the SP and the Month/year (entered atthe moment as just Month name space 4-digit year, but we can play with that too)