Make an invoice tracking spreadsheet more dynamic (VBA if needed)

I have a spreadsheet that I want to make more dynamic. When I select a specific month (e.g. January), I do not want select each and every cell to enter the information. I want to lock all the cells because there are a lot of users who use this spreadsheet, therefore I want to eliminate any errors or erased data. This is a simple task that I can do. However, I want to have a form that pops up and asks for the information that the user should enter rather than entering it in each cell (Date initiated, part number, quantity inspected, % Defective, Invoice, projected, etc).

In the month's tab where it says "Sorting Company", I want to have that also in the form that pops up, and if I want to add a new sorting company, I want to be able to do it easily using the form too (maybe a drop down list that contains the names of the sorting companies and a blank item for new companies) inside the form.

I want the form to be in the month's tab where I can click to enter data.

This will apply to every tab (every month).

If you have any other ideas, please let me know.

Please let me know how much this costs. It shouldn't be that bad.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel vba inventory management template, excel vba inventory macro, excel vba stock control, excel vba macro management stocks and warehouses full version, invoice and stock management in excel, vba code for inventory management vb, excel vba inventory management download, inventory management in excel template, make text field ascending order vba, job tracking spreadsheet, import spreadsheet database vba, import spreadsheet access vba, group sales tracking spreadsheet, free sales tracking spreadsheet, excel opportunity tracking spreadsheet, cms make invoice, bid tracking spreadsheet, automatically make invoice, spreadsheet projects vba, create customizable spreadsheet layout vba

Tentang Majikan:
( 3 ulasan ) Grand Rapids, United States

ID Projek: #15853179

Dianugerahkan kepada:


Hello, I’m an Excel/VBA expert and I would like to help you improve your invoice file. Please check my profile and contact me to discuss further details. Regards.

$80 USD dalam sehari
(281 Ulasan)

6 pekerja bebas membida secara purata $108 untuk pekerjaan ini


hi,i read your project,i am excel expert,please send me message,i am ready for your project Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps Proposed Milestones $ Lagi

$45 USD dalam 2 hari
(75 Ulasan)

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard. Relevant Skill Lagi

$100 USD dalam sehari
(35 Ulasan)

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks. Relevant Skills Lagi

$166 USD dalam 3 hari
(17 Ulasan)

Fixing your Invoice Tracking excel-sheet Relevant Skills and Experience Expert in Excel Proposed Milestones $100 USD - Milestone | Excel sheet

$100 USD dalam 3 hari
(7 Ulasan)

v Relevant Skills and Experience v Proposed Milestones $155 USD - v v

$155 USD dalam 3 hari
(0 Ulasan)