Excel Inventory Program

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

Hi

we are a tyre shop. We have alot of brands and hundreds of sizes of tyres we come across to quote and having difficulty managing specials and updating specials quickly.

we found that every supplier has a excel sheet and thats why we thinking that excel will be a quicker way to do things.

what we looking for is a file where

sheet 1 will be like a home screen.

sheet 2 will be inventory from supplier A

sheet 3 will be inventory from supplier B

Sheet 4 will be inventory from supplier C

each supplier sheet has columns as

Code / Description / Brand / Model / Width / Profile / Rim / Speed / Load / Type / Price 1 / Price 2

In sheet 1 we should be working with

Width / Profile / Rim

if we randomly select 215 / 60 / 16

we should be able to see all tyres match that size from all suppliers on sheet 1.

Data Entry Data Processing Excel Software Architecture Visual Basic

Project ID: #18770931

About the project

81 proposals Remote project Active 5 years ago

81 freelancers are bidding on average $380 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$400 AUD in 5 days
(386 Reviews)
8.1
seaanddream

Hi, my name is Selim. I read your `Excel Inventory Program` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify fu More

$500 AUD in 5 days
(343 Reviews)
8.1
esalem

Hi, I am interested in your project and I am well versed in Excel and the solutions for Excel and using it. Regards, Iyad

$777 AUD in 10 days
(46 Reviews)
7.6
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an inventory in Excel. I plan to use a combination of formulas and VBA code to a More

$450 AUD in 5 days
(259 Reviews)
7.6
branislavm

Hello! I understand that you want an Excel "database", but if I may suggest a real database instead? I am thinking about MS Access database for lots of the reasons and in the first place is shared network usage and More

$333 AUD in 10 days
(245 Reviews)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

$400 AUD in 10 days
(245 Reviews)
7.0
TonmoyRoy111

Hello client I understand the scope of work involved in the project. I can set up an excel spreadsheet as you said. The first sheet will update itself as per the selection from width, profile an rim. I hope to hear f More

$300 AUD in 2 days
(365 Reviews)
7.0
priyal1997

Dear Sir/Madam, I'm happy to help you on this task. I am an expert in both excel and finance, and have already developed a lot of customized inventory models for businesses across the world. you can refer my profile t More

$300 AUD in 2 days
(195 Reviews)
6.8
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the files - I would come up with an Excel based solution as requir More

$250 AUD in 5 days
(201 Reviews)
6.9
latatestTech

With Freelancer Preferred badge bound to give 100% Quality and work till your satisfaction (Let's Chat) Hello, Beign Freelancer Preferred badge + Private Limited agency 100% quality and support for 15 days will More

$666 AUD in 10 days
(29 Reviews)
6.7
dvcontact

Hi, You may not select the right candidate without knowing what your project on creating an inventory Excel workbook having one sheets per each supplier and will be automatically updated when Width / Profile / Rim are More

$250 AUD in 4 days
(55 Reviews)
6.5
ShaunKleinOnline

Hi there, Your automated inventory tracker project for your tire company sounds very interesting and I think I'd make a great fit. I love your idea of how the sheet should be set up with a master sheet (the home scr More

$375 AUD in 7 days
(93 Reviews)
6.6
expertserv

Hello Sir, How many total products are there? Ready to start now. You can check my reviews. I've worked for many drop-shipping stores. I do have a team of 5 experts who can join us in this project. I will perform More

$250 AUD in 3 days
(117 Reviews)
6.6
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write More

$350 AUD in 10 days
(105 Reviews)
6.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$555 AUD in 10 days
(117 Reviews)
6.5
prakash2813

Hi there, I am java developer with 7+ years of experience in web and desktop app development. I have strong expertise in OOP, data structure, trees, graphs, multi threading, cryptography, genetic algorithm implementa More

$600 AUD in 4 days
(57 Reviews)
6.0
nvchien94

Hello there, I am an Excel coder with experience as financial controller and inventory accountant. I understand what you need and I can provide you an Excel file to manage your inventory. It will be very fast and e More

$250 AUD in 1 day
(173 Reviews)
6.1
macroPOL

Hello, I am Excel and VBA expert. I understand the requirements. I can do it in VBA (Excel VBA macros). If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and More

$388 AUD in 5 days
(98 Reviews)
6.1
aimefx

Hi, I am an expert in Excel, Access, VBA and Power bi. I can create an inventory management system for you in Excel or Access whatever you like. I am ready to start your project immediately, Please send me a messa More

$250 AUD in 5 days
(86 Reviews)
6.1
pm9887

Hi There, Need to know more about the complete job description. I have good experience in all type of backend work and spreadsheet task. Let's discuss and work together. Thanks Prakash

$250 AUD in 10 days
(70 Reviews)
5.8