I can do this. Please email me at excelvba...@gmail.com On Fri, Aug 12, 2011 at 9:08 AM, JsinSk <jsin...@gmail.com> wrote:
> Hello, I would like to see about some assistance with the following > problem, due to some re-arranging in our warehouse I need to have a > report separate locations on different sheets. > > Locations are listed as > > AA-A-0 > AA-A-1 > AA-A-2 > AA-A-3 > AA-A-4 > AA-B-0 > AA-B-1 > AA-B-2 > AA-B-3 > AA-B-4 > AA-C-0 ... and so on.. to AA-M-4 > > Area one locations go from AA-A-0 to MM-M-4 in one area and should all > be placed on one sheet. > > Area two locations go from AAA-A-0 to MMM-M-4 and should be placed on > a sheet > > Area three locations go from A-A-0 to Z-M-4 > > Sheets should be renamed based on area (Area 1, Area 2,Area 3) > > All locations will be in column A and the entire row needs to be > moved. (typically only A through F has data) > > Thanks > Jason > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel