Dear Excel Guru,
Pl help
How to do page break according to conditions like ecode, place in excel
after sorting out in Salary
Thx
Jitender
On 24 February 2011 19:16, Jitender kumar wrote:
> Dear Excel Guru/Ashish,
>
> Thanks for your valuable solution.But the problem is still here, Because
Dear Excel Guru/Ashish/Dilip
Thanks for your valuable solution.But the problem is still here, Because I
want to print it according to MRP & Dcode wise on different sheet of
paper(Pivot table can doit), I know page break works but doing page break on
every dcode and MRP is very tough task wwhen da
Hi Jitender,
I think you are 90% done.
After Pivot table is done, you should copy -> paste the data on its
location itself and select the MRP column, F5, Select Blanks, = sign,
up arrow, Ctrl + Enter.
The above steps can also be automated where after the pivot, all the
steps can be achieved throu
Dear Excel Guru Please help
Regards'
Jitender
On 24 February 2011 19:16, Jitender kumar wrote:
> Dear Excel Guru/Ashish,
>
> Thanks for your valuable solution.But the problem is still here, Because I
> want to print it according to MRP & Dcode wise on different sheet of paper,
> I know page br
Dear Excel Guru/Ashish,
Thanks for your valuable solution.But the problem is still here, Because I
want to print it according to MRP & Dcode wise on different sheet of paper,
I know page break works but doing page break on every dcode and MRP is very
tough task wwhen data is too large.Pivot table
