Hello... I input and evaluate my stock trade information on a weekly basis. Each week I need to look at what I did over the week and note what I did right and what I did wrong. I created a spreadsheet and put in some formulas. I need someone to modify, correct and implement the below items. I also need some of the existing formulas fixed. I also need a multi page input form to update the sheet and I am open to any suggestions to improve the spreadsheet. I would like to protect the cells with the formulas and delete the surrounding cell that Are not being used.
I need the following:
Cell B: Automatic number. Protect the column
Cell C Calendar picker
Cell D Formula that combines Cells B & C to form a "Trade ID" in cell "D", protect the column
Cell I: Calendar Picker
Cell K: Calendar Picker
Cells O-W: Protect the column
Cells: Z-AD Protect the column
Cell AE: Autofill (Up or Down) Conditional Formatting (Green "Up" Red "Down"
Cell AF:Autofill (High or Low) Conditional Formatting (Green "High" Red "Low"
Cell AG: Autofill (Yes or No) Conditional Formatting (Green "Yes" Red "No")
Cell AH: Autofill (Yes or No) Conditional Formatting (Green "Yes" Red "No")
Cell AK: Autofill (Yes or No) Conditional Formatting (Green "Yes" Red "No")
Cell AM; Autofill (Yes or No)
Cell AN; Autofill (Yes or No) Conditional Formatting (Green "Yes" Red "No")
Cell AO Autofill (Before or After)
Cell AP: VB code (Text to Comment)
Cell AQ: Autofill VB code (Text to Comment)
Cell AR: Autofill (Long or Short) Conditional Formatting (Green "Long" Red "Short"
Cell AS: Autofill (B2BWDI)
Cell AT: VB code (Text to Comment)
Cell AX: VB code (Text to Comment)
Cell BA: VB code (Text to Comment)
Cell BF: Autofill (Missed (Yellow), Passed (Red), Demo (Blue), Traded (Green) Conditional Formatting
Cells BB, BC,BD Protect the cells
Cell BG: VB code (Text to Comment)
Cell BH: Autofill ( Weekly, Daily, 233, 55,)
Cell BI: VB code (Text to Comment)
Cell BJ: VB code (test to Comment)
Cell BK: VB code Text to Comment)
Cell BL: Autofill (A,B,C,D,F) Conditional Formation (Green "A", Light Green"B", Yellow "C", Orange "D", Red "F")
Below are links to some Youtube videos that have the VBA code examples that I am looking for.
The Auto Complete VBA is on Youtube: [login to view URL]
The Automatic Number is on Youtube: [login to view URL]
The Excel VBA Text to Comments on Youtube: [login to view URL]
The Date Picker [login to view URL]
Hi,
I am good at Excel and vba. I have reviewed the requirements. And is very detail and thanks for providing youtube links.
Looking forward to discuss further in the chat about formula checks etc to get the overall scope of work.
I can implement the ones listed below.
-Chandra
Hi there,I am Miljan,excel expert from Bosnia & Herzegovina,Europe.
I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline.
Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me.
There is a lot of experience behind me, so it will be a huge satisfaction for me to do this job.
Please feel free to contact me so we can discuss further details.
Thank you for taking the time to read my proposal.I am looking forward to hearing from you.
Kind regards