I have a worksheet that looksup other worksheets we continually update.
However, when we enter information day to day, we want the information to
stay as is when we enter it, not to update with the other worsheets. Is
there any way to quot;snapshotquot; the information it looks up other than going in
at the end of each day and copy and paste special new entries?
I don't think so. I think that the best you'd be able to do is to mechanize the
copy|paste special|Values.
scoutfinch22 wrote:
gt;
gt; I have a worksheet that looksup other worksheets we continually update.
gt; However, when we enter information day to day, we want the information to
gt; stay as is when we enter it, not to update with the other worsheets. Is
gt; there any way to quot;snapshotquot; the information it looks up other than going in
gt; at the end of each day and copy and paste special new entries?
--
Dave Peterson
- Oct 22 Sun 2006 20:09
Updating Functions (Vlookup)
close
全站熱搜
留言列表
發表留言