Hi,
I have a problem.....
firstly, i have 5 columns of data of which 2 are relevant, column A and B, populated by 20 rows, but it could be more or less.
Column a is an account number (alphanumeric like V0002) and column b has its corresponding email address, like accountv2@accountv2.co.uk.
The first problem is, how do you do a macro that does file save for individual account numbers for each spreadsheet. So it will create a "file save" V0002.xls as 1 spreadsheet, file save V00003.xls as another spreadsheet etc, so it will create 20 individual spreadsheets, but of course if there is 30 rows of data, it will need to create 30 different named spreadsheets.
Jay
PS this will be done on a weekly routine, so it must overwrite the data, and not ask the question that the file already exists. Also, the directory for all the files can be in the same directory.
I have a problem.....
firstly, i have 5 columns of data of which 2 are relevant, column A and B, populated by 20 rows, but it could be more or less.
Column a is an account number (alphanumeric like V0002) and column b has its corresponding email address, like accountv2@accountv2.co.uk.
The first problem is, how do you do a macro that does file save for individual account numbers for each spreadsheet. So it will create a "file save" V0002.xls as 1 spreadsheet, file save V00003.xls as another spreadsheet etc, so it will create 20 individual spreadsheets, but of course if there is 30 rows of data, it will need to create 30 different named spreadsheets.
Jay
PS this will be done on a weekly routine, so it must overwrite the data, and not ask the question that the file already exists. Also, the directory for all the files can be in the same directory.