Hi All, I have a spreadsheet that can have up to 5 data column entries per row asscociated to a date etc. The problem is there is multiple rows and i really want to move it all into 2 columns and keep the date associated with the data i am moving as i intend to put these in a graph.
I could do this manually but there will always be data getting added, so would like to be able to do this with a macro. I have tried using autofilters, offsets, Xlup etc but ii keepcant get it to work, i assume because there is not data in every cellof each column Anyway idoes anyone know how i can make it go across each row in the sheet extract the data and add it into a new row on another sheet whilst retaining the date associated with it. Apologies if this does not make sense, however can send an extract from the main workbook if it helps. Thanks in Advance, Andy -- ---------------------------------------------------------------------------------- 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
