Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
can you send me your spreadsheet
i could set up the pivot table for you
Okay, stupid question but how can I attached a file? It will only let me attach an image. Pasting in the data doesn't keep the data in correct columns.
just use that image button
but click the excel file instead
i have an alternative if that doesnt work
It tells me wrong image type and won't attach it.
after uploading to them
they give you ID#
paste that number here
give me a minute to check that out
i see why it wouldnt attach
they don't like macro files
so we gonna use the raw data tab to create the pivot table from?
and what information do you want in the table
like if employee id goes down left column
and job code across the top?
That would be fine.
let me see what I can do
one more question while I am working on this
your are looking to not have the name displayed if they contain
TCHSUB OR SRVSUB
so if they have
anything including those 2 we do not want it displayed
did you get my last message?
I don't want you to think I left you
let me know when you are back
Sorry about that. I got caught in a meeting with the superintendent.
Yes, with your assumption.
so in the case of
they have that category
so their name should not be displayed
lemme see what I can doo
this may take a while
ok, i think this will require some VBA
since this is already an XLSM file
that shouldn't be too dificult
I will hopefully have something for you by end of day
You will be contacted when I post my results
Thank you for the update.
ok its done
click the link to download and test
the macro runs when you open the workbook and enable content
it will remove all the names from the pivot sheet that have the 2 values you didn't want to see
Let me know if you have any questions, problems, or concerns
WHEN YOU GET A CHANCE PLEASE REMEMBER TO RATE MY SERVICE
SO I GET REIMBURSED FOR MY TIME
YOU DO SO WITH THE SMILEYS BENEATH THIS CHAT