LFaz268710
New Member
- Joined
- Mar 3, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi,
I have a workbook that contains the details of customers booked for different trips on sheet 2
I want to copy the rows from sheet 2 to different sheets based on the location, e.g. all customers booked for Nice will copy to sheet 3, all for Mallorca will go to sheet 4 etc.
Is a VBA the only way to do this? I need to make sure it doesn't delete the data on sheet 2, but I'm struggling with the standard copy code as I can't work out how to ensure each additional sheet only pulls the particular location over. Do I have to have a VBA module for each location?
Many thanks,
I have a workbook that contains the details of customers booked for different trips on sheet 2
I want to copy the rows from sheet 2 to different sheets based on the location, e.g. all customers booked for Nice will copy to sheet 3, all for Mallorca will go to sheet 4 etc.
Is a VBA the only way to do this? I need to make sure it doesn't delete the data on sheet 2, but I'm struggling with the standard copy code as I can't work out how to ensure each additional sheet only pulls the particular location over. Do I have to have a VBA module for each location?
Many thanks,