Microsoft Excel spreadsheet templates

Cancelled

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, vip freelance, to excel freelance, templates in c language, status freelance, service spreadsheet, registration number of freelance, project vb freelance, program project 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++, freelance visual, freelance vip account

Project ID: #5448564

17 freelancers are bidding on average $31 for this job

zExcel

A proposal has not yet been provided

$50 USD in 1 day
(45 Reviews)
5.7
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$30 USD in 4 days
(37 Reviews)
5.0
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here a More

$50 USD in 1 day
(21 Reviews)
4.6
ethicalboy

Hello ready to start asap, I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident that I can do this project based on your requireme More

$49 USD in 1 day
(25 Reviews)
4.6
Edison1983

*****Similar work- Please check my IOHL Project, Hotel Management Project having similar functions in my Portfolio**************** Good Day!.. I'm a VBA Programmer, having 7 years of Experience. Have developed & de More

$50 USD in 0 days
(16 Reviews)
4.1
toxicman

Hello I'm a software engineer with good knowledge in excel macros. Assume it's done. B.sc of computer science

$25 USD in 1 day
(10 Reviews)
3.8
paris2785

VB and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: 1.Real Estate (video demonstration) 2.Orders (video demonstration More

$25 USD in 3 days
(7 Reviews)
3.7
adityasl

Hello, I am an excel expert. I have created Sample 1,2,3 for Project A. Can you please clear Sample 4 for project A? I will work on Project B after completing project A. Looking forward for the reply. R More

$10 USD in 1 day
(19 Reviews)
3.6
vaibhav585

Respected Hiring Manager - I have read your post and have understood it clearly - i am confident that i will be able to get this work done - I am willing to start this work immediately, I have bid for least price and g More

$23 USD in 1 day
(11 Reviews)
3.4
d2imatrix

Hi, We have gone through both the excel files you have sent. We can do this.Each button can be created with the functionality you have asked for. Every time you make a new entry into your data sheets, you press the bu More

$25 USD in 1 day
(1 Review)
3.2
AndroidAll

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.

$30 USD in 0 days
(3 Reviews)
3.2
srdas2012

Hi, We are Expert in Excel & Excel based programming Macro VBA/VB6/VB.Net .We have seen your requirement Ready to make the changes as per your Requirement..(We will be able to send you any message or Sample files On More

$47 USD in 2 days
(5 Reviews)
3.1
teeares

Most of what is desired can be accomplished except that fof default formating of the workbook, for which a file has to be placed in the start directory and the workbok closed and reopened again

$25 USD in 1 day
(7 Reviews)
2.7
burhan393

Hi I have worked on many Excel VBA Projects from simple to complex. I have also completed a Project for a Fortune 500 company - Emerson. Here at freelancer.com, I have successfully completed 3 projects. I love to work More

$15 USD in 1 day
(3 Reviews)
2.2
jawadaman

Hi, I can do this job for you. I have extensive experience in MS Excel and VBA programming. Please let me know if interested in hiring me. Thanks. Regards, jawad

$20 USD in 1 day
(2 Reviews)
1.7
ttitto

A proposal has not yet been provided

$30 USD in 1 day
(1 Review)
0.4
bvan83

This is very simple and doesn't actually need a high level of VBA expertise to be honest. These are some basic things which are required while designing dashboards. So I will be able to do it in 2 hours . Let me know i More

$25 USD in 1 day
(0 Reviews)
0.0
davidgrs

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
frech4791

I have worked extensively with Visual Basic for Applications for all MS Office products and this project is fairly straight forward. A small user-interface can be made to "float" on top of the spreadsheet. This inte More

$25 USD in 1 day
(0 Reviews)
0.0