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

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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

Zpracování dat Excel Softwarová architektura Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #18553105

O projektu

11 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

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 Další

$15 CAD za 1 den
(28 recenzí)
4.2

11 Freelnceři na tento projekt zveřejňují nabídky v průměru $35

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 Další

$50 CAD za 1 den
(182 Recenzí)
7.7
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 za 2 dní
(196 Recenzí)
7.1
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 ( Další

$25 CAD za 1 den
(261 Recenzí)
7.2
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 Další

$66 CAD za 1 den
(119 Recenzí)
6.6
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 Další

$40 CAD za 1 den
(98 Recenzí)
6.2
himani50

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

$55 CAD za 2 dní
(0 Recenzí)
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 za 5 dní
(0 Recenzí)
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 Další

$10 CAD za 1 den
(1 recenze)
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 Další

$10 CAD za 1 den
(0 Recenzí)
0.0