drag / fill

[bigdan]

I've got 3 small questions, dont think its enough to make 3 new posts out of. For future if I should, let me know.

1. Sometimes when I start with a single number and drag, it increments when I dont want it to. Is there some way of making it clear during the drag if its supposed to increment or stay the same? My current procedure is to make the cell underneath the same then drag both together. Not too bad but not ideal.

2. I'm working w/ a 2 tab spreadsheet. The second one refers entirely to the first one for journal entries. I was noticing a number of #REF! errors. I finally realized this happens when I cut one cell and put it somewhere else. I guess this changes the references; but is there any way around this? At the moment I'm copying from source to destination, then erasing the source. Which is OK but if there's an alternative that's better.

3. Our dept uses the same log. You put your name and file you're working on on one line and save. Next person goes to next line etc. Is there some way of recording on an adjacent cell what TIME this row / cell was filled in?

 

[HalfAce]

Hi dan,
OK, for No. 1 - I believe you're already doing all you can do. At least that's how I do it, make the first two cells equal and then drag.

For No. 2 - Without knowing all the details, I think you may be doing all you can do here too. The only option that comes to mind would be to use named ranges on your source cells/ranges. You can move a named range and maintain your formulas, so that might be something to look into.

For No. 3 - Yes. If you can determine a column that will ALWAYS get filled in, we can trap any change(s) made in that column and have it output the time that change was made anywhere you like. (Can you describe your desires for that?)

Hope this helps.