geno32080
Board Regular
- Joined
- Jan 23, 2020
- Messages
- 107
- Office Version
- 2013
- Platform
- Windows
Can a Macro be used to associate Multiple Cells with One Cell on the same sheet and then be copied and pasted to another sheet? The association would be B4 = C4, C5, C7, C8 and C9.
If I select cell B4, on sheet 5, that cell and the associated cells get copied from sheet 5 and pasted to sheet 3 starting with the B4 pasted to cell B15, and then C4 thru C9 pasted to cell D15 thru D19?
I don't know if that's even possible. I've tried Data validation, but that was a dead end. I'm up for any suggestions. Thank you.
If I select cell B4, on sheet 5, that cell and the associated cells get copied from sheet 5 and pasted to sheet 3 starting with the B4 pasted to cell B15, and then C4 thru C9 pasted to cell D15 thru D19?
I don't know if that's even possible. I've tried Data validation, but that was a dead end. I'm up for any suggestions. Thank you.