Two Questions About Excel/Adding/SplitScreen

[jksb]

Easy questions, probably, but finding the answers isn't

1) Can I get Excel to automatically add data in the same cell as it is being entered (ie, 5 of a product went out; then four hours later 5 more). I don't want to have a column for each time the product goes; just want Excel to add to what is there when I go to the cell (I have the spreadsheets by day, so only need a daily tally).


2) Can I tell Excel to automatically split the screen for all the sheets in a workbook (31) without going to each sheet and manually doing it?

Thanks!

Jackie

 

[Dreamboat]

JK:

Question 1) This can be done with a formula written in code.

Question 2) Probably the same as above, but by the time you write code to do it, you could do it manually and leave it that way.

I personally suggest you post your question in the Access forum because many of them will know Excel VBA (which I'd include in the title of the question).

Sorry no answers, but I hope the direction helps.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[jksb]

Thanks! What seems like easy questions (from me it seems) turn complicated

Jackie