Excel Macro Required

$250-750 USD

已关闭

已发布

超过 4 年前

$250-750 USD

货到付款

First, I have attached the spreadsheet that I am talking about. What I need to do is copy all rows from one sheet to other sheets based on the content of cells in one row. I have built the spreadsheet and right now my command button works on 10 out of 16 sheets. It's the same code but for some reason it does not work on some sheets. What I want to do is create one button that copies the rows from a sheet that has all results to the individual sheets that correspond to the data. Also, I need a button to delete all rows in a range from all sheets except for the master sheet that contains all data so that the sheets reset for the purpose of copying across new data. If I don't delete all rows then a macro copying rows will copy the same rows again plus new rows. So let me now refer directly to the spreadsheet. The first sheet, Overall Results, contains all data. At the top are all stats. Below is all data. Now look at sheet "Craig1". As you an see there is a command button and when clicked it copies all rows from "Overall Results" starting at row 16 column B where the cell in column B = "Craig1" This works fine. Sheet Craig2 has the same thing. Same code just modified to refer to Craig2. For some reason though it won't work for sheet "Craig7" for example. What I really want to do though is create just one command button that deletes all data in a range of cells of all sheets EXCEPT for sheet "Overall Sessions". Then I want one command button that brings copies all rows from Overall Sessions to all sheets whose name corresponds with the text in row B of overall sheets. I know this is difficult to explain but if you look at the spreadsheet and the VBA of the command buttons you will understand. I don't want a command button on each sheet named "CraigX". I want to change it to just one command button that will copy all data from Overall Results to all sheets that correspond with the data. And as for deleting data from all sheets called "CraigX" - I want one command button to do that too. In reality this is maybe a 30 minute job for an excel expert. Please quote or message questions.

项目 ID: 23459679

关于此项目

71提案

远程项目

活跃4 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

71威客以平均价$360 USD来参与此工作竞价

@schoudhary1553

Hello, I can help you with your project - Excel Macro Required 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

$350 USD 在7天之内

4.9

(435条评论)

8.3

@paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application fixed. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $350* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 350 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.

$350 USD 在5天之内

4.9

(327条评论)

7.9

@dgled

Hi, you did not attach the file. Hello, I am a financial expert and a guru in Math, Excel, VBA, and Macro. I have considerable experience in merging files, manipulating the data in a structured database, and importing and exporting external files to a structured database in Excel (+ automation with VBA). I work with advanced formulas, pivot tables, visual basics including available interfaces, graphical and visualisation reports, dynamic dashboards, user-forms, drop-down boxes, generator reports, charts (by scripts) and API (trading, google maps SQL etc.). Furthermore, I have experience in accounting, financial statements, consolidating, forecasting, budgeting, costing, cash flow, payrolls,multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I develop financial modules which incorporate complex components of business in a simplified and logical manner. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.

$300 USD 在7天之内

4.9

(94条评论)

7.2

@elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Contact me to discuss the details. Best regards

$300 USD 在3天之内

4.9

(305条评论)

7.3

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.

$250 USD 在1天之内

5.0

(152条评论)

6.8

@dvcontact

Hi, Would you like to see a quick demo of your project on building an Excel macro formula for your spreadsheet before you award the project? You can consider it professionally done. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time

$500 USD 在5天之内

4.9

(65条评论)

6.6

@AnowarRatul

$ 250 Only ------ In Just 12 Hours ------ Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5 Ratting ------- I can start right now, please message me to discuss more.

$250 USD 在1天之内

5.0

(244条评论)

6.3

@vsprybhanu

Hi, I can develop an excel vba program to accomplish your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

$250 USD 在3天之内

4.8

(115条评论)

5.9

@Sercho56

Hi there, I am an Australian-based software developer and completely understand your requirement. I have done projects like this before where I needed to sort results from testing into different groups on Sheet tabs. I will easily be able to achieve your outcome and will work with you to ensure it is exactly what you require. My solution will be efficient and effective. If you have any questions, please PM me.

$250 USD 在1天之内

5.0

(33条评论)

5.8

@nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I am a full-time freelancer, I can start working on the project immediately and complete the job within some hours. If you send me a sample file (unfortunately you forgot to attach the sample file) I'll make a free pilot for you. Regards Regards

$250 USD 在1天之内

4.9

(64条评论)

5.7

@IgeS

Hi there, Please attached the spreadsheet thus we can check it. thank you I'll be standing by to help -reggie

$250 USD 在5天之内

5.0

(33条评论)

5.1

@paulodayto08

Hi Good Day! I am willing to help you to complete this work but I can't find any attachments. Can you message me and share to me your file so I can assess it? I've done a lot of Reports and Templates using MS Excel and VBA Macro. I am a VBA Developer for 8 years now, I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Message me anytime to discuss. Thanks!

$250 USD 在1天之内

4.8

(64条评论)

5.3

@Bsram88

Hi, I could not find file name Craig1. Please reattach. And kindly chat with me over private chat. Lets discuss about the process in details. Thanks, Ram

$250 USD 在3天之内

5.0

(17条评论)

4.4

@dheerajjshetty19

Hello!! Am very interested in ur project and I'm an expert in Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.

$250 USD 在3天之内

5.0

(24条评论)

4.3

@merinsinha

I have a question--Need the file with VBA coding to understand current status of the application and future prospect of the codes to meet the requirements.

$300 USD 在1天之内

4.7

(63条评论)

4.8

@sdroberts

Hello I would be happy to help with your excel issue. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I look forward to working with you soon. Kind regards Steve

$285 USD 在3天之内

5.0

(8条评论)

4.0

@MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with Excel and VBA. It will be quick and accurate. I will start right away and complete it within an hour. If interested, we can discuss this further on chat.

$250 USD 在1天之内

4.5

(24条评论)

4.6

@VinayOnTask

Hi there, I'm working on data processing and excel programming projects from last 10 years. kindly let me know what needs to be done to secure this bid. Thanks

$255 USD 在3天之内

4.8

(11条评论)

4.2

@yhleow

Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros and excel template on a daily basis. I will only charge you $100 for this project. Please contact me for more information. Thank you!

$250 USD 在1天之内

5.0

(11条评论)

4.1

@habalghost22

Hi , I am an MBA professional having 4yrs of experience in Analytics, Advanced Excel, VBA, Python and Tableau. I have done ample amount of work in excel and VBA and I could show some examples of it. I think 250$ is too much for such small work and should be around $50. Also you have not attached the excel sheet hence it's difficult to interpret some of the thing you want to be done. Looking forward to have a chat with you to have a look at the excel file to understand the project better.

$250 USD 在2天之内