|
I'm trying to generate a number of reports for our customers at work. Right now I have a list of 81 customers. I also have a workbook which has 81 sheets that each have a blank sales template in them. What I need to do is place one name from the list of customers into cell A1 of each of the 81 sheets which will then use a VLookup to generate the sales data in each sheet. At the end I will then have a workbook that has an individual sheet for each customer. As a bonus it would also be good if it could also rename the sheet to whatever the customers name is. I'm pretty bad at macros so I'm not too sure how to automate this process rather than doing it individually but I dont think its too hard to write up.
|
#
¿
Mar 13, 2012 06:45
|
|
|
|
| # ¿ May 7, 2024 18:30 |
|
|
The Vlookup stuff is already in there. Thanks for that. I'll give it a go now.
|
|
#
¿
Mar 14, 2012 01:12
|
|