View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Saving without deleting previous input

Hi

Why do you enter data into the same cells on Sheet1 each week, only to
have them transferred to Sheet2 (hopefully to the next row on that
sheet) each time?
Why not just enter the 7 items of data, directly onto Sheet2 into the
successive row each week?
I can't see what you gain by entering tot he first sheet, as the data is
going to be destroyed the following week.

If you want to mail a copy of your workbook direct to me (not to the
newsgroup) with an explanation of what you are trying to achieve, I will
take a look and see if I can provide some suggestions for a solution.

To mail direct, remove NOSPAM from my email address.

--
Regards

Roger Govier


"kdmarvin via OfficeKB.com" <u32449@uwe wrote in message
news:6f25fb4cc2148@uwe...
" =IF(Master!$A$239172,Master!C$3,) "
I am a complete novice and have been told to 'go away' by several
excel help
sites so if you feel I am not far enough along to participate, please
say so.
I will understand. This is how I get the data from sheet 1 to enter
into the
respective cell on sheet 2. This formula is in a cell in sheet 2. I
used the
numerical for the month (39172)because I couldn't get it to work
automatically (=TODAY()) from sheet 1 otherwise. Next month I will
re-enter
data into the same 7 cells on Sheet 1 and the data will enter into the
proper
cells in Sheet 2 (D7:I7) due to the numerical month, then the
following month
(D8:I8) and so on.How do I get it to enter without redoing the
previous
month's data? Is there an IF.... 'SAVE' command? Or something along
the lines
of IF....IGNORE?I even bought a course from Ozgrid and still have been
unable
to figure this out.
Thank you in advance for all your help.



Fred Smith wrote:
From your description, you must be using a macro when 'the info goes
to the
respective individual page'.

Tell us how the information 'goes' to the respective page -- either
the formula
or the macro, and we'll help you figure out how to fix it.

For the sake of expediency let's say I have 2 worksheets. 1 is the
master
sheet that I use for data input on a monthly basis. #2 would be an
individual

[quoted text clipped - 6 lines]
the new data in that months' cells too. How do I get it to enter in
this
month yet not change the month before?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200703/1