Dear Group, I have excel sheets containing sales data on daily basis (from about 150 sites) (The columns are similar in all the daily sale files but rows change from time to time as new sites either become operational or stop working). I wish to consolidate all the data in one excel file in such a way that the macro extracts data from specific cells and inputs them into the consolidated sheet, Further, once one sheet is full in the consolidated sheet, the macro would automatically create a new sheet and start inputing the data there.
If this task can be done easily with access, I'm all ear for access based suggestion as well. 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 <><><><><><><><><><><><><><><><><><><><><><> 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
