Search results

in a pivot table i would like to capture the subtotal of a person based on if the the slicer name is the same as the column name if the slicer name = column name then retrieve that subtotal of that person.....how can I go about achieving this in vba in a particular cell? thanks.

I need to set up a query that gives me a list of people if it finds a certain keyword in a certain field. so if the keyword "kick" appears in the text, I would need it flagged. If the keyword happens to appear I just need the person ID number not the keyword. What would be the logic to pull...

Ok..ill start with that...with that said...how would I go about printing out a fresh "batch" of DP#####s on the labels...for example I printed out a set of labels ranging from DP00001 to DP00100(or whatever equals two pages worth)...now I come back later to print the next set DP00101 to...

thanks for the reply I would like the for DP00001 to increment...we are using labels to identify PCs starting with 00001 then 00002 and 3,4, up to DP99999....now it wont be that many PCs so maybe fill a few print pages.... the numbers are not in a table....

VBA newbie! Using VBA how would I go about creating a macro that would create a label report (using L7416 10-L for example) and autofill in data that would increment from DP00001, DP00002 and so on... thanks