gls9879872
New Member
- Joined
- Apr 7, 2017
- Messages
- 4
I was trying to find a way not to do redundant work. Same spreadsheet, Sheet1 and Sheet2. I would like Sheet2 Column D to autofill with the data from Sheet1 Colum D. But based in the Input of Sheet1 Column E & F. Or the opposite would be good also. Have Sheet1 Column E & F autofill with data from Sheet2 Column B and Column C based on the input in Sheet2 Colunm D. Thanks for any help. Or any direction on what way this can be achieved.
Sheet1:
[TABLE="width: 920"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]AV001
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-001
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV002
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-002
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV003
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-003
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV004
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-004
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV005
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-005
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV006
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-006
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
[TR]
[TD]AV007
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-007
[/TD]
[TD]2
[/TD]
[TD]8
[/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
[TR]
[TD]AV008
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-008
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
[TR]
[TD]AV009
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-009
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2:
[TABLE="width: 1040"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 101
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]TV-AV-012
[/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 102
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 103
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]TV-AV-011
[/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 104
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]Projector-AV-009
[/TD]
[/TR]
[TR]
[TD]Description/Location
[/TD]
[TD]Building#
[/TD]
[TD]Room#
[/TD]
[TD]Device Label
[/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 201
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]Projector-AV-008
[/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 202
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 203
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 204
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 205
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 206
[/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 207
[/TD]
[TD]2
[/TD]
[TD]7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 208
[/TD]
[TD]2
[/TD]
[TD]8
[/TD]
[TD]Projector-AV-007
[/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 209
[/TD]
[TD]2
[/TD]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 210
[/TD]
[TD]2
[/TD]
[TD]10
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Description/Location
[/TD]
[TD]Building#
[/TD]
[TD]Room#
[/TD]
[TD]Device Label
[/TD]
[/TR]
[TR]
[TD]Building 3, 1st Floor, Rm 301
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet1:
[TABLE="width: 920"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]AV001
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-001
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV002
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-002
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV003
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-003
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV004
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-004
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV005
[/TD]
[TD]EX3240 Projector - V11H719020 - White
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-005
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]AV006
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-006
[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
[TR]
[TD]AV007
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-007
[/TD]
[TD]2
[/TD]
[TD]8
[/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
[TR]
[TD]AV008
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-008
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
[TR]
[TD]AV009
[/TD]
[TD]HC 1040 Projector - V11H772020 - Black
[/TD]
[TD]Projector
[/TD]
[TD]Projector-AV-009
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]xxxxxxx
[/TD]
[TD]4/4/2020
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2:
[TABLE="width: 1040"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 101
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]TV-AV-012
[/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 102
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 103
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]TV-AV-011
[/TD]
[/TR]
[TR]
[TD]Building 1, 1st Floor, Room 104
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]Projector-AV-009
[/TD]
[/TR]
[TR]
[TD]Description/Location
[/TD]
[TD]Building#
[/TD]
[TD]Room#
[/TD]
[TD]Device Label
[/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 201
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]Projector-AV-008
[/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 202
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 203
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 204
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 1st Floor, Room 205
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 206
[/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 207
[/TD]
[TD]2
[/TD]
[TD]7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 208
[/TD]
[TD]2
[/TD]
[TD]8
[/TD]
[TD]Projector-AV-007
[/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 209
[/TD]
[TD]2
[/TD]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Building 2, 2nd Floor, Room 210
[/TD]
[TD]2
[/TD]
[TD]10
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Description/Location
[/TD]
[TD]Building#
[/TD]
[TD]Room#
[/TD]
[TD]Device Label
[/TD]
[/TR]
[TR]
[TD]Building 3, 1st Floor, Rm 301
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]