 | Senior Member with 177 posts. | | Join Date: Feb 2003 Location: Kentucky Experience: Intermediate | | Solved: Excel or Access or something else??? Is it possible somehow to take a list of names in an excel file that are listed in columns per below:
Employee Dependent SSN
Bob Smith Tracy Smith 444444444
Bob Smith Terry Smith 333333333
Bob Smith Alice Smith 222222222
What I need is for the results to be like in a flat file (or all in one line)like this:
Employee Dependent1 SSN1 Dependent2 SSN2 Dependent3 SSN3
Bob Smith Tracy Smith 444444444 Terry Smith 333333333 Alice Smith 22222222
I am trying to do a mail merge and it needs to be in this order if possible. Does anyone have any idea if this is possible??? Thanks!!
__________________ Don't be a Douche Bag!! | | Distinguished Member with 9,331 posts. | | Join Date: Mar 2005 Location: UK Experience: An old Basic Programmer | | This can be done in either Access or Excel. But I think that you will need an Excel Macro or Access VBA to do it.
It is probably marginally easier in Excel with a macro, but the control of the data is better in Access, so really the choice is yours, personally I would go with Excel if the data is already there.
__________________ OBP
I do not give up easily | | Senior Member with 177 posts. | | Join Date: Feb 2003 Location: Kentucky Experience: Intermediate | | Thanks for your advise but there lies the main problem, I do not know how to write a macro. Could any give any advise on how to write a macro in excel (if it is the easiest)? | | Distinguished Member with 9,331 posts. | | Join Date: Mar 2005 Location: UK Experience: An old Basic Programmer | | allen, I am just a bit busy at the moment, I will ask slurpee if he can have a look at it for you, he seems to be the only other regular looking in at the moment, although Double Helix might take a look.
If they can't do anything for you by tomorrow i will have a go, it shouldn't take long it just needs a loop to compare the names in Column A and if it doesn't change put the name in Column B in to the next column on another sheet.
__________________ OBP
I do not give up easily | | Distinguished Member with 9,331 posts. | | Join Date: Mar 2005 Location: UK Experience: An old Basic Programmer | | It would help if you posted an excel sheet with those examples on already | | Senior Member with 177 posts. | | Join Date: Feb 2003 Location: Kentucky Experience: Intermediate | | Here you go OBP.
One other thing, I am only showing 3 dependents on this sheet but I need to make it work for up to 8 dependents.
Thanks for your time. | | Distinguished Member with 9,331 posts. | | Join Date: Mar 2005 Location: UK Experience: An old Basic Programmer | | This should do it, just click the button | | Senior Member with 177 posts. | | Join Date: Feb 2003 Location: Kentucky Experience: Intermediate | | WOW....thank you so much. That should do it!!! | | Distinguished Member with 9,331 posts. | | Join Date: Mar 2005 Location: UK Experience: An old Basic Programmer | | Can you mark the thread as Solved please? |  THIS THREAD HAS EXPIRED.
Are you having the same problem?
We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.
|
Smart Search
| Find your solution! | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | |  WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
| You Are Using: |
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 08:19 AM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd. | |
|