Excel Macro - Calendar

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.


- 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

Evner: Excel, Visual Basic

Se mere: excel macro fill empty cells, excel macro data cell, office 2007 excel pull calendar data outlook, excel macro export xml, data net web application excel macro, excel macro expert india, excel macro load web site, install analysis toolpak automatically excel macro, excel macro convert weight, excel macro format phone numbers, excel macro copying cell content, compare tables using excel macro, excel macro open files, excel macro export outlook calendar, excel macro outlook calendar, excel outlook calendar macro, excel macro send outlook calendar invite

Om arbejdsgiveren:
( 4 bedømmelser ) Sutherland, Australia

Projekt ID: #23392761

Tildelt til:


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 (g Flere

$200 AUD in 2 dage
(752 bedømmelser)

33 freelancere byder i gennemsnit $140 på dette job


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 Flere

$220 AUD in 5 dage
(337 bedømmelser)

Some nice design touches to this workbook, well done. However, as you have so rightly pointed out, to many programming assumptions have been made and, as a consequence, the 2 worksheets are noticeably out of sync. Th Flere

$225 AUD in 7 dage
(52 bedømmelser)

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Flere

$175 AUD in 3 dage
(88 bedømmelser)

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 informati Flere

$130 AUD in 4 dage
(79 bedømmelser)

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 Flere

$150 AUD på 1 dag
(15 bedømmelser)

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 på 1 dag
(97 bedømmelser)

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 Flere

$140 AUD in 3 dage
(86 bedømmelser)
$50 AUD på 1 dag
(53 bedømmelser)

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 in 5 dage
(14 bedømmelser)

$ 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 på 1 dag
(65 bedømmelser)

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 Flere

$95 AUD in 2 dage
(32 bedømmelser)

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 proje Flere

$30 AUD på 1 dag
(37 bedømmelser)

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 Flere

$80 AUD på 1 dag
(9 bedømmelser)

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 på 1 dag
(7 bedømmelser)

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 Flere

$40 AUD in 2 dage
(7 bedømmelser)

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 mist Flere

$30 AUD på 1 dag
(7 bedømmelser)

Hi Sir, The file I have attached here is done with all changes and corrections. . Sample path : [login to view URL] Please download and review the sample and if you find Flere

$100 AUD in 2 dage
(3 bedømmelser)

Hi , I am a IT professional with experience on office tools like word and excel, VBA macros development for data handling in a spreadsheet .Knowledge on native data structures and routines for multiple purposes like el Flere

$80 AUD in 7 dage
(1 bedømmelse)

Hello, I have expert skills is VBA and excel. I can fix your spreadsheet. Please contact me for additional details.

$130 AUD in 2 dage
(0 bedømmelser)

Hi Sir, I am well experienced data enter working in a well known Online Business website since last 5 years.I can handle your project very well as I am perfect at all skills you have mentioned.I will do your project m Flere

$140 AUD på 1 dag
(0 bedømmelser)