LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default updating cell data and keep from overwriting

I have users input number of hours for a particular month/day, and it updates
a table in another sheet...this works fine, until...the user changes days,
and then the original info gets zeroed, not kept.

For instance, user enters 8 hrs for january 1... which then gets written to
table col/row for january 1. However, when they go to enter hrs for january
2, january 1 info gets set back to zero, and january 2 reflects the 8, etc.

How can I "freeze" the original input once it's entered without subsequent
info updating it?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to paste rows in 2007 without overwriting data? GAMEnt User Excel Discussion (Misc queries) 4 September 29th 07 11:06 PM
Need to add data to a cell without overwriting what's there bettywonka New Users to Excel 1 January 8th 07 08:56 PM
Overwriting data Cody Excel Discussion (Misc queries) 5 November 27th 05 02:40 AM
Copying format to a new cell, w/o overwriting destination cell contents James C Excel Discussion (Misc queries) 1 October 18th 05 08:02 PM
Overwriting of linked data kivar Excel Discussion (Misc queries) 0 June 2nd 05 03:04 PM


All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"