I have a marksheet with students' names
in e3 to 36 columns total is put using sum formula
but suppose i enter a subject then i have to shift sum formula to F3 to F7 but manually
is there any way that i enter a column or row and put data in that column and sum formula is changed automatically for adding the data in that new coloumn
plz
Find sample worksheet
If you insert rows or columns in the middle of your data the formulas adjust automatically. If you insert in the beginning/end I believe they do not. Try it out by inserting a column between B and C and see for yourself.
Plz try ur best i have no idea wht to do
If you add a blank column just before your total column, include that column in your total/sum, and then insert any new columns just before that blank column, then any values you add will be included in the total
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks