I have some experience with VBA, but mostly editing recorded Macros or modifying other code I've found. This is an overview of what I'm trying to do, but haven't had much success.
Sheet 1 named “Work Sheet”
Sheet 2 named “Data”
Sheet 3 named “Temp”
Sheet 1 has a drop down list of 10 different companies
Sheet 2 has all the data for the companies, contact, address, etc. Column O has the company name in it.
Sheet 3 is an empty template of Sheet 2
The idea is that I want to pick a company from the drop down on Sheet 1 and copy all the data in Range A : P for that company from Sheet 2 to Sheet 3.
All the data in Sheet 2 is already organized by company, but some companies are a single row where others are 10 rows.
I know that I have to store the company from the drop down on Sheet 1 as an integer and then pass it along. And that I’ll have to use an .endup for sheet 2 to find all the rows with that particular company, but I don’t know how to do the find copy and paste work.
Any help would be awesome!
Sheet 1 named “Work Sheet”
Sheet 2 named “Data”
Sheet 3 named “Temp”
Sheet 1 has a drop down list of 10 different companies
Sheet 2 has all the data for the companies, contact, address, etc. Column O has the company name in it.
Sheet 3 is an empty template of Sheet 2
The idea is that I want to pick a company from the drop down on Sheet 1 and copy all the data in Range A : P for that company from Sheet 2 to Sheet 3.
All the data in Sheet 2 is already organized by company, but some companies are a single row where others are 10 rows.
I know that I have to store the company from the drop down on Sheet 1 as an integer and then pass it along. And that I’ll have to use an .endup for sheet 2 to find all the rows with that particular company, but I don’t know how to do the find copy and paste work.
Any help would be awesome!