A
awsmitty
I have 2 spreadasheets. The fist one is named "Name and Bed Entry". On this
spreadsheet the user literally types in a name as it relates to a bed (or
room number) and other info. The name and room number is then linked to
another spreadsheet called Master Resident Info. This spreadsheet has the
cost of that room. So, in Master Resident Info, the name entry actually
looks like ... =IF('[Name & Bed Entry test.xls]Name Entry'!$B$52="","",'[Name
& Bed Entry test.xls]Name Entry'!$B$52). The cost of the room in Master
Resident Info however, is an actual number, $40.00.
Here's the problem. Suppose Joe Blow changes room, but I want to keep Joe
Blow at the same rate. So, the first changes are made on the first
spreadsheet, just a simple swap of info, no problem; swap Joe Blow from room
212 to 224. The name is in column B on Name and Bed Entry, but now I need to
swap the cost of the room, which is on Master Resident Info. How can I tell
the macro to go to Master info to execute the swap on a different
spreadsheet. (Everytime I write a question on these forums, which isn't that
often, I wonder ... can the reader really undestand what I'm talking about?)
So, to paraphrase, Joe Blow gets swapped from B12 to B24 on spreadsheet Y,
and I need to include in the macro to swap the rate from H12 to H24 in
spreadsheet Z.
Can someone help. Please I am new to this stuff (started last November).
(Actually it was forced upon me.)
I hope some one can help me, please. Thanks for you time.
spreadsheet the user literally types in a name as it relates to a bed (or
room number) and other info. The name and room number is then linked to
another spreadsheet called Master Resident Info. This spreadsheet has the
cost of that room. So, in Master Resident Info, the name entry actually
looks like ... =IF('[Name & Bed Entry test.xls]Name Entry'!$B$52="","",'[Name
& Bed Entry test.xls]Name Entry'!$B$52). The cost of the room in Master
Resident Info however, is an actual number, $40.00.
Here's the problem. Suppose Joe Blow changes room, but I want to keep Joe
Blow at the same rate. So, the first changes are made on the first
spreadsheet, just a simple swap of info, no problem; swap Joe Blow from room
212 to 224. The name is in column B on Name and Bed Entry, but now I need to
swap the cost of the room, which is on Master Resident Info. How can I tell
the macro to go to Master info to execute the swap on a different
spreadsheet. (Everytime I write a question on these forums, which isn't that
often, I wonder ... can the reader really undestand what I'm talking about?)
So, to paraphrase, Joe Blow gets swapped from B12 to B24 on spreadsheet Y,
and I need to include in the macro to swap the rate from H12 to H24 in
spreadsheet Z.
Can someone help. Please I am new to this stuff (started last November).
(Actually it was forced upon me.)
I hope some one can help me, please. Thanks for you time.