Hello Excel Gurus,
I need your help, please. I am trying to create a time plan in Excel. I got two columns, one says "Start", the other "End". I'd like to have these two cells automatically filled out when a first non-empty cell is detected in an array - i want it to pick up or "echo" the value of the cell I choose. Please check this table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]8.5[/TD]
[TD]8.6[/TD]
[TD]8.7[/TD]
[TD]8.8[/TD]
[TD]8.9[/TD]
[TD]8.10[/TD]
[/TR]
[TR]
[TD]Site 1[/TD]
[TD]8.5[/TD]
[TD]8.8[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 2[/TD]
[TD]8.7[/TD]
[TD]8.10[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Site 3[/TD]
[TD]8.6[/TD]
[TD]8.8[/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 4[/TD]
[TD]8.9[/TD]
[TD]8.10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]
Thank you very much in advance.
I need your help, please. I am trying to create a time plan in Excel. I got two columns, one says "Start", the other "End". I'd like to have these two cells automatically filled out when a first non-empty cell is detected in an array - i want it to pick up or "echo" the value of the cell I choose. Please check this table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]8.5[/TD]
[TD]8.6[/TD]
[TD]8.7[/TD]
[TD]8.8[/TD]
[TD]8.9[/TD]
[TD]8.10[/TD]
[/TR]
[TR]
[TD]Site 1[/TD]
[TD]8.5[/TD]
[TD]8.8[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 2[/TD]
[TD]8.7[/TD]
[TD]8.10[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Site 3[/TD]
[TD]8.6[/TD]
[TD]8.8[/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 4[/TD]
[TD]8.9[/TD]
[TD]8.10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]
Thank you very much in advance.