Đang Thực Hiện

Excel Pivot table macro

Generic replies will be ignored. You must specifically address the problem and prove that you can solve it.

Need someone to quickly code to select a range of values in a pivot table page field.

That range would be a From and To date for example.

There is one date in my pivot table. I want to select from Jan 1st 2006 to

July 12th 2006 for example.

I want the user to enter it as a range and not have to click any set of multiple dates.

Should be able to change selection criteria for a page field or one of the item fields.

Must provide working code in the attached spreadsheet.

I followed the example in Mr Excels book on selecting page fields on a pivot table outside the pivot table using a macro but the From and To requirement I have is not to be found.

[img][url removed, login to view][/img]

Here is the sample excel spreadsheet where I have a pivot table defined

[url removed, login to view]

Kỹ năng: Màn hình Windows

Xem thêm: you ver, selection problem, prove excel, generic excel, address selection criteria, pivot table macro dates, pivot macro, n excel, ver , table, selection criteria, pivot table excel, outside, macro, macro excel, flickr, excel pivot, excel pivot table, img table, macro pivot, table jpg, multiple excel, range macro excel, excel date selection, macro spreadsheet

Về Bên Thuê:
( 17 nhận xét ) Hampstead Heath, United Kingdom

Mã Dự Án: #56077

Đã trao cho:

amanullahs

Hi I can do this project. I have 6 years of VBA experience across various versions. I think it is straight forward. Awaiting your reply to start. Thanks Aman

$65 USD trong 1 ngày
(1 Đánh Giá)
2.2

3 freelancer đang chào giá trung bình $67 cho công việc này

danireh

HI, Dear you have mentioned the date interval but you didnt mention, for which column of dates you need the range in you data sheet you have three columns of dates i can provide you a macro which will first select a co Thêm

$100 USD trong 1 ngày
(0 Đánh Giá)
0.0
dicadio

sorry in first my bid , please check your PM

$35 USD trong 1 ngày
(0 Đánh Giá)
0.0