PDA

View Full Version : Creating pivot table & adding formulas in VB



Chuck31
12-27-2007, 03:15 PM
Hi all,

I created a VB userform that allow to capture data and copy them on a spreadsheet. What I'm trying to accomplish is the following:

1) when button is pressed, a pivot table is created with the data caputerd on the spreadsheet.

Sum by name of time for each sum of task

2) Also, I need to have the number of task for each name. Kind of a counter to be able to count the name once and sum the total time.
Ex: ChuckConsultationSN1 Quote CarQuote00:00:08ChuckCreationSN1 Quote CarQuote00:00:08ChuckModificationSN1 Quote CarQuote
00:00:09


Therefore I should have 1 transaction count and for a total time of 25sec.

I don't know my 2 request are fisable from a pivot table or I need to have an excel formula in my spreadsheet.

Thanks in advance for all your help