Need help on writing VBA code to get results from the dataset: creating pivot table > copy filtered data to a worksheet >
$10-30 CAD
Paid on delivery
"Data set" worksheet contains the data sample. I need to get the "Result" worksheet from the dataset. I've added sample calculation to get "Result" worksheet. Since this is repetitive work and the dataset may contain hundreds of data, I was wondering if there any way to write VBA code to get "Result" worksheet from the "Data set".
What I did manually is: creating pivot table > copy filtered data to new worksheets > processing new worksheets > Results from processed worksheets.
Project ID: #18553105
About the project
12 freelancers are bidding on average $34 for this job
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can write a macro to automatically generate Results table based on data set ( More
Hello I am an excel expert and have complete more than 100 projects in excel. I will send you a few samples of my past work for your kind perusal if required. I have read the job posting and understood the requi More
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
Hello. I've examined your sample data and what I don't understand is where the C1_Process tab gets data from. It's not calculated and not copied from the pivot table. Could you explain this? Anyway , if you need More
Recently I joined freelancer & looking for new projects. I work in Reliance Industries Limited (Supply chain) in India and have developed MS Excel & Data anlytics skill in past 3 and half years.
Hi, this is simple. I can write the VBA code right now. Once you choose me I will send you the excel with VBA code immediately. Thanks Hi, I have completed the VBA code and can send to you immediately. Please contac More