riverain
New Member
- Joined
- Jan 10, 2024
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
I'm facing some challenges with my daily tasks and would greatly appreciate assistance.
Let me explain the situation. I have two spreadsheets within one Excel file. In Sheet 1, column A contains the existing customer codes, while columns B and C hold models and prices, respectively. On Sheet 2, I have a list of new customer codes. I'm wondering how to utilise VBA code to generate a new spreadsheet that catalogues these new customer codes along with the corresponding models and prices retrieved from Sheet 1, assigned to the existing customer codes.
Any guidance or support regarding this matter would be immensely helpful.
I'm facing some challenges with my daily tasks and would greatly appreciate assistance.
Let me explain the situation. I have two spreadsheets within one Excel file. In Sheet 1, column A contains the existing customer codes, while columns B and C hold models and prices, respectively. On Sheet 2, I have a list of new customer codes. I'm wondering how to utilise VBA code to generate a new spreadsheet that catalogues these new customer codes along with the corresponding models and prices retrieved from Sheet 1, assigned to the existing customer codes.
Any guidance or support regarding this matter would be immensely helpful.