Thank you! That worked exactly how i wanted it to
Just wondering if there was a way to create a macro which could take a column of data and plot it and then move on to the next column and do the same?
Each sheet has a different number of lines so i know i would have to somehow make the range from the second line to the last line. But i'm unsure as to how to loop through columns as well as lines.
My current sheet has 9 columns, the first is just samples and the 2nd to 9th is the data i need to put into separate line charts. (So one graph for column 2, one graph for column 3 etc)
Any help would be greatly appreciated.
Brand new to VBA and very lost on if this is possible.
I have a CSV file with over the limit of how many rows excel can handle. I know that in my data there are many rows that have no information in them at all.
I was wondering if it was possible to create a macro which can read the file and find the rows which have the data as there are only around 200, 000 rows with data, instead of reading in the whole file with over 1.2 million rows.
So for example if column B, C and D are 0 then do not read the row into the worksheet.
The first row is the column headings which i would like to keep, but from then on i would like it to find the rows which match the criteria.
Is this possible?