How to use macros to change Information from one location to another location

[Roco]

When using my "userform", "Equipment To Move" (I have attached my file)

What I would like to do here is after I have picked the location where
the equipment is (which comes from the "EquipmentList Tab" under
column "E", I than select where I want the Equipment Delivered To from
my userform, (which comes from the "ProjectList Tab".

I would like to have the "Delivered To" information to replace the Information
on the "EquipmentList Tab" under column "E" to show where the equipment
is now located. So when I go to move the equipment again I will know which
project that it is located at.

Any help on this would be greatly appreciated. Thanks in advanced for your help.

Roco

[xladept]

Try:

Please Login or Register  to view this content.

[Roco]

xladept

I got it to do the same thing you did...on the "EquipmentMoves Tab" I need the Pickup Location not to change on this sheet, but I do need it to change on the "EquipmentList Tab" in Column "E" for the location for future moves. Halfway there...


Roco

[xladept]

??:

Please Login or Register  to view this content.

[Roco]

Thanks man...I just had to make a couple of changes on how it hit my table on "Equipment Moves"....it works great. Thanks again.

[xladept]

You're welcome and thanks for the rep!