JCHuysamer
New Member
- Joined
- Nov 3, 2015
- Messages
- 43
Hi Guys and girls
Thanks for all the help to date
I finally completed my Template - but with it being in "testing Mode - Alpha or Beta" (don't know how you clever ppl refer to it) their has been a few requests to make the document easier to use. Sorted out most of it but i am once again stuck.
I have 4 Worksheets (Cover Page, Task Steps, Task Analysis, PTO)
I have a equation on the Task Analysis Worksheet that copy's the text from column A (Task Steps Worksheet) to column B onTask Analysis Worksheet depending on what number is typed into Column A
(ie.:=IF(A4=1,'Task Steps'!$B$12,IF(A4=2,'Task Steps'!$B$13,IF(A4=3,'Task Steps'!$B$14,IF(A4=4,'Task Steps'!$B$15,IF(A4=5,'Task Steps'!$B$16,IF(A4=6,'Task Steps'!$B$17,IF(A4=7,'Task Steps'!$B$18,IF(A4=8,'Task Steps'!$B$19,IF........... and so on)
I need a popup window (similar to the comments popup) to display with the text from column C (Task Steps) corresponding with the he number that was typed in column A on the Task Analysis Worksheet on the Task Analysis Workbook when I select cell C in that same row
Task Steps
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]task #[/TD]
[TD]task steps[/TD]
[TD]description of step[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD]take door handle and turn[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]walk to car[/TD]
[TD]walk down steps to car[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]open car door[/TD]
[TD]put the key in the door and turn to unlock the door[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Task Analysis
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD](display in popup when i select the cell- take door handle and turn )[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]walk to car[/TD]
[TD](display in popup when i select the cell- walk down steps to car )[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD](display in popup when i select the cell- take door handle and turn )[/TD]
[/TR]
</tbody>[/TABLE]
When I put the task # in Column A it copy's the corresponding step to Column B from the previous worksheet
If I select Column C I want the text from Task Steps to display as above
Thanks for all the help to date
I finally completed my Template - but with it being in "testing Mode - Alpha or Beta" (don't know how you clever ppl refer to it) their has been a few requests to make the document easier to use. Sorted out most of it but i am once again stuck.
I have 4 Worksheets (Cover Page, Task Steps, Task Analysis, PTO)
I have a equation on the Task Analysis Worksheet that copy's the text from column A (Task Steps Worksheet) to column B onTask Analysis Worksheet depending on what number is typed into Column A
(ie.:=IF(A4=1,'Task Steps'!$B$12,IF(A4=2,'Task Steps'!$B$13,IF(A4=3,'Task Steps'!$B$14,IF(A4=4,'Task Steps'!$B$15,IF(A4=5,'Task Steps'!$B$16,IF(A4=6,'Task Steps'!$B$17,IF(A4=7,'Task Steps'!$B$18,IF(A4=8,'Task Steps'!$B$19,IF........... and so on)
I need a popup window (similar to the comments popup) to display with the text from column C (Task Steps) corresponding with the he number that was typed in column A on the Task Analysis Worksheet on the Task Analysis Workbook when I select cell C in that same row
Task Steps
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]task #[/TD]
[TD]task steps[/TD]
[TD]description of step[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD]take door handle and turn[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]walk to car[/TD]
[TD]walk down steps to car[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]open car door[/TD]
[TD]put the key in the door and turn to unlock the door[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Task Analysis
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD](display in popup when i select the cell- take door handle and turn )[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]walk to car[/TD]
[TD](display in popup when i select the cell- walk down steps to car )[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD](display in popup when i select the cell- take door handle and turn )[/TD]
[/TR]
</tbody>[/TABLE]
When I put the task # in Column A it copy's the corresponding step to Column B from the previous worksheet
If I select Column C I want the text from Task Steps to display as above