Help finalise Power Query automation

£18-36 GBP / hour

已完成

已发布

超过 4 年前

£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

项目 ID: 20369191

关于此项目

5提案

远程项目

活跃5 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在10天之内

4.8

(119条评论)

5.9

5威客以平均价£26 GBP/小时来参与此工作竞价

@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 在40天之内

4.9

(306条评论)

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 在40天之内

5.0

(1条评论)

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 在28天之内

0.0

(0条评论)

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 在40天之内