Need help on writing VBA code to get results from the dataset: creating pivot table > copy filtered data to a worksheet >

Completed Posted 5 years ago Paid on delivery
Completed 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.

Data Processing Excel Software Architecture Visual Basic Visual Basic for Apps

Project ID: #18553105

About the project

12 proposals Remote project Active 5 years ago

Awarded to:

egafiori

My name is Esteban, I'm Industrial Engineer and Excel / VBA Expert. I'm new freelance, You can see some of my experiences in my profile. I can solve this problem as well as help you in economic analysis and evaluati More

$15 CAD in 1 day
(16 Reviews)
3.2

12 freelancers are bidding on average $34 for this job

ksriniravi

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

$25 CAD in 1 day
(190 Reviews)
6.8
rohitpithisaria

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

$66 CAD in 1 day
(118 Reviews)
6.6
periyannas

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.

$60 CAD in 2 days
(111 Reviews)
6.3
macroPOL

Hello, I am Excel and VBA expert. Could you send sample file? Everything is possible in VBA macro. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star More

$40 CAD in 1 day
(98 Reviews)
6.1
sloker18

I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I can write the marco to create and copy pivot table automatically as More

$50 CAD in 1 day
(91 Reviews)
6.0
alexanderrubtsov

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

$25 CAD in 1 day
(21 Reviews)
4.6
himani50

Experienced developer, I can write VBA code to get results from the data set efficiently

$55 CAD in 2 days
(0 Reviews)
0.0
Ayush23199331

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.

$20 CAD in 5 days
(0 Reviews)
0.0
wfy1961924

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

$10 CAD in 1 day
(0 Reviews)
0.0
vakhod

Hello, I already SOLVED YOUR TASK. You can see and download it from my Profile. There is only one file. I did not use any macros, solved it using only formulas. Only change you will need will be to copy down t More

$10 CAD in 1 day
(0 Reviews)
0.0