In Progress

Database creation in excel with features

Hi Freelancers,

I need a custom excel document to update a series of pages from a central catalogue page. The core of the task is to make the other pages dynamic so if new part numbers are added to ‘Product List’ Page ‘The full part number list’ will automatically update. A Description of the dynamic update tasks are listed on each of the pages necessary. The only pages need to be included in the automatic update are ‘The Full Product List’ and ‘Labels’.

A working example of the spread sheet with a selection of part numbers will need to be sent through for analysis and approval. After this the completed spread sheet will need to be submitted before full milestone payment will be transferred.

If a bidder has a more efficient database idea that could also be suitable using a different program I am open to bids that may use a different program or system, these will be assessed on their price and benefits over using excel.

Requirements

- Must be dynamic so as we add new part number the other pages update automatically

- Sample file must be sent through for testing before completed file

- Completed file or system must be sent through before milestone payment is release

- Another program or system can be used (this may mean a higher bid price if the system is better or more convenient)

I am able to assist with any questions. I have attached a copy of the excel spread sheet that the project is for. Please only consider the first three work sheets.

Skills: Data Entry, Data Processing, Database Administration, Excel, Microsoft Access

See more: mean freelancers, make a spread sheet, freelancers with number, freelancers for testing, freelancers excel, freelancers catalogue, freelancers benefits, features of data processing, dynamic freelancers, database of freelancers, database creation freelancers, custom list in excel, automatic data processing, automatic data entry in excel, database creation excel, benefits for freelancers, assessed freelancers, program creation, price excel, higher freelancers, excel working freelancers, excel spread sheet, document database, data entry with spread sheet, data entry in excel sheets

About the Employer:
( 30 reviews ) kensington, Australia

Project ID: #2355567

Awarded to:

redsentra

Hi, Excel data processing expert here who has done similar project, and am ready to start immediately. Refer PM for details.

$250 AUD in 3 days
(20 Reviews)
4.4

17 freelancers are bidding on average $272 for this job

rhomeu

MS Access expert here. This can be nicely done in MS Access 2007/2010. See PM for details.

$400 AUD in 3 days
(39 Reviews)
6.5
bharanisrihari

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

$250 AUD in 2 days
(59 Reviews)
6.3
pipo1982

I can help

$300 AUD in 7 days
(34 Reviews)
6.0
danielgpratidya

I bet I can complete this in less than one day

$250 AUD in 1 day
(64 Reviews)
5.4
Teloquence

Consider it done. Check your PM for my bid details.

$250 AUD in 2 days
(49 Reviews)
5.2
binaryromel

##### Excel expert here! Please check PM. #####

$250 AUD in 3 days
(45 Reviews)
5.2
Nhcuong

Hi, i can do it with VBA in excel. This kind of work dont need Access if you have single user working on data. Looking forward to hearing you, Cuong NH

$290 AUD in 10 days
(24 Reviews)
5.0
winnet21

Hi, I have experience in this project, very happy to work with you in this project regards

$250 AUD in 7 days
(12 Reviews)
4.7
instech

12+ years of database programming experience. Please see the PM for comments.

$250 AUD in 4 days
(6 Reviews)
4.6
NiceDeveloper

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve, for more info and demo preview please cheek your message box for this project(Private)

$250 AUD in 7 days
(7 Reviews)
4.5
ActualCreative

I have excellent macro and script building skills. I can do this for you easily.

$250 AUD in 3 days
(10 Reviews)
3.7
asifkhan268

Dear Hiring Manager, I am from india.I am a graduate working from home to make extra income.I have good knowledge and experience of data entry works. I reviewed your job proposal and my responsibility.I think that More

$251 AUD in 17 days
(4 Reviews)
2.1
NemethNoemi

Small amount of time, precision.

$250 AUD in 1 day
(1 Review)
1.0
rups1977

v Greetings! Hello & Good Evening. I'm a new freelancer and I would like to do this job at the earliest. I have excellent typing skill (50wpm). I have working knowledge in Microsoft Excel, Word and HTML. More

$350 AUD in 3 days
(1 Review)
0.0
Root2squared

Hi, Greetings!! I went through your job post and excel sheet. I have following querries: 1. Need elaboration on central catalogue. Is it excel woorkbook or some database [url removed, login to view]"Full Part Number List" sheet, col More

$280 AUD in 7 days
(0 Reviews)
0.0
nsumaya

I'm a MS Access, MS Excel expert. Consider your requirement done in less than one day only. With great Quality.

$250 AUD in 1 day
(0 Reviews)
0.0
RSKemp

Excel expert with 10 years of experience. I do this every day and will provide optimal solution. Please see PM.

$250 AUD in 1 day
(0 Reviews)
0.0
PcsPvtLtd

check ur pmb...

$250 AUD in 25 days
(0 Reviews)
0.0