Hi all,
Thanks again for your help with the getting numbers from a column issue I had earlier.
Now the next problem(s)
I want to run a macro that opens the newest file in a directory, extract some data from it and save this in a new file with a name that will include some data within the file...
Hi all,
I have a spreadsheet which generates a column 5000 rows high, all the numbers in the column are 0, except 8 which are a positive numbers, these numbers could be anywhere within the column.
I need a way to extract these numbers into a table on another tab, then do it again on the next...