Home |
Search |
Today's Posts |
#1
|
|||
|
|||
link several worksheets
Is there any way to achieve following:
WORKSHEET 1 (contains downtime in hours, max value 24.00) link1 link2 link3 date1 2.50 0.00 1.50 next date 0.00 0.00 0.00 WORKSHEET 2 (computes availability in percentage based on value in worksheet1) link1 link2 link3 date1 89.58 100.00 93.75 next date 100.00 100.00 100.00 Thus every day, data is fed in WORKSHEET1, and thus it keeps on growing in size. The data in WORKSHEET2 should get updated automatically, by addition of extra rows everyday, and copying formula etc. Kindly also help if WORKSHEET two data should appear in transposed manner, i.e. with each row addition in WORKSHEET1, columns get added in WORKSHEET2. Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
How to link worksheets so editing one will edit others automatica | Excel Worksheet Functions | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
What formula do I use to link worksheets together within one spre. | Excel Worksheet Functions |