I don't know what to do!!
 

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!

I don't know what to do!!
 

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

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!

I don't know what to do!!
 

Files missing please.

"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

I don't know what to do!!
 

You can't attach files to this newsgroup.

--

JoAnn Paules
MVP Microsoft [Publisher]




"PY & Associates" wrote in message
...
Files missing please.

"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

I don't know what to do!!
 

JoAnn Paules [MVP] wrote:
You can't attach files to this newsgroup.

The files are accessible via Google Groups. Go to the newsgroup
microsoft.public.excel.newusers.

I would open attachments only by logging into a restricted account, not
an administrator account. When I did that and looked at the files, I
saw "raw" text, not Excel files. In one case, the data is completely
unstructured -- obvious in some input format for something. Good luck!

My suggestion to the OP: hire an Excel consultant. "You get what you
pay for!"

I don't know what to do!!
 

Still not a good idea. Unless you're using Google Groups, those files don't
exist. And no one in their right mind would open an attachment in a
newsgroup.

--

JoAnn Paules
MVP Microsoft [Publisher]




wrote in message
oups.com...
JoAnn Paules [MVP] wrote:
You can't attach files to this newsgroup.

The files are accessible via Google Groups. Go to the newsgroup
microsoft.public.excel.newusers.

I would open attachments only by logging into a restricted account, not
an administrator account. When I did that and looked at the files, I
saw "raw" text, not Excel files. In one case, the data is completely
unstructured -- obvious in some input format for something. Good luck!

My suggestion to the OP: hire an Excel consultant. "You get what you
pay for!"

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

I don't know what to do!!
 

I have not looked at your files but I may??? have an idea of what you are
trying to do. You may contact me privately.

--
Don Guillett
SalesAid Software

"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

Is there any way I can get you to call me or write my personal e-mail address? I can be reached at 800-521-2515 x2004 (I will be here until 6:30 Mountain Time) or you can reach me at my personal e-mail:


Thanks so much for all your help! If you can help me out I can get you a 20% discount to stay in one of our properties here in Sun Valley!

Quote:

Originally Posted by Don Guillett I have not looked at your files but I may??? have an idea of what you are trying to do. You may contact me privately. -- Don Guillett SalesAid Software "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

I don't know what to do!!
 

NEVER, NEVER, NVER post your phone number or unmunged email address!

--

JoAnn Paules
MVP Microsoft [Publisher]




"Stephanieo99" wrote in message
...

Is there any way I can get you to call me or write my personal e-mail
address? I can be reached at XXXXXXXXXX (I will be here until
6:30 Mountain Time) or you can reach me at my personal e-mail:
xxxxxxxxxxxxxxxxxxxx


Thanks so much for all your help! If you can help me out I can get you
a 20% discount to stay in one of our properties here in Sun Valley!

Don Guillett Wrote:
I have not looked at your files but I may??? have an idea of what you
are
trying to do. You may contact me privately.

--
Don Guillett
SalesAid Software

"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 -


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Stephanieo99