Help finalise Power Query automation

£18-36 GBP / hour

Completed

Posted

almost 5 years ago

£18-36 GBP / hour

Need Excel help with a project consisting in: - 1 Master Excel file that will extract specific data from 50+ Excel files > The master file has a setting allowing me to choose which column I want to choose to extract the data from and to select the folder source. This works fine. All of the Power Queries are created BUT I need help with: - When importing/loading the data from Existing connection, it works perfect but when I refresh my setting (allowing me to select a different column on the files), then refresh the data, although my query works and refreshes the data, it adds extra columns in the master file). I made a video showing the issue: [login to view URL] I just need help solving the problem very simple for an expert but not for me. This is a first task, I have others to share once I find someone great! Thank you

Excel

Excel VBA

Project ID: 20369191

About the project

5 proposals

Remote project

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

@aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

£36 GBP in 10 days

4.8

(119 reviews)

5.9

5 freelancers are bidding on average £26 GBP/hour for this job

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

£30 GBP in 40 days

4.9

(306 reviews)

7.8

@KimHyokJun

Hi, glad to bid on your project. I've read the description carefully. I have 10+ years of experiences in software design, development and administration. I have good skills to satisfy your demand, and you can check it from my profile. If I have a chance to work with you, it will be my pleasure. Looking forward to hear from you. Thanks.

£20 GBP in 40 days

5.0

(1 review)

1.0

@urweti

hello sir my name is manoj sinh urweti frome banglore india . your project complite by 6 day my excel working very experiance mu working frome amazon compny frome banglore 2 year

£18 GBP in 28 days

0.0

(0 reviews)

0.0

@shekmodi

Hi, (I have gone through the video and found the issue when you changed the setting from Column 8 to Column 7). We are a young and dynamic startup based out of Bangalore, India. I can help you with problems in Excel (including PowerPivot, Power Query) and VBA. If you need to see the customer ratings (from another platform) please feel free to review my portfolio which is exclusively for Excel-related tasks. Thank you, Abhishek

£25 GBP in 40 days