VBA help needed

$10-30 CAD

Completed

Posted

over 6 years ago

$10-30 CAD

Paid on delivery

Need help with writing a short VBA query that would allow slicers to filter data by certain information from my table. I have 10 different columns (B-K) representing different industries. Against each project (lines 1-10) I have entered 1 in the column(s) that represent industries applicable to that particular project. What I am trying to do is create a chart using a pivot table from the main data file. I have then added slicers and I would like the slicers to act as "filters" - every time I select an item on the list, they would show everything that is marked with "1" on that particular column. (ie. project line 3 marks 5 x 1's - one in each of columns B, D and E. I would like the slicer to show project B in the results of the filter if I select only column B, or D, or E).

Excel

Visual Basic

Project ID: 16013254

About the project

7 proposals

Remote project

Active 6 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:

@osmemon

I have more than 10 years of experience in Excel and VBa with 100% client satisfaction history. See my profile for client reviews about me. I ll place slicer for your data sorting and filteration

$30 CAD in 1 day

4.9

(31 reviews)

5.5

7 freelancers are bidding on average $86 CAD for this job

@schoudhary1553

Greeting, I have understood your VBA task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Visual Basic

$100 CAD in 1 day

4.9

(214 reviews)

7.2

@avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Aman

$111 CAD in 1 day

4.9

(148 reviews)

6.4

@usmanhassan123

msc software engineer

$100 CAD in 1 day

4.8

(16 reviews)

4.8

@periyannas

Hi, Please share more on the requirement. Share the file you have, explain more clearly. Thank you. Regards

$66 CAD in 1 day

5.0

(3 reviews)

2.6

@sjDavidson

HI, I've worked with Excel for twenty years including VBA and macros so I should be able to help you. From what you have described I think I understand, though I might need a little more clarification to get it right. Stephen

$30 CAD in 3 days