BeerBeer101
New Member
- Joined
- Dec 29, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
alright, I've never done this one - but I'm sure there's an easy formula versus thousands of the same one.
Source sheet: updates weekly - it's colums A-F wide - data after headers starts row 3 and is anywhere from 4,000 to 5500 rows long
target sheet - starts A2
so there's is there a formula for A2 to bring the source data into the target sheet per cell (as opposed to =sourcesheeta2 copied right and down for let's say 30,000 formulas?
thanks - this group is always amazing!
Source sheet: updates weekly - it's colums A-F wide - data after headers starts row 3 and is anywhere from 4,000 to 5500 rows long
target sheet - starts A2
so there's is there a formula for A2 to bring the source data into the target sheet per cell (as opposed to =sourcesheeta2 copied right and down for let's say 30,000 formulas?
thanks - this group is always amazing!