MS Excel or Office Help
Dec. 3rd, 2002 03:11 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
dancerjodiHello All,
Sorry to bug you with a question on such stupid software(s). I've just changed from a job where I had some really neat tools to one relying soley on MS Excel and Access and I'm trying to make them jump through hoops that I'm not sure they are meant to jump through (keep in mind too, I don't know Visual Basic but have been able to get them to do some things with SQL).
I'm trying to take a file listing
Name $amount_1 $amount_2
Bob Smith $30 $40
Mary Jones $25 $33
Etc
And I need to take each individual record per person and insert it into a new document, listing only the data for that person. This ideally would happen somewhat automatically and would allow me to re-run the process as needed (though, I don't have to actually save each individual 'entry' or 'file' per person - most likely I'll be printing it).
Any ideas how to automate this? I was asked to do it and was told that the old analyst had a neat way to do it (her neat way was creating a template and then manually linking in each individual row of data, ick).
Any tips would be really helpful (And yes, I have been poking around in the help files and online)
Sorry to bug you with a question on such stupid software(s). I've just changed from a job where I had some really neat tools to one relying soley on MS Excel and Access and I'm trying to make them jump through hoops that I'm not sure they are meant to jump through (keep in mind too, I don't know Visual Basic but have been able to get them to do some things with SQL).
I'm trying to take a file listing
Name $amount_1 $amount_2
Bob Smith $30 $40
Mary Jones $25 $33
Etc
And I need to take each individual record per person and insert it into a new document, listing only the data for that person. This ideally would happen somewhat automatically and would allow me to re-run the process as needed (though, I don't have to actually save each individual 'entry' or 'file' per person - most likely I'll be printing it).
Any ideas how to automate this? I was asked to do it and was told that the old analyst had a neat way to do it (her neat way was creating a template and then manually linking in each individual row of data, ick).
Any tips would be really helpful (And yes, I have been poking around in the help files and online)
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject
Date: 2002-12-04 08:19 am (UTC)Take a look at these different "Tips and Tricks" for some complex office stuff...
http://www.microsoft.com/technet/archive/default.asp?url=/technet/archive/office/office95/tips/IME97B4.asp