Devam Ediyor

Excel Template with VBA Program Thing OR a Database Program

We are a retail company and need a program to help us create new items.

We have two files, the main company file and the source file.

The main company file is all the stuff we sell, set up like we want it.

The source file is a collection of tables from the companies we deal with.

Example: We may sell 4 products out of the 100 a company offers. The source file has 100 products, our main file has 4 of the 100 customized how we want to see it.

We need the programming to do two main things:

1. Search the main company file to make sure it doesn't already exist. If it doesnt, then search the Source file to see if it is in there.

2. Based on the company the product is from, the program must make recommendations on how to price it, plus some other defaults. i.e. Brand X should be priced at MSRP (suggested retail price, a field in the source table) minus 20%. Brand Y should be priced at COST (again, a field) multiplied by 1.67. There is the potential right now for 2 different prices. Price 1 and Price 2.

We see the workflow as follows:

1. Scan UPC

2. Check the MAIN FILE to see if it exists. If it does, display about 10 fields from the record. **It is possible to have duplications, so the program should show all matching results**

3. Check the SOURCE FILE to see if it exists there. Same as step 2.

4. The user completes the fields to make a new record. by selecting a row from the MAIN or SOURCE file, it will automatically populate the data entry fields, making data entry easier.

5. Program prompts - what price schedule? Recommended price schedule is displayed based on defaults for that particular Brand. User selects price


6. Program generates a record for import into our POS. it will contain manually entered fields from the previous steps, it will make calculations and add them to different fields, and then auto create results for other fields.


Field Source/Calculation

Plain Description User Entered/populated from file

Size User Entered/populated from file

Expanded Description Calculated: Plain Description & " - " & Size

Price User selects price schedule, program calculates using the selected fields and amounts.

7. Data is added to a "queue". This queue is a list of completed products that will have a csv file generated for import into our pos.

This project should be completed within 24 hours.

clarification and fields posted in the params.doc file!

attached some mock ups of the two main screens.

Beceriler: Veri Tabanı Yönetimi, Excel, Microsoft Access, PHP, Yazılım Mimarisi

Daha fazlasını gör: excel vba database template, database template vba, project excel vba, what is vba programming, what does data entry do, vba programming using excel, vba programming in excel, vba excel programming, thing 1 template, template source file, template prices, queue template, project schedule template, programming in vba, programming in excel vba, programming in excel 2013, product list excel template, prices template, price for vba for excel, out source data entry companies

İşveren Hakkında:
( 31 değerlendirme ) Woodstock, United States

Proje NO: #4505556

Bu iş için 17 freelancer ortalamada $484 teklif veriyor


[i saw your new files and understood the details around] My proposal is as follows 1. Menu driven ms access solution to upload main company file, source file 2. Module to maintain the brand v/s price formula ( Daha Fazla

in %bids___i_period_sub_35% gün içinde472%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(343 Değerlendirme)

Hello, Excel VBA expert here. Please check PM for details. Thanks!

in %bids___i_period_sub_35% gün içinde444%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(61 Değerlendirme)

Looking forward to working with you....

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(63 Değerlendirme)

I have 15 years exp in access. i can build the database you need. Donna

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)

Hello! Let me propose you all the best of my experience with Excel and VBA programming. Thank you! Denis Smolentsev

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(83 Değerlendirme)

Hi, I can prepare this program using foxpro where I have excellent exp. I have completed more than 195 projects and I am top 1% freelancer here. tka and waiting for your positive response.

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(46 Değerlendirme)

>>>>>Genuine and Reliable<<<<<< Let us do this for [login to view URL] are up for a demo [login to view URL] follow all the instructions. EXPERT in VBA Thanks and Regards :-Karan

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)

I am an excel macro expert and interested in this work. Please check your PM

in %bids___i_period_sub_35% gün içinde600%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)

Is it an MS Access application? Could you send me the database file so I will just create the Form Interface together with the VBA Code? Let me know.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(16 Değerlendirme)

Hello, I am Access/VBA automation expert since 11 years. I can handle your project right now. Regards, Fabrice

in %bids___i_period_sub_35% gün içinde272%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Please see detail on PMB. Regards

in %bids___i_period_sub_35% gün içinde833%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

This is my interest of my workings, Ready to start check pm.

in %bids___i_period_sub_35% gün içinde360%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

VBA expert, I can do this job.

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I've made a lot of projects just like this, from 1999. I can do it via Access or Excel, or via external app, as you wish. Regards.

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Daha Fazla

in %bids___i_period_sub_35% gün içinde721%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

We can complet Your task...

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, We at on2itonline would love to work with you on this, we do MAD "full service" websites on a clear and fixed budget. We have lots to offer that others don't ,like our lifetime FREE hosting on every website for a s Daha Fazla

in %bids___i_period_sub_35% gün içinde773%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I have the expertise to make this project a success in the 24-hours you need it done.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

I have almost 20 years of experience in MS Access (all versions) and MS Excel (version 3 trough 2013). For the project I can use VBA or other languages. I can complete the job within one day: 1. if the field names t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)