Dear All, Please find attached a file. It contains four sheets. Sheet branches contains details for branches, sheet data contains data for the branches and sheet report contains the rough format in which I need the report to be in.
My quest is that when ever a new branch is opened, for example, branch 23 in city A, a macro (or some sort of formula) runs, which automatically enters a row in the report sheet for city A data, copy pastes the formula from the above row and brings the data in the report sheet (There is no need to update any record in data sheet). The way the report may look after the macro runs is as shown in sheet report (2). A prompt reply will be highly appreciated. Best Regards, ZAC -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Exp.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
