Hi Group,
Hope this mail finds you doing well!!
Would like to grab this opportunity to learn as how can i consolidate more than 15 excel spreadsheet data into one workbook. Would also like to share one experience that was seen by me, one of the associate in our org has done automation project on the same which i have just said. so what the automation is, i am now try to explain you in the below bullets:
1. He opens a workbook (automated one) and mentioned the path in a particular cell (where all the excel sheets are residing with data).
2. He go to the another tab of the same workbook and press a button and then.....'booom, all the spreadsheets open one by one, closed automatically and stores the data in the automated workbook. Isn't so great...
In just two steps consolidation is done...and this is exactly i want to learn through my group. Here is one thing i am very new to VBA and require great assistance from your side.
Thanking in anticipation.
Regards,
Nishu
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar