Hi I need the following tasks to be automated whenever an additional tab is opened and data pasted into an Excel 2007 worksheet;
1) Look at a specific cell in the added sheet and dependant on its contents, add an additional row to one of three sections of a summary sheet (e.g. if cell = "house" then add a row under the 'house' heading on summary sheet, between rows 10 and 20, if cell = "flat" then add row under 'flat' heading on summary sheet, between rows 30 and 40) 2) Add the text from a specific cell in the added sheet into the new row on the summary sheet (1). 3) Look at the same specific cell (as 2) and dependant on its contents, concatonate with other data and name the tab of the sheet (e.g. if cell = "house" then concatonate with default text "WR" and another cell e.g "mansion" - so creating the tab name - "WR_mansion_house") I assume this would have be done via a Macro/VBA? Any help with this, much appreciated. Greg -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
