$$Excel-Macros$$ Manipulating data in rows into Columns

2011-09-09 Thread Andy McGooner
Hi All, I have a spreadsheet that contains some test results that go across multiple columns on each row. Now these results are unique to a serial number, however can be tested on multiple dates i.e. after software updates etc. Therefore need to be on seperate rows. See example below: Ser No

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...@jagua

$$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

$$Excel-Macros$$ Run-time error 1004 when no file selected

2011-08-11 Thread Andy McGooner
Hi All, I have a spreadsheet that stores data from a text file, the idea being that it opens the file dialog and i select the relevant text file. The problem is that when i do the file open and press cancel i get the folowing message: Run-time error '1004' false.xls could not be found How do i

$$Excel-Macros$$ Verifying Text Box input from excel spreadsheet prior to continuing

2010-05-17 Thread Andy McGooner
Hi All, Apologies but i am completely stumped on this one and all searches of the forums etc have turned up nothing. Anyway I am putting together a tracker that has a user interface to allow then to stick in some text, which will automatically find the corresponding values from a base data sheet a

$$Excel-Macros$$ Need help with Importing XML file

2009-10-08 Thread Andy McGooner
Hi All, Apologies if this issue has been duplicated as it took a little bit of a loopy on me when i tried to submit it last time and appeared to log me out. Anyway back to the question in hand, i am developing a macro that will allow me (or the user) to select an xml file, import it into a workb