mjacquot82
New Member
- Joined
- Jan 2, 2018
- Messages
- 34
Good day everyone,
Trying to have a button ( or multiple if needed ) that when clicked will be able to copy A2:F6 ( for example ) and paste in different range. But i also need it to be able to then select the info associated to the next name in column A and copy paste that one. The tricky part is that the # of empty rows between the names in column A will always be different. Where the information will be paste will always be the same, right now on my sheet its G21.
Not sure if I am making what i am trying to achieve clear here. Please any help would be appreciated.
A B C D E F
Trying to have a button ( or multiple if needed ) that when clicked will be able to copy A2:F6 ( for example ) and paste in different range. But i also need it to be able to then select the info associated to the next name in column A and copy paste that one. The tricky part is that the # of empty rows between the names in column A will always be different. Where the information will be paste will always be the same, right now on my sheet its G21.
Not sure if I am making what i am trying to achieve clear here. Please any help would be appreciated.
A B C D E F
Name | # | Start | Amount | End | total |
Chicken Little | 24411 | 6:00:00 AM | 2 | 4:15:00 AM | 50,300 |
7:00:00 AM | 1 | ||||
8:00:00 AM | 2 | ||||
9:00:00 AM | 1 | ||||
Yogi Bear | 24412 | 11:00:00 PM | 2 | 4:15:00 AM | 54,000 |
11:00:00 PM | 2 | ||||
Snow White | 24544 | 8:00:00 PM | 5 | 8:00:00 AM | 45 220 |
9:00:00 PM | 3 |