G
Guest
Hi,
I have a spreadsheet which general information, that I need to cut and paste
into another workbook and save as a delimited txt file.
The current spreadsheet I am working on contains 8 columns. In cell D, I
have a series of numbers that Cells E, F, G and H link to. - Im not really
interested in Columns A-C.
Cell D may contain anything from 1 row to 100+ rows of the same number. I
need to filter on a particular number (if I put the filter application on it
shows me each unique number) and once filtered I need to copy and past the
contents of Cells D, E, F, G and H to another workbook and save this as a
"Text (tab delimited) (*txt)".
To do this manually is a right pain in the rear as the spreadsheet is
approx. 11652 rows, which is ever growing.
I wanted to know if there is a way I can write/create a macro for this
spreadsheet, so we can run it on a weekly basis if any more information gets
added.
Your help would be much appreciated!
Thanks
T-bone!
I have a spreadsheet which general information, that I need to cut and paste
into another workbook and save as a delimited txt file.
The current spreadsheet I am working on contains 8 columns. In cell D, I
have a series of numbers that Cells E, F, G and H link to. - Im not really
interested in Columns A-C.
Cell D may contain anything from 1 row to 100+ rows of the same number. I
need to filter on a particular number (if I put the filter application on it
shows me each unique number) and once filtered I need to copy and past the
contents of Cells D, E, F, G and H to another workbook and save this as a
"Text (tab delimited) (*txt)".
To do this manually is a right pain in the rear as the spreadsheet is
approx. 11652 rows, which is ever growing.
I wanted to know if there is a way I can write/create a macro for this
spreadsheet, so we can run it on a weekly basis if any more information gets
added.
Your help would be much appreciated!
Thanks
T-bone!