Excel vba to loop though selected cells in a pivot and return the value of the cell with the parent/group name or names.

$10-30 AUD

Completed

Posted

about 4 years ago

$10-30 AUD

Paid on delivery

I need a sub in VBA to loop through selections(active) cells in a pivot table and return the cell value/name and the parent/group name or names (if more than one tier). ie. ASM_WORK --- OBJECT-1 --- --- [login to view URL] --- --- [login to view URL] BSD_WORK --- OBJECT-1 --- --- [login to view URL] --- --- [login to view URL] --- OBJECT-2 --- --- [login to view URL] --- --- [login to view URL] If i were to select the cell containing [login to view URL] under group ASM_WORK - OBJECT-1 the response would be ASM_WORK - OBJECT-1 - [login to view URL] If I were to select [login to view URL] from BSD_WORK, OBJECT-1 the response would be BSD_WORK - OBJECT-1 - [login to view URL] If I were to select all cells with a value of [login to view URL] the response would be ASM_WORK - OBJECT-1 - [login to view URL] BSD_WORK - OBJECT-1 - [login to view URL] BSD_WORK - OBJECT-2 - [login to view URL] excel file attached with sample data and my attempt to write the vba, (cannot get the parent group values/labels)

Visual Basic

Excel

Visual Basic for Apps

Project ID: 24606070

About the project

13 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards

$30 AUD in 1 day

4.9

(62 reviews)

4.6

13 freelancers are bidding on average $28 AUD for this job

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$50 AUD in 1 day

4.9

(361 reviews)

6.9

@vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

$30 AUD in 1 day

4.8

(91 reviews)

5.7

@writingapp

Hi. I have written both excel vba for Windows and Mac. Ready to write your project. Will complete within 1 day

$30 AUD in 1 day

4.8

(32 reviews)

4.9

@nelumindralal

Hello, I went thru the description Contact me and I can start it today Pls review my profile and previous projects I look forward to hearing from you Thanks regards Thushara

$50 AUD in 2 days

5.0

(25 reviews)

4.3

@maguirrer

Hello, I can help you with the project, had more than 9 years working with vba and macros, please send me a message and will start working on it immediately.

$20 AUD in 2 days

5.0

(27 reviews)

4.0

@emilianoreyes70

Hi! Please share a sample file. aI am a entrepenour and Excel/VBA/Macro ans Google Scrpit , Google Sheets expert. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script). Regards, Juan

$30 AUD in 7 days

5.0

(6 reviews)

3.4

@Barroga17

Hi I am a Certified Public Accountant. I am an expert in Excel / VBA application and can help you with your spreadsheet right now. Will deliver the project with speed and accuracy. Contact me to discuss. Regards!

$20 AUD in 1 day

5.0

(5 reviews)

1.5

@hiteshchavadaa

Hi there, How Much Work ??? Message Me Now... Start Immediately,Professional Expert, Check Review. I am interested in doing your work. i have read and understand your project description and also requirements. But I want to know more about your project, so can we discuss more? I have 5 years of experience working in this filed.i can do this task with best quality as you expected. Let's Discuss to start..message me now. Regards, Hitesh Chavada

$20 AUD in 2 days

5.0

(1 review)

1.0

@santoshchauhan30

Hi sir i am asport works data entry please select me I read your request I sure Relevant Skills and Experience Hi sir my work have like you please select me

$22 AUD in 2 days

0.0

(0 reviews)

0.0

@Mendez61187

I have full education on VBA making Microsoft Office Specialist, even though you don't hire me I will do your project, please contact me to send to you the project as soon as possible. Thanks.

$20 AUD in 2 days