I couldn't upload the sample file, but today I emailed it to group address.
On Mar 10, 4:20 am, Sanjoy Nath <sanjoy.nath...@gmail.com> wrote: > no sample is there. > One thing more , for this , we can use the formula like > =indirect(Address(row,column) > > and no things like macro is necessary for all kinds of transformations > > > > > > On Wed, Mar 9, 2011 at 10:41 PM, CAN <cdelano...@gmail.com> wrote: > > First of all, thank you for all the help that I received so far. You > > guys are great. > > > Today I have the following problem. I have a file where all the data > > is on column A. The data is listing the name of a person in row 1, > > in row 2 and row 3 it list the address. > > > from the sample below I like to re-arrange the data so row 1 will be > > left as is on column A, row 1. The information on column A, row 2 > > moves to column B, row 1, and finally the data on column A, row 3 > > moves to column C, row 1. After that the process loops to populate > > row 2, row 3, etc, etc. > > > See below how the data is now > > > 1 7461-001 M Y Y JOSEPH LOPEZ 12 $111.25 01/01/09 $25.00 09 > > 17921 NW 79 CT > > MIAMI FL 33015 > > 2 7461-002 M Y Y ESPERANZA DIAZ 12 $111.25 01/01/09 $25.00 > > 7461 NW 175 ST. > > MIAMI FL 33015 > > 3 7461-003 M Y Y BERNARDO ARAUJO 12 $111.25 01/01/09 $25.00 > > 7461 NW 176 TERR > > MIAMI FL 33015 > > 4 7462-004 M Y Y JUAN AMAT 12 $111.25 01/01/09 $25.00 09 DAY > > 7462 NW 175 ST. > > MIAMI FL 33015 > > > This is how I need it to be > > > 1 7461-001 M Y Y JOSEPH LOPEZ 12 $111.25 01/01/09 $25.00 09 DAYS > > 17921 > > NW 79 CT MIAMI FL 33015 > > 2 7461-002 M Y Y ESPERANZA DIAZ 12 $111.25 01/01/09 $25.00 09 DAYS > > 7461 NW 175 ST. MIAMI FL 33015 > > 3 7461-003 M Y Y BERNARDO ARAUJO 12 $111.25 01/01/09 $25.00 09 DAYS > > 7461 NW 176 TERR MIAMI FL 33015 > > 4 7462-004 M Y Y JUAN AMAT 12 $111.25 01/01/09 $25.00 09 DAYS 7462 NW > > 175 ST. MIAMI FL 33015 > > > I have attached a sample file for illustrations. On sheet 1 is the > > original file, and on sheet 2 is how I need to file to be. Notice > > that you will be able to identify the first row of each record because > > it contains a numerical indicator starting a 1. In other words. 1 > > space, 2 space, 3 space, 4 space, etc, etc. > > > I am sending a file with the name extract-address.xls > > > Thank you in advance for all the help > > > -- > > > ---------------------------------------------------------------------------------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > Your Sincerely > Sanjoy Nath > Engineer > EOL Gurgaon > EOL/M/NZ/Engg.Dept.(Haryana Division) > > We prepare custom tools (Softwares) to prepare Autocad Drawings > Of the Engineering Components.Some Of Our Clients Provide the > Design Calculation Steps And Sample Drawings (Templates for Eg the > Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, > Layouting, General Engineering Components , Mechanical Engineering > Components, > Civil/Structural Engineering Components,Architectural Components) to follow > and to meet their standards and specifications.The Tools we develop are > entirely customised and specific for clients own requirements and > they are not re distributed to others. > > Let me be precise regarding our job profile and what we can do for you > Suppose you have to develop any design component repeatedly for different > projects > Only Some of its parameters are changing and you need the drawing for that > component. > you cannot prepare the block for that.Since even in the custom Block in > Autocad you > cannot controll all the parameters automatically and very few users in > Autocad can follow > the technicalities to handle the customisable blocks in Autocad. > On the Other hand , customisable blocks cannot decide the dimensions by > themselves nor can > compute the design calculations.But And it takes a long time to develop the > drawings. > Moreover if there is any revision in the General Arrangement drawings or > Facilities, > the entire things need to change and you have to start from the scratch > again and > draftsman forget to change some of the dimensions or the BOQ values in the > tables > attached to the drawings.These things are ridiculous to your clients. > We can understand these issues since we are in the design/Detailing and > drafting industry > for last 10 years and have worked for more than 6 companies(Directly as > employee or in parttime) > in 3 domains > (Piping,Architecture and Structural) > And now we have attained the expertise to develop the dxf files from > Excel/EXE Applications. > We can develop and provide the tools (EXE tools or Excel Files as you need > and as much you ask for) > to develop these drawings automatically. > > Suppose you want to develop the drawings of doors/Panels with some given > features many/some of > which will change every time from task to task or from revision to revision > or from project to project. > You have to revise the drawings and your draftsman/detailer will take 30 > minutes to 1 hour to revise each of > these several components.We can save this valuable time for you through the > tools. > Moreover many a time it happens that you have to prepare the scaled drawings > from the data in STAAD pro > and you have to type the utilisation ratios and reactions beside the members > including the sizes also. > Have you ever calculated how much time you spend on that and how much > errorprone are these ?????? > We can help you in these matters also. > We can extract the data in tables/Dimensions in the Autocad Drawing to Excel > (With Automations)such that you can prepare the > BOQs easily.Suppose you have a drawing and the dimensions of some feature in > a certain layer.We can provide > tools to you which will read the data from your dimensions in specific layer > and will type them > in the excel format.And can prepare the drawings of some other feature from > the extracted dimensions. > > We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , > Excel Also which are applicable for > MIS purposes and the custom checking tools for word processing > industries/Quality control departments. > We have given you the examples with CAD and Excel Only.But we have expertise > in STAAD Pro ,TEKLA > PDF technologies also.We work in the digitisation works also.- Hide quoted > text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
