G
Guest
I have an excel data file which has 4 columns - employee number, employee name, orgcode, and # per org
I have entries for 1 to 14 employees in each orgcode, and the first entry has the total for that org in column D "# per org code", but the rest of the entries in that org code don't have an entry in the 4th column
If it were a simple merge I would know what to do, but what I need ideally is to be able to merge into a letter the information for each org code - or at least to print out a page which lists an org code and the names in that orgcode
Is this possible to do this? I've racked my brain and can't figure it out. Ideally I'd like to use Word and Excel, or just Excel. I've wondered about whether or not Excel and Access could be used, but I would probably need a little direction on that. I have use Access, but am no means an expert on it since I usually use a wizard.
Hope someone out there has encountered this before and can give me some direction. It's for a critical project involving a lot of names and I can't see myself spending many hours pointing and clicking if I can make the data work another way. Any direction would be most appreciated!
I have entries for 1 to 14 employees in each orgcode, and the first entry has the total for that org in column D "# per org code", but the rest of the entries in that org code don't have an entry in the 4th column
If it were a simple merge I would know what to do, but what I need ideally is to be able to merge into a letter the information for each org code - or at least to print out a page which lists an org code and the names in that orgcode
Is this possible to do this? I've racked my brain and can't figure it out. Ideally I'd like to use Word and Excel, or just Excel. I've wondered about whether or not Excel and Access could be used, but I would probably need a little direction on that. I have use Access, but am no means an expert on it since I usually use a wizard.
Hope someone out there has encountered this before and can give me some direction. It's for a critical project involving a lot of names and I can't see myself spending many hours pointing and clicking if I can make the data work another way. Any direction would be most appreciated!