immyjimmy
Active Member
- Joined
- May 27, 2002
- Messages
- 254
Hello, all..
I have a user input sheet which asks a user for a machine and a platform and then the number of documents for each part of the machine. Easy enough.
Once the user has populated the form, I need the data copied to the appropriate platform sheet. Cell E2 contains the platform name. I know how to copy and paste the data.
I just need to know how to tell VBA to go to the sheet named in cell E2.
Thanks in advance,
Jim
I have a user input sheet which asks a user for a machine and a platform and then the number of documents for each part of the machine. Easy enough.
Once the user has populated the form, I need the data copied to the appropriate platform sheet. Cell E2 contains the platform name. I know how to copy and paste the data.
I just need to know how to tell VBA to go to the sheet named in cell E2.
Thanks in advance,
Jim