svendiamond
Well-known Member
- Joined
- Jun 13, 2014
- Messages
- 1,504
- Office Version
- 365
- Platform
- Windows

The Job Function/Area/Department columns in this report all come out AFTER the list of names for each. I.e. Raymond G worked in "SUPPORT" -- Steve P worked in CRTVLOAD -- Matt S and Steve P worked in RCVCRTV.
I want to (automatically) FILL UP the Department/Area/Job Function columns so that they line up with each name. AKA I would manually have to fill up "SUPPORT" from cell C4 into C3 and C2. Then I would fill up "CRTVLOAD" from C8 into C7, C6 and C5. Etc etc etc Down this list which is about 2000 rows long. Any ideas as to how I might automatically fill all of them up? Maybe if I make the #N/A's into Blanks then copy values only into a new sheet... then FILL UP all blanks? I don't know... any help would be appreciated.
Last edited: