Microsoft Excel spreadsheet templates with $30 fixed price - repost

In Progress

Create buttons for an action using visual basic for microsoft excel files.

To those who is excel in visual basic language.

Freelance Needed.

Objective:-

Project Description.

Please refer to the example 1 & 2 (attachment) for more in depth understanding about the excel program we use.

Project A

The excel files contain information of customer account no, customer ID, name, service no,

agent id, activation date, registration date, package, basic monthly charge for each column

respectively.

Job A

Multiple VB buttons that can change the way we used to live to the new user friendly interfaces.

Please follow the sample required.

Sample 1

A button that can change format cells automatically in a way such as:-

column "A" = Number without decimal point

column "B" = Text

column "C" = Text

column "D" = Text

column "F" = Date (DD/MM/YYYY)

column "G" = Date (DD/MM/YYYY)

column "H" = Text

column "I" = Number with two decimal point

Sample 2

A button that clear format only for all columns and set default to font type = "calibri" and

font size = "11".

Sample 3

A button that has function of autofit row height and column width for all cells with capable

of removing spaces between content and cell.

Sample 4

A button that has function of auto-insert multiple values into respective cell separately for

column I named "basic monthly charges" by refering to column H named "Package" in a way

such as

Package (column H) Auto-Insert Value into (column I)

VIP 5-New [url removed, login to view]

VIP 10-New [url removed, login to view]

VIP 20-New [url removed, login to view]

VIP 5-Migrate [url removed, login to view]

VIP 10-Migrate [url removed, login to view]

VIP 20-Migrate [url removed, login to view]

VIP 10-Upgrade [url removed, login to view]

VIP 20-Upgrade [url removed, login to view]

BIZ 5 (Dynamic IP) [url removed, login to view]

BIZ 10 (Dynamic IP) [url removed, login to view]

BIZ 20 (Dynamic IP) [url removed, login to view]

BIZ 10 (Fixed IP) [url removed, login to view]

BIZ 20 (Fixed IP) [url removed, login to view]

Streamyx Home [url removed, login to view] RM110 [url removed, login to view]

Streamyx Home [url removed, login to view] RM130 [url removed, login to view]

Streamyx Home [url removed, login to view] RM140 [url removed, login to view]

Business Broadband SOHO OIAB 365 [url removed, login to view] RM150 [url removed, login to view]

Business Broadband SOHO OIAB [url removed, login to view] RM120 [url removed, login to view]

Business Broadband 1IP [url removed, login to view] RM688 [url removed, login to view]

Project B

The excel files contain information of order number, installation done date, voice over broadband no,

billing account no, state (PTT), status, customer name, commission to(ID), primary customer ID no,

package, logic, commission, team name for each column respectively.

Job B

Please follow the sample required.

Sample 1

A button that has function of auto combine/merge two columns into one column for column J named "Package" and

column K named "Logic" in a way such as

Please add "-" in between

Package (column J) Logic (column K) Auto combine/merge (New column name as Package)

VIP 5 New VIP 5-New

VIP 5 Migrate VIP 5-Migrate

VIP 10 New VIP 10-New

VIP 10 Migrate VIP 10-Migrate

VIP 10 Upgrade VIP 10-Upgrade

VIP 20 New VIP 20-New

VIP 20 Migrate VIP 20-Migrate

VIP 20 Upgrade VIP 20-Upgrade

--The End--

Thank You.

Skills: Excel, Microsoft, Visual Basic for Apps

See more: voice over service, voice over job description, voice over description, visual basic price, vip freelance, to excel freelance, templates in c language, status freelance, service spreadsheet, registration number of freelance, project vb freelance, program project freelance, price freelance, microsoft number, microsoft freelance service, microsoft excel spreadsheet, microsoft excel job, job language freelance, job id freelance, job freelance excel, job as a voice over, j freelance, in between job freelance, freelance voice to text, freelance visual c++

About the Employer:
( 17 reviews ) petaling jaya, Malaysia

Project ID: #5462641

Awarded to:

Yuriy29

Dear Tanyewhong, I am ready to do this task for you! I always produce well-functioning and nice-looking products, and would do my best to help you with your task. Wuld you prefer the buttons in the top of the same More

$30 USD in 1 day
(2 Reviews)
1.4

2 freelancers are bidding on average $32 for this job

ethicalboy

Hello ready to start asap, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have More

$34 USD in 2 days
(28 Reviews)
4.7