HiProject.xlsx
I've been trying to solve this one for a while without any luck.
File has different sheets renamed with date range by week ( this cells are manually copy & paste), one that's call year to date ( this sheets is the one that needs to formula to be able to search all the other sheets based on the ID#, when found copy cell on B1 column and B2, since this two numbers belong to A1 / ID#.
A B
ID %-CPH
AA8 73.5
AA8 275.6
Some ID#'s only have % and some both.
A B
C99 75.20
Z95 80.50
Z95 310.0
When the numbers get copy and paste are all random and not always end up in the same cell for the weekly ones, the YTD will always stay in the same cell.
I'm not even sure if this can be possible. Thanks in advance for your help
Bookmarks