smashclash
Board Regular
- Joined
- Nov 24, 2003
- Messages
- 126
- Office Version
- 365
- Platform
- Windows
Not sure how to title this thread so let me explain what I'm trying to do. Basically I have several worksheets that are setup identically. I want to take all the data from each one and put it on a single worksheet (via link so it changes as the data from the worksheets are changed) but stack them.
Example: I create a new worksheet called Summary. The other worksheets in the workbook are called: Red, Blue, Green. Each of those have a unique value in cell B2 which is what I want to capture on the Summary worksheet. In my Summary worksheet I want cell B2 to link to Red B2. In Summary worksheet I want B3 to link to Blue B2. In Summary worksheet I want B4 to link to Green B2.
Rather than manually map these I'm hoping there's a faster way to do it.
Example: I create a new worksheet called Summary. The other worksheets in the workbook are called: Red, Blue, Green. Each of those have a unique value in cell B2 which is what I want to capture on the Summary worksheet. In my Summary worksheet I want cell B2 to link to Red B2. In Summary worksheet I want B3 to link to Blue B2. In Summary worksheet I want B4 to link to Green B2.
Rather than manually map these I'm hoping there's a faster way to do it.