Dear Friends, Please share your knowledge with regard to following excel issue.
I have about 100 sheets with exactly similar format but different data. for e.g., "Column A" has a 20 items in 20 row, next "row 2" about 20 items in 20 column (These are fixed). Now, there are inputs corresponding to cells within these boundary Now, i have some unique inputs in Cells D13, F15, G10 etc. I have created another excel sheet and given the column Heading as D13, F15, G10 and so on. I need the data to be extracted from these particular cells from all 100 sheets and to be placed one below the other in the new excel sheet created at respective column heading. Hope i am clear in explaining the issue. Early help is requested Thanks in advance Satish --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
