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
33 freelancere byder i gennemsnit $140 på dette job
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.
$ 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.
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!