really want or need to do.
Do you want to just put all the data in the same workbook ?
Do you want to put part (a couple of fields) of the data from 2011 worksheet into 2012 worksheet ?
Depending on how the data is laid out, pulling selected data entries from one spreadsheet to another is fairly simple.
Lots of possiblities...just not sure how much data you want bring over and how it will be laid out.
Plz help me! I have two customer data sheet in excel.The first sheet is mainly customer info and consumption detail in 2011, the second is the customer sheet for consumption in 2012. Each customer with a unique Customer ID. I want to pick out the old customer of 2011 from 2012, and analysis their detail consumption info, and decide a best customized marketing plan for them. So how can i do this quickly, since i have more than 10 thousand customers.