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

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

"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.

Procesamiento de datos Excel Arquitectura de software Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #18553105

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 Más

$15 CAD en 1 día
(16 comentarios)
3.2

12 freelancers están ofertando un promedio de $34 por este trabajo

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 ( Más

$25 CAD en 1 día
(190 comentarios)
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 Más

$66 CAD en 1 día
(118 comentarios)
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 en 2 días
(111 comentarios)
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 Más

$40 CAD en 1 día
(98 comentarios)
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 Más

$50 CAD en 1 día
(91 comentarios)
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 Más

$25 CAD en 1 día
(21 comentarios)
4.6
himani50

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

$55 CAD en 2 días
(0 comentarios)
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 en 5 días
(0 comentarios)
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 Más

$10 CAD en 1 día
(0 comentarios)
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 Más

$10 CAD en 1 día
(0 comentarios)
0.0