Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sent Here for Excel VBA Help

Status
Not open for further replies.

jksb

Technical User
Sep 27, 2000
133
0
0
US
One more time..I keep click the wrong links :)ended up in SQL last time!

I already checked with the other forum (Office General) and was directed back here :)

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top