View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
urBrothaFromAnothaMotha urBrothaFromAnothaMotha is offline
external usenet poster
 
Posts: 1
Default I had to be handed this one.... (sigh)

I was sent multiple (5/6) Excel & Word (1/2) docs that are contact info for
past guests to a very big event (these docs are like almost or over 1000).
They will be used to create a list of invitees for this years shin dig.
Well, when they were created the author(s) were either lazy, stoned or both.
The info is there, but not populated properly and it is not
readable/printable/formatted in any type of a consistent or rational way. I
have been tasked with "cleaning it up". Meaning pulling all the info
together, and updating. I would like to do this efficiently and effectively.


I've tried a couple different things formatting wise in excel and looked at
access (which i haven't been able to properly import into) but my real
constraint is not the software or readability - it is time/ease. Any
ideas???? Should I use a merge? Start from scratch? import/export data?
I'd like to use a smart program that will do most of the formatting from the
existing info. Please help - I am on a deadline and dont have the time to
manually enter it again!