Adding/Removing Column to all sheets & making formulas work
I have a booking excel file that has 13 sheets, one for each month of the year and a total sheet.
The column at the top have employees names and as they leave or join i need to add/delete columns which contain there names and totals that copy via formula from the total sheet.
I need some kind of macro (i think) to create/delete these columns in the right places.
This is a link to my work in progress
https://docs.google.com/open?id=0Bxe...URPTnNETVl4Mzg
Hope somebody can help, thanks! :D
if you group all the sheets (select the 1st sheet, then click on the last sheet tab), whatever you do to 1 sheet, will be done to all the other sheets. so you could group the sheets, add the column to 1, type in the new name in 1 sheet, and it will be done for all sheets.
(or delete a column - as long as its not the last 1, that could mess up any summary formulas you have)
when you have finished adding the names, make sure that you ungroup the sheets before you update the summary sheet formulas for the new name, else, the changes on the summary sheet will be made to the data sheets too
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