Dear expertise
I have vba code to create pivot from rawdata of DIS_Q1-Q4 into newsheet Amortization, i want make change on code to take dates from column I till end of column CRM Becoz the date range extend by month wise report. so starting date from column header I till CRM header.
let me know any tricks or possbile at Calcualte field options too
Please Login or Register to view this content.
Please find the attachment
Any of our VBA experts want to tackle this 1 please?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Any experts help on this?
I will push this again for you
if im understanding what you are wanting....xlsum from first month until CRM
then this code could work
essentially loop every header from 9 until CRM adding datafield
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Where did you get this code from in the first place ??
Thanks for the assist, guys
Thanks alot Experts Voluntarily who helped across my post
which is driven me one more Last requirement!! I dont want add up all dates into datafield. I want add inputbox while run pivot intially it has to ask enter date from which entering date it has to take 10 dates towards right either it has less than 10 should not more than 10 but till end of CRM.
if you help me out with this condition more grateful to you
find the attachment
Last edited by johnmacpro; 08-23-2016 at 03:17 AM. Reason: explain
@snb
Dear sir
i found across google only and made changes according as per my requirement
Last edited by johnmacpro; 08-23-2016 at 03:16 AM. Reason: explain
Dear expert
I have changed range of pivotfield date column from 16 to j and also changed "FT" but it doesnt works for me.
Please Login or Register to view this content.
Dear expert
I have changed range of pivotfield date column from 16 to j and also changed "FT" but it doesnt works for me.
please find the attachment some extent some of range of field in datesPlease Login or Register to view this content.
Last edited by johnmacpro; 08-24-2016 at 03:28 AM. Reason: explain
Change counter equal 17 and then subsequently start loop on 17 instead of 16
also change the colfield to extract the value in the same format as the header
Please Login or Register to view this content.
Now i replace as j = ws1.Range("1:1").Find("ST").Column from is j = ws1.Range("1:1").Find("FT").Column its not take date into datafield
as well one more requirement i want select Q1-13 only in report filter add this condition in code.
Please Login or Register to view this content.
Last edited by johnmacpro; 08-26-2016 at 02:26 AM. Reason: addup
you didnt update
this needs to be 17Please Login or Register to view this content.
sir this one i want select Q1-13 only in report filter add this condition in code.
you seem to sort of know how to amend code but it seems you have trouble with syntax
here is some reading material for you
http://www.thespreadsheetguru.com/bl...l-pivot-tables
http://codevba.com/excel/PivotTable.htm
http://www.databison.com/how-to-read...ble-using-vba/
Thanks got it!! solved sir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks