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

Fertiggestellt Veröffentlicht vor 5 Jahren Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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

Datenverarbeitung Excel Softwarearchitektur Visual Basic Visual Basic für Apps

Projekt-ID: #18553105

Über das Projekt

11 Vorschläge Remote Projekt Aktiv vor 5 Jahren

Vergeben an:

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 Mehr

$15 CAD in 1 Tag
(28 Bewertungen)
4.2

11 Freelancer bieten im Durchschnitt $35 für diesen Job

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 Mehr

$50 CAD in 1 Tag
(182 Bewertungen)
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 in 2 Tagen
(196 Bewertungen)
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 ( Mehr

$25 CAD in 1 Tag
(261 Bewertungen)
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 Mehr

$66 CAD in 1 Tag
(119 Bewertungen)
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 Mehr

$40 CAD in 1 Tag
(98 Bewertungen)
6.2
himani50

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

$55 CAD in 2 Tagen
(0 Bewertungen)
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 Tagen
(0 Bewertungen)
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 Mehr

$10 CAD in 1 Tag
(1 Bewertung)
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 Mehr

$10 CAD in 1 Tag
(0 Bewertungen)
0.0