I come again requesting help. Once again, I'll do my best to explain this as detailed and as easily as I can.
I have an Excel worksheet called "Data" that functions much like a database in the sense that each row is a new "record" containing employee information. I currently have MS Word setup to generate the report needed from this information with "Mail Merge", much like MS Access would function (record arrows to advance to the next employee at the top, etc...). However, with the 60+ fields that it generates, MS Word is not the most reliable to keep links and such.
So, I'm trying to go back to my roots and just keep the entire report creation within Excel. The problem I run into is that there are around 75 employees, so taking the time to link 60+ fields for 75 employees would be extremely overwhelming. Obviously the easy way would be to create the standard template at the top, and just drag it down to allow Excel to create the new links itself. However, it doesn't work in this case because the report spans about 30 rows, so when information is copied down, it only hits every 30 employees. Does that make sense?
So, to simplify these ramblings...I have a data sheet of 75 employees' information that I wish to incorporate into a standard report format. Any ideas?