Hi, I would suggest you to prepare a sample spreadsheet and forward that to Group as an attachment.
For bringing in the large data, you can use Data -> Import External Data. MS Query (SQL) will help you to modify the import. For validation, you can use Data-> Validation with the use of Offset and named ranges. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 6/13/10, J D <springer...@gmail.com> wrote: > I am an estimator with a concrete company. I build new spreadsheets > for every bid. A lot of this is repetitious, same basic line item > again and again, just the square footage might change. For a better > idea of what it looks like: > > Furnish and install ~7,010 s.f. of 4" concrete wearing slab for new 2' > x 3' Hanover Pavers and for new stone pavers. Concrete to be DC Class > E. Concrete to be reinforced with 6 x 6, 6/6 wwf per detail. Where > wearing slab meets the building it is to have an 8" thickened > edge. > > $26,920.00 > > 6 x 6,6/6 7010 40 1 75.25 > 180 17.36 3117.6 > conc 7010 0.33 2313.3 85.67777778 > 90 > 145 13050 > conc 380 0.33 0.83 104.082 3.854888889 4 > 145 580 > 1/2" Cork 170 10 17 20 > 7.42 148.4 > 1/2" x 8" 380 10 38 38 > 15.99 607.62 > 2 mil poly 7010 3930 1.783715013 > 2 81.68 163.36 > labor 7010 1500 4.673333333 > 5 > 1850 9250 > > > 26916.98 > > Cut and paste didn't work so well here, but hopefully you get the > idea. > > I like to type a pretty detailed description and then I do all my > calculating below for various components, sum it up with some and then > round it up to the nearest $10 next to the line item. Once this is > done, I e-mail it to the person who prepares the formal copy. I very > often use save as and call it pricing, wipe out the calculations and e- > mail an rough draft. > > Now to the question, I want to compile a large list of these in a > spread sheet / data base and bring them into the spread sheet I am > working on. I know I could cut and paste, but I am looking for a way > to use a drop down list and bring the entire assembly in with the > calculations. I can handle the calculations but have not figured out > how to bring the whole thing in. > > Would like to use a code system or brief description as cues in the > drop down, I can work that out. > > Thanks > > -- > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.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. 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
