katiepie
New member
Hello,
I have created a pivot table that we send to our bank for payments. As of right now there is still some manual manipulation we have to do. The report is a re-freshable report that pulls from our database and then we copy and hard paste the pivot table into a new excel sheet, manipulate what we need and then upload it to the bank. I would like to take out some of the manual work if possible. In the first example (attached example check sheet 1) is how it comes in. The second example is what I would like it to look like. I was wondering if it is possible to have this happen automatically in the pivot table.
Column A needs to be filled out all the way down with every line that has a TRANNO number. Column B needs to be filled out on every single line. These are my first two issues.
Does anyone know if there is a way to do this?
Thanks,
I have created a pivot table that we send to our bank for payments. As of right now there is still some manual manipulation we have to do. The report is a re-freshable report that pulls from our database and then we copy and hard paste the pivot table into a new excel sheet, manipulate what we need and then upload it to the bank. I would like to take out some of the manual work if possible. In the first example (attached example check sheet 1) is how it comes in. The second example is what I would like it to look like. I was wondering if it is possible to have this happen automatically in the pivot table.
Column A needs to be filled out all the way down with every line that has a TRANNO number. Column B needs to be filled out on every single line. These are my first two issues.
Does anyone know if there is a way to do this?
Thanks,