Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keeping a transfered value the same after changing the original va
Two worksheets - worksheet 1 cell A1 has a value (week of the year). I enter
sales for each day S, M, T, etc. Worksheet 2 has 52 seven day weeks. I need to enter Sales into worksheet 1 week 1 and have it transfer to the correct week in worksheet 2. When I change the week number in worksheet 1 cell A1 (to week 2), I need the values to remain unchanged in Worksheet 2 Week 1. Worksheet 1's format remains the same (seven days), however the values change weekly (weeks 1 through 52). I use =IF(' worksheet1'!A1=1,' worksheet1'!E14) and get the sales to enter into worksheet 2. When I change the week to week 2 (in worksheet 1) the sales in worksheet 2 week 1 defalt to "FALSE". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
Pivot and changing External data source | Excel Discussion (Misc queries) | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
Keeping Array values? | Excel Worksheet Functions |