I need a macro that will check a cell within a column, if that cell has a value I need it to pull back the column header and then individual job codes from the same column and hours worked from a separate column (multiple cells) into multiple cells on the target sheet and continue doing this until it has exhausted input in the initial column at which point I need it to move onto the next column and do the same thing.
Is this even possible and does anyone have any suggestions.
Bookmarks