Awarded

Complete My Excel Spreadsheet

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: [url removed, login to view]

The Automatic Number is on Youtube: [url removed, login to view]

The Excel VBA Text to Comments on Youtube: [url removed, login to view]

The Date Picker [url removed, login to view]

Skills: C# Programming, Data Entry, Data Processing, Excel, Visual Basic

See more: Complete my Excel project, need computer expert to setup my excel worksheet in mililani hawaii, i want an excel expert who works on my excel sheet according to my requirements, getting my excel worksheet incorrect, complete my list with mobile numbers, adding formulas and functions to my excel template, sic complete list excel, correct spelling mistakes spreadsheet, sic code complete list excel, complete accounting excel, create complete database excel, complete work excel, complete form excel html, status message paste complete vba excel macro, link date receive date complete data excel

About the Employer:
( 1 review ) Garner, United States

Project ID: #16408982

3 freelancers are bidding on average $243 for this job

cgullapalli

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 over More

$250 USD in 3 days
(649 Reviews)
7.7
zekovicm

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 ag More

$247 USD in 3 days
(51 Reviews)
6.2
kkhoward504

A proposal has not yet been provided

$233 USD in 3 days
(0 Reviews)
0.0