Jayfunk
02-18-2014, 04:32 AM
Hello Guys,
I am currently working on a project at work to automate a report from data, i can do every page fine, some parts have one page and some parts have more than one page.
My problem is simple on all singe pages i have one green line above the footer on the cells above it to match what the old report had which is what i am going for. this green line nicely started the footer
Now on the parts with more than one page i can do this manually but i would like it automated the problem lies with finding the cell above the footer on each page.
does anyone one know how to do this or another way of doing the same thing
Many thanks
Jason
I am currently working on a project at work to automate a report from data, i can do every page fine, some parts have one page and some parts have more than one page.
My problem is simple on all singe pages i have one green line above the footer on the cells above it to match what the old report had which is what i am going for. this green line nicely started the footer
Now on the parts with more than one page i can do this manually but i would like it automated the problem lies with finding the cell above the footer on each page.
does anyone one know how to do this or another way of doing the same thing
Many thanks
Jason