Hi, hopefully someone will be able to help solve this conundrum for me?
I have a list of 1500 street addresses (worksheet ‘Phase1’ cells A1:A1500) within an excel template file (prices.xltx)
I need to generate 1500 separate .xls files based off the excel template, one for each street address (using the street addresses as the individual filenames), and each one needs a particular cell (B3 on worksheet ‘Schedule’) populated with the relevant street address.
Sorry if this one has been posed before in one guise or another, but it’s not the easiest query to search on and i was getting nowhere. Also, I’m not sure if the.xltx template throws a spanner in the works?
Many thanks!
I have a list of 1500 street addresses (worksheet ‘Phase1’ cells A1:A1500) within an excel template file (prices.xltx)
I need to generate 1500 separate .xls files based off the excel template, one for each street address (using the street addresses as the individual filenames), and each one needs a particular cell (B3 on worksheet ‘Schedule’) populated with the relevant street address.
Sorry if this one has been posed before in one guise or another, but it’s not the easiest query to search on and i was getting nowhere. Also, I’m not sure if the.xltx template throws a spanner in the works?
Many thanks!