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 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 > -- 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. -- ---------------------------------------------------------------------------------- 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
