Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
I would like to be able to do the following:
I want to add 10 lines of data where column B has a unique identifier (program name). Once all of my lines of data are added, the team can click a button whcih runs a macro to go to "Sheet 2" and locate the appropriate row, copy all cells from J through AU and paste it onto the appropriate rows in Sheet 2. I have screenshots below of an example of what this would look like. Program 1 has been filled in to show the data.
I want to add 10 lines of data where column B has a unique identifier (program name). Once all of my lines of data are added, the team can click a button whcih runs a macro to go to "Sheet 2" and locate the appropriate row, copy all cells from J through AU and paste it onto the appropriate rows in Sheet 2. I have screenshots below of an example of what this would look like. Program 1 has been filled in to show the data.
