# Thread: Referencing Thanks: 0 Likes: 0

1. ## Referencing

I have a table were I have a couple of static references, and I need to be able to copy paste across the sheet maintaining the same reference points. The Monday (and other days) value is derived from the week ending value (Sunday) in relation to the top percentage per day, what ever I try one or other reference moves every time and I need to do this cleanly for a year to start with

FPG

 D E F G H I J K 13 14.31% 14.27% 14.26% 14.31% 14.44% 14.31% 14.09% 14 15 55211 16 41929 17 10482 18 2800 19 20 Mon Tue Wed Thu Fri Sat Sun Mon 21 08/04/19 09/04/19 10/04/19 11/04/19 12/04/19 13/04/19 14/04/19 15/04/19 22 7901 7878 7873 7899 7975 7903 7782 7901

Formeln der Tabelle
 Zelle Formel D13 ='Global Key'!AE39 E13 ='Global Key'!AE40 F13 ='Global Key'!AE41 G13 ='Global Key'!AE42 H13 ='Global Key'!AE43 I13 ='Global Key'!AE44 J13 ='Global Key'!AE45 J16 =(J15-J18)*0.8 J17 =(J15-J18)*0.2 D20 =TEXT(D21,"ddd") E20 =TEXT(E21,"ddd") F20 =TEXT(F21,"ddd") G20 =TEXT(G21,"ddd") H20 =TEXT(H21,"ddd") I20 =TEXT(I21,"ddd") J20 =TEXT(J21,"ddd") K20 =TEXT(K21,"ddd") D22 =\$J\$15*D\$13 E22 =\$J\$15*E\$13 F22 =\$J\$15*F\$13 G22 =\$J\$15*G\$13 H22 =\$J\$15*H\$13 I22 =\$J\$15*I\$13 J22 =\$J\$15*J\$13 K22 =\$J\$15*D\$13

Excel Tabellen im Web darstellen >> http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4.8

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•