Excel Macro - Calendar

$30-250 AUD

Opravljeno

Objavljeno

pred več kot 4 leti

$30-250 AUD

Plačilo ob dostavi

Attached workbook has a macro within but doesnt work correctly - looking for it to either be modified to operate correctly or can be done again from scratch. Required: - On the first sheet (Yearly Calendar), text will be entered into cells - Upon running a macro via a button in the ribbon --> any text within D3:AA5000 to be listed on sheet2 (Plan Table) --> with the cell address from sheet1 listed in columnA --> with the value in Col A from sheet1 listed in columnB --> with the value in Row2 from sheet1 listed in columnC --> with the value in Col C from sheet1 listed in columnD --> with the value within D3:AA5000 from sheet1 listed in columnE --> with the colour format from the row on sheet2 being applied to that cell address on sheet1 --> when the text is deleted from sheet1 it deletes from sheet2 --> when the text is changed from sheet1 it updates to sheet2 --> when a cell is selected on sheet1, the popup box appears showing data (which works now) What is not working: Not everything from sheet1 pulls to sheet2 when text changes on sheet1 it doesnt change sheet2 the row and column references on sheet1 dont transfer to sheet2 the colour formats from sheet2 dont go back to sheet1

Excel

Visual Basic

ID projekta: 23392761

Več o projektu

28 ponudb

Projekt na daljavo

Aktivno pred 4 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ([login to view URL]). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this as I may have some questions. Best Regards, Jay

$200 AUD v 2 dneh

5,0

(872 ocen)

9,3

28 freelancerjev je oddalo ponudbo s povprečno vrednostjo $129 AUD za to delo

@schoudhary1553

Hello, I can help you in making marketing plan using excel macro. 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

$220 AUD v 5 dneh

4,9

(532 ocen)

8,4

@rashedkhanrubel

Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

$90 AUD v 1 dnevu

5,0

(440 ocen)

7,8

@finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

$130 AUD v 4 dneh

4,9

(189 ocen)

6,8

@GopalJp

Hello Sir, I can write proper code in VBA for your description process. I look forward to work with you. Kind Regards Gopal

$300 AUD v 5 dneh

5,0

(36 ocen)

6,7

@AnowarRatul

$ 35 AUD Only ----- In just 5 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.

$35 AUD v 1 dnevu

5,0

(384 ocen)

6,8

@khanicha

Hello, You should consider in implementing the Worksheet Changed events method where any changes on the cell or group of cell can trigger a function. From this you could validate the transfer value. Using this method will warrant the transfer will work correctly Regards, Khamid

$150 AUD v 1 dnevu

5,0

(30 ocen)

6,5

@writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps

$95 AUD v 2 dneh

4,9

(254 ocen)

6,7

@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. So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

$140 AUD v 3 dneh

4,8

(136 ocen)

6,1

@paulodayto08

Hi Good Day! I can work on this today. I can fixed your macro based on your requirements. I've done a lot of tools using MS Excel Macro, please allow me to help you. Message me anytime to discuss more about this project. Thank you in advance!

$30 AUD v 1 dnevu

4,7

(77 ocen)

5,4

@maheshrai640

Hello.... I can do it perfectly ....and i also want to start it now...... Please give me a chance to work with you ...I promise the accuracy of work will be definitely 100%......promise you will not found a single mistake in my work.... Give me the one and only chance for your work.... You will get your delivered in given time.... Chat me to discuss the details so that i can start the work ASAP Thank you.

$30 AUD v 1 dnevu

5,0

(12 ocen)

4,2

@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. If interested, we can discuss this further on chat.

$80 AUD v 1 dnevu

4,5

(23 ocen)

4,8

@yhleow

Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros on a daily basis. I will be able to assist you on this project. Please contact me for more information. Thank you!

$40 AUD v 1 dnevu

5,0

(10 ocen)

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. All the things you mentioned above are doable except color formats going from sheet 2 to sheet1. I mean, when you run the macro initially it would be assumed that there is no data in Plan Table then how will the color formats go from sheet 2 to sheet 1. Could you explain this? Looking forward to have a chat with you and work with you.

$40 AUD v 2 dneh

5,0

(9 ocen)

3,6

@pcruiz

Hi, I am interested in helping you complete this project. I have more than 15 years of experience in developing solutions for excel using vba and/or excel formulas. I am available to work on this daily from 2PM to 8PM GMT or as agreed. Thanks & Regards, Peter

$150 AUD v 1 dnevu

4,7

(3 ocen)

1,3

@adilsaifi789

hello i am Adil Saifi I Will do my best work and will complete the task as soon as possible in reasonable Price.

$140 AUD v 7 dneh

0,0

(0 ocen)

0,0

@pritimall

I have good experience of VBA and I will be able to deliver your project on time with high quality. Looking for the positive response from your side.

$250 AUD v 5 dneh

0,0

(0 ocen)

0,0

@salimyusuf187

Your work will be done according to your requirement. More than 5 years of experience in advance excel and accounting work.

$111 AUD v 2 dneh

0,0

(0 ocen)

0,0

@ayeshameer19

I am interested in this project.I can start right now and available all next 24 hrs.I can make u sample of your work before awarding to trust my accuracy and speedIt will be a pleasure to join your team even for a short while. I have got 12 plus years experience as IT professional as project managers, have been working on documentation along with reporting for corporate world across the country and abroad. Have been working with computer since 2001 onwards. My typing speed in computer and accuracy is excellent. I am confident that I can meet all the technical specifications required by you to your best satisfaction. I am well versed in Microsoft office, Excel and power point presentations. Built this reputation : * High quality * Always deliver job before deadline * Over Deliver but never Over Commit * Over meet Customers expectations * 24/7 Service I hope to hear from you and work with you soon! The desire not to be anything is the desire not to be.....

$140 AUD v 7 dneh

0,0

(0 ocen)

0,0

@ManuKharvi1

I have 5 years of experience in creating vba based tools. I have created 100’s of excel templates using vba. Since this is my first time in freelance. I am willing to do it for free. I can do the request within a couple of hours. If you can please send me an email on my personal email I’d manjunathakharvi@gmail or Vineeth41@gmail and I can revert back to you on the same and I can send you the fixed file. If you like my work and if you want to pay me you can do so how much you want.

$30 AUD v 2 dneh