I doubt this is possible, but I thought I would ask since I didn't see any posts about it.
I have a spreadsheet that is broken up by sales agents where it will have 5 to 20 rows of sales data for an agent then there will be one row with the agents name and their sub total of all the rows above for them. This gets repeated for all the agents in the report. Is there a way I could take the name from the sub total row and append it to the rows above it that have the sales data for that agent.
Hopefully i'm explaining this right.
Any help would be appreciated.