Any takers for this call?
On Fri, Dec 18, 2009 at 3:32 PM, kamal shah <kamal...@gmail.com> wrote: > Hello Excel Gurus, > > I have a task of copying data (specific column from specific place) to a > new work book's worksheet at specific column from specific cell. > I have attached both work books for reference here. > > ST - Original Workbook. > AT - Target Workbook > > my requirement is > Map E19 onwards Column of ST to F Column of AT = Session Date > (Into next down cell of text value - DATE) > Map F19 onwards Column of ST to H Column of AT = Function (Into > next down cell of text value - FUNCTION) > Map G19 onwards Column of ST to G Column of AT = Description > (Into next down cell of text value - Event) > Map H19 onwards Column of ST to I Column of AT = Comments (Into > next down cell of text value - Check) > > I hope you got what my requirements is. > > I have to merge almost 300 plus excel files into a new format. > > Any help on this will be highly appreciated. > Even if I get a code to copy/paste one column, I should be able to do it > iteratively for all columns. > > thanks once again! > > > > -- > > ---------------------------------------------------------------------------------- > 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 > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
