Custom the excel File using VBA

On the Invoice Work Sheet:

1. Change the entire worksheets color to Black

2. Invoice Numbers should be auto generated starting from 1101

3. When you select payment terms it should automatically give due date in the bottom (Ref Point 6) or Sales Rep, it should automatically give you due date.

Note: Payment Terms, Sales rep details available on ‘customer’ worksheet that should be automatically filled on drop down while creating Invoice

4. Columns in Invoice:

[Product Descriptions] [Price][Order Quantity] [Shipped quantity][Extended Price]

-Remove the Tax Columns

5. Add table below the description section (Remove Other Comments Filled section), which has 6 Rows and Two Columns to reflect the tax amounts for the Invoice

Fed Tax:

State Tax:





5. On the Bottom: Due date Box on the Left with Bold and Little Bigger Fonts on same line with Total Amount due

6. Add Box where we can enter Misc Charges If any which should auto sum to total

7. Add Footer text: We Appreciate your business with us!

On the Summary Work Sheet:

1. Invoices Posted to Summary should be Viewable to edit in future

2. Create a Column, which has drop down box on the Summary, which has such as Options (Paid, Cancelled, Refunded), which can reflect on the Invoices.

3. Search on summary work sheet using customer name or Invoices Grouped in Companies

4. Pop up Alert on All Invoices due in Next 3 days and Past due dates

5. Access & update the file from multiple locations using Google or any cloud source.

On the Items Work Sheet:

1. Columns Needed

-Buy Price

- Sell Price

-Fed Tax, State Tax, Tax1, Tax2,Tax3,Tax4,Tax5,Tax6 – Manual entry for every product. Which should automatically added to Invoice when that items are selected

Note: Some Items may not have Fed Tax or other Taxes.

On the New Work sheet

1. Month to date analysis

2. Year to Date

3. Profit Graph Chart


Habilidades: Excel, Visual Basic

Veja mais: the month may, starting with visual basic, sales rep needed other, sales rep in the us, price for vba for excel, it sales rep, graph using c, excel sheet for customer details, create line graph and line chart, create line graph, create a table chart, create a line graph, business analysis on line, line graph excel, buy and sell items for profit, vba access excel, point cloud, invoice cloud, create excel worksheet, details custom invoice, vba update excel, product entry price excel, excelchart, excel create graph, excel access table

Acerca do Empregador:
( 5 comentários ) Trichy, United States

ID do Projeto: #6810431

Concedido a:


I have over 8 years of experience in Excel and Access VBA. I have developed several Tools, Automation, Dashboard and Online Tools using VBA.

₹1300 INR em 3 dias
(6 Comentários)

14 freelancers are bidding on average ₹1427 for this job


A proposal has not yet been provided

₹1500 INR em 1 dia
(42 Comentários)

Hi, I'm interested in this project. I've kept my bid little hire because the list of work to be done is big enough. Waiting for reply. Thanks, Regards.

₹1500 INR em 1 dia
(16 Comentários)

i can do it for you quickly and exactly .

₹1750 INR in 3 dias
(18 Comentários)

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.

₹1500 INR em 1 dia
(10 Comentários)

Hello, Having seen your post.I would like to place my bid for this project. It would be great if you could initiate chat as freelancers are not allowed to do so on this site and i can understand your exact need or Mais

₹1550 INR em 1 dia
(4 Comentários)

I have 4 years of experience in VBA Macros. I have worked on Automation for Whirlpool Corporation and currently working (freelancer)for Energy Corporation in Poland. From your requirement, the amount you have fin Mais

₹2777 INR in 3 dias
(1 Comentário)

Thank you for this wonderful opportunity. Today Your job posting has caught my attention because Iâ??m keenly considering your job post including these skills. I have excellent experience in Microsoft Office and Admin Mais

₹600 INR em 1 dia
(4 Comentários)

I am an experienced bookkeeper/accountant for almost 5 years. In my current job I do Administrative Functions of the company, Accounts Payable & Accounts Receivable Recon, Bank Recon, Payroll Processing, Government Pre Mais

₹1550 INR em 1 dia
(0 Comentários)

Hi, there, Nice to meet you. I can solve many problems related to Excel. I hope you will hire me. I will do my best for you. Thank you.

₹1450 INR in 0 dias
(0 Comentários)

I work on VB Scripting on MS Excel daily and have good experience in creating tools and modifying scripts prepared with that. I have created many tools and also modified many to make them work efficiently.

₹1300 INR em 1 dia
(0 Comentários)

Dear Recruiter / project owner, N-BITE specializes in providing end to end (E2E) business solutions. Our uniqueness is by tailoring a unique product which will optimize and elaborate your business. Throughout our b Mais

₹600 INR em 1 dia
(0 Comentários)

My name is sujeet Kumar. I have total 4 year experience of marketing Customer satisfaction is my first precedence. I try to provide 100% output in the right time. My work are maintained by our strong management, I am Mais

₹1300 INR em 1 dia
(0 Comentários)

Working in Excel , VBA coding since last 3 year. Master in VBA coding for complex validation in excel and designing excel. Master in Excel To XMl data conversion.

₹1300 INR em 1 dia
(0 Comentários)