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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA ?

Status
Not open for further replies.

jksb

Technical User
Sep 27, 2000
133
US
I already checked with the other forum 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
 
Sorry..posted this on the wrong forum :) Jackie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top