Re: $$Excel-Macros$$ Problem extracting data from multiple columns

2011-09-08 Thread Andy McGooner
Why cant i attach to this On Sep 5, 3:04 pm, "dguillett1" wrote: > Post a file > > > > -Original Message- > From: Andy McGooner > Sent: Monday, September 05, 2011 7:56 AM > To: MS EXCEL AND VBA MACROS > > Cc: amcni...@jaguarlandrover.com > Subject: $$Excel-Macros$$ Problemextractingd

Re: $$Excel-Macros$$ Problem extracting data from multiple columns

2011-09-05 Thread dguillett1
Post a file -Original Message- From: Andy McGooner Sent: Monday, September 05, 2011 7:56 AM To: MS EXCEL AND VBA MACROS Cc: amcni...@jaguarlandrover.com Subject: $$Excel-Macros$$ Problem extracting data from multiple columns Hi All, I have a spreadsheet that can have up to 5 data

$$Excel-Macros$$ Problem extracting data from multiple columns

2011-09-05 Thread Andy McGooner
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 th