I am trying to write something that will consolidate about 5 sheets into 1 final sheet. The hitch is, there will be a different number of lines in each sheet each time. And, I don't want to copy the first 6 lines of each sheet (headers).
Anybody that can help me with this? I'd like to just put on page 6 the address for the cells in the other sheets, but I'm not sure if that'll work. Sounds like a macro is in order, but I'm open to suggestion. Example. Sheet 1 has 30 lines (including 6 lines of headers) Sheet 2 has 40 lines (including 6 lines of headers) Sheet 3 has 10 lines (including 6 lines of headers) Sheet 4 has 15 lines (including 6 lines of headers) Sheet 5 has 80 lines (including 6 lines of headers) The remaning lines in all the sheets will be blank. I would like to have Sheet 6 be... Sheet 1 lines 7-30 followed by (24 lines) Sheet 2 lines 7-40 followed by (34 lines) Sheet 3 lines 7-10 followed by (4 lines) Sheet 4 lines 7-15 followed by (9 lines) Sheet 5 lines 7-80 (74 lines) Sheet 6 would have 1 line of header (which would be unique to that sheet, which I can enter manually and have the rest of the process start on line 2, or copy from sheet 5) followed by 145 lines of data. I'm new to thisw stuff, but you guys have always been very helpful to me before (and you make it look so easy....) If more explanation is needed you can send questions through my gmail acc't to scasko. Thanks, Steve -- ---------------------------------------------------------------------------------- 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