I have spreadsheets of imported data from another program, so I have no control over the initial formatting of the data. The program puts out data but does not fill in every cell if it is the same data as the cell above it. I am sorting the data several different ways, and having blank cells is throwing me way off.
I would like a macro that will go down a colum and, once it finds data, copy that data to every cell below it until it comes to another cell with existing data, then copy that new data to each cell below it etc. I would need to do this with the first 3 columns of the spreadsheet, but not further than the first three columns. I can manually put something at the bottom to let the macro know to move to the next column (or stop) pretty easily. For example, column A contains data only in rows 1, 10, 25, and 42. I would like it to copy the data from A,1 and insert it all the way down column A to row 9, then copy the data from A,10 and insert it all the way down to row 24, copy A,25 and insert it all the way down to row 41, etc. I can provide samples if necessary. Thanks, Steve sca...@aol.com -- ---------------------------------------------------------------------------------- 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 6,800 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
