Thread
:
I don't know what to do!!
View Single Post
#
8
Posted to microsoft.public.excel.newusers
PY & Associates
external usenet poster
Posts: 145
I don't know what to do!!
We cannot figure out how you assign properties to each "guest".
Perhaps it is done manually each time.
If we may guess, the workflow should be:
read SEPT.TXT with Excel in sheet1;
read Property Address.txt in sheet2;
in a new column in sheet1, key in property id;
use vlookup to pull in property specifies from sheet2;
export relevant fields in text file to Final Result.txt format.
We believe your service provider can automate this with minimum effort.
Regards
PY & Associates
"Stephanieo99" wrote in message
...
I have attached three documents.
Sept = Test month (this comes from our reservation system)
Property addresses = Table where prop information is stored
Final Result = What I need the finished product to look like so I can
merge it to our envelope file in word
Thanks for all your help!
PY & Associates Wrote:
Send us sample files to have a look please
"Stephanieo99"
wrote in
message
...-
I have been working for good number of days on this "project" and
still
can't figure it out.
I work for a property management company and we print check in
enevelopes for our arriving guests. A prior employee had a convoluted
way of performing this using about four different programs... no one
in
IT can figure it out. I think there is a way to just use excel but my
IT
dept has given up on us.
Basically, I have a list of properties with their addresses and phone
numbers and other property specifics. Each property is assigned a row
in this table.
Bi-weekly, I would import the guest information to excel. Each guest
is
assigned a row in this table.
This is where it is getting tricky for me.
Here's what I would like the result to be:
I would like one field (property code) in the arriving guests table
to
trigger an auto fill of the next 5 or so boxes in that row with
information from the property information table.
I can then easily plug that table into a mail merge file to create
our
check in envelopes in word. (I know how to do this part already.)
I have tried a number of methods to no avail. Can someone please
help?
I would like to keep this in excel if possibe but I have also
experimented with Access. Since I am the only one in the office with
Access on my computer, that will make it tougher for the rest of the
employees here.
Thanks in advance for your help!
--
Stephanieo99-
+-------------------------------------------------------------------+
|Filename: SEPT.TXT |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=78|
|Filename: final Result.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=81|
|Filename: Property Addresses.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=80|
+-------------------------------------------------------------------+
--
Stephanieo99
Reply With Quote
PY & Associates
View Public Profile
Find all posts by PY & Associates