Concluído

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.

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

Habilidades: Excel, Visual Basic

Veja mais: 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

Acerca do Empregador:
( 3 comentários ) Sutherland, Australia

ID do Projeto: #23392761

Concedido a:

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

$200 AUD em 2 dias
(749 Comentários)
8.5

33 freelancers estão ofertando em média $140 para esse trabalho

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 Mais

$220 AUD in 5 dias
(336 Comentários)
8.0
wsh2

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 Mais

$225 AUD in 7 dias
(52 Comentários)
6.4
SShtv

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 Mais

$175 AUD in 3 dias
(87 Comentários)
6.0
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 Mais

$150 AUD em 1 dia
(15 Comentários)
5.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 informati Mais

$130 AUD in 4 dias
(78 Comentários)
5.7
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 em 1 dia
(93 Comentários)
5.4
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 Mais

$140 AUD in 3 dias
(86 Comentários)
5.7
$50 AUD em 1 dia
(53 Comentários)
5.5
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 in 5 dias
(14 Comentários)
4.6
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 em 1 dia
(64 Comentários)
4.8
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 Mais

$95 AUD in 2 dias
(31 Comentários)
5.0
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 proje Mais

$30 AUD em 1 dia
(36 Comentários)
4.5
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 Mais

$80 AUD em 1 dia
(8 Comentários)
3.4
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 em 1 dia
(6 Comentários)
2.8
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 Mais

$40 AUD in 2 dias
(6 Comentários)
2.7
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 mist Mais

$30 AUD em 1 dia
(6 Comentários)
2.2
cooperfrank

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 Mais

$80 AUD in 7 dias
(1 Comentário)
1.3
Vitaly321

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

$130 AUD in 2 dias
(0 Comentários)
0.0
Isuruu9999

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 Mais

$140 AUD em 1 dia
(0 Comentários)
0.0
$222 AUD in 3 dias
(0 Comentários)
0.0